|
Did you try to find the answer yourself before posting?
It took me 3 seconds to find this[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Yes, I even try to figure out the reason, I'm puzzled still.
Why can't be -> sp.StateProvinceID = p.StateProvinceID, instead of p.StateProvinceID = p.StateProvinceID ?
NEWBIES - Aaron
|
|
|
|
|
DotNet wrote: Why can't be -> sp.StateProvinceID = p.StateProvinceID, instead of p.StateProvinceID = p.StateProvinceID ?
It's a typo. It should be
sp.StateProvinceID = p.StateProvinceID
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thanks a lot, Paul...
NEWBIES
|
|
|
|
|
hi , how can I Enable/Disable Remote Connection by Script?
thanks in advance
|
|
|
|
|
select answer from forums where forum_name like '%remote%'
This is the forum for SQL/ADO/ADO.NET. Your remote connection question have little chances to get an answer here...
Nuclear launch detected
|
|
|
|
|
Hi,
Anyone knows how to use login control and how to connect it with the SQl server 2005 and connect to the table within my application database. So it can match the values from the table I have already created in my database.
Rock Star
|
|
|
|
|
|
I shall ignore
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
select (5/7) always result 0 .... how can i correct this result ?
plz help
|
|
|
|
|
SQL-Server assumed that you wanted an integer result because both of the operands were integers.
Try: select convert(float, 5) / 7
Regards
Andy
|
|
|
|
|
hi there,
i have 2 table, first have 2 columns(ID, Name) here ID is primary key
second have 9 columns (ID, 1, 2, 3, ... 8) here ID is primary key too
in second table column names from 1 to 8 have ID Numbers from Table First(which is primary)
and i want to make them foreign keys (from 1 to 8) so that if i delete ID from first table then the action that is set to "Set Null" will set that cell to null
for example
first table have data like this
[ID] [Name]
15 ABC
16 ERT
17 GHJ
18 LKI
in second table :
[ID]_[1]__[2]__[3]__[4]__[5]__[6]__[7]__[8]
14___16___18___17___15___17___17___15___15
15___18___18___17___16___18___18___17___15
16___15___18___16___15___17___17___16___15
now what i want, if i delete ID 16 from first table then the value 16 in table second shoul be set to "null" (from 1 to 8) so it will look like this:
[ID]_[1]__[2]__[3]__[4]__[5]__[6]__[7]__[8]
14________18___17___15___17___17___15___15
15___18___18___17________18___18___17___15
16___15___18________15___17___17________15
to do that i make 8 relationships, and set all actions as
update = cascade
delete = set null
but when i save it, it give error
'firsttable' table saved successfully
'secondtable' table
- Unable to create relationship 'FK_secondtable_II_firsttable'.
Introducing FOREIGN KEY constraint 'FK_secondtable_II_firsttable' on
table 'secondtable' may cause cycles or multiple cascade paths.
Specify ON DELETE NO ACTION or ON UPDATE NO ACTION,
or modify other FOREIGN KEY constraints.
Could not create constraint. See previous errors.
i want both actions, but sql is not allowing me to do that
it can be done by this, but i dont want to use this method
update secondtable set [1] = NULL where [1] =
update secondtable set [2] = NULL where [2] =
update secondtable set [3] = NULL where [3] =
update secondtable set [4] = NULL where [4] =
update secondtable set [5] = NULL where [5] =
update secondtable set [6] = NULL where [6] =
update secondtable set [7] = NULL where [7] =
update secondtable set [8] = NULL where [8] =
some have any solution?
thanks
-- modified at 7:26 Thursday 22nd November, 2007
Becoming Programmer...
|
|
|
|
|
Hi,
I am having a problem.Actually what i want is to find the Dates between particluar Dates like how many dates between two dates.For this i dont have any table.Then after i want to store this resultset in the Temporary Table.
i have done lots of RNd but didn't get the ans.
Thanks in Advance
Avesh
|
|
|
|
|
hi
you have to give the values for from date and todate
while @fromdate<=@todate
begin
insert into #Temp(fdate) values(@fromdate)
set @fromdate=dateadd(day,1,@fromdate)
end
Regards
Joe
|
|
|
|
|
Hi all ,
What's the most secure way for executing dynamic sql from a .Net App in your opinion?
Thanks in advance ,
|
|
|
|
|
A few quick tips:
* Use parameters as much as possible.
* Validate EVERYTHING.
* If you are needing to dynamically set the name of tables or columns then have your SQL check the existance of the table first (A lookup on INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS will help here - remember to use parameters to pass the table name)
* Validate EVERYTHING.
* Run the code in the most restrictive account possible.
* Validate EVERYTHING.* Call stored procedures and have the SP validate the parameters and generate the dynamic SQL.
* Validate EVERYTHING.
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
Hi,
I am in the process of transferring the data from MSSQl database to MYSQL database.
I went through a code snippet which as in vb, in transferring the data (I mean content of tables).
I got this info from SQL DTS.com (Bulk Export Task) can any one here who did this sort of job earlier using C#?
I downloaded the required dll but wanna to have a code snippet in C#.
If any one knows please help me.
Thank you in advance
Raghavendran.
Raghavendran
|
|
|
|
|
recently i appeared for an exam... below question was asked:
You work as a database administrator.
You need to install a new SQL Server 2005 instance on a newly installed Windows
Server 20003 server named Server2. This new instance must have the same settings as the existing SQL Server 2005 instance on a server named Server1.
The only two services that need to be installed are the SQL Server service and the
SQL Server agent service.
The default installation folder should be used for the new SLQ Server instance on Server2. You will be able to refer to Server1 to view the settings to use.
You need to complete the installation wizard on Server2.
What operations do i need to perform....
(i dnt hv much experience on sql i am a beginner.)
Sailaja
|
|
|
|
|
potlakayala wrote: What operations do i need to perform....
(i dnt hv much experience on sql i am a beginner.)
Then why were you sitting an exam in that area?
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
can any body helps me to know the error meaning of address524F4241
thanks
mahen
|
|
|
|
|
Can you be more specific on what you are trying to do and when is that error popping up?
Once you have mastered the ability to turn yourself invisible at will, and to deflect bullets with your hair, you will be ready to come back here to the lounge and post programming questions.Only at this point will you be able to dodge the fireballs that are going to come your way. - Pete O'Hanlon
|
|
|
|
|
am using DELPHI WITH oracle back end..
when i open one form.. and trying to open another form with out closing the previous one.. this error pops up..
...
will tell u in brief..
i asigned F3.. to pop up.. company selection screen..
say i had opened one company.(HR)SCREEN. and AND WITHOUT closing the main form am pressing F3 and the company selection pop screen comes up. and selecting one more company.. and that time this error pops up..
but i had writen the code.. as close previous company screen and open new..
but not closing the main menu..screen..
hope u got some idea
thanks
mahen
|
|
|
|
|
How to display starting character only capital.
21 Nov, 2007
Author: Thirumurugan.D
hi friends,
am using one table,there is 3 field(name,address,father name) is having.but inserted totally 5 records.In all column data first character small letter.
example :(Database)
Name Address Father Name
raja salem rajasekar
laxman chennai anbuselvan
bala bangalore muthu
senthil covai durai
arun hosur ganesh
Note :
Am using front end repeater control.I want display all column data starting letter in capital letter.help me very urgent
I want display the front end form is example :
(FRONT END):
=============
Name Address Father Name
Raja Salem Rajasekar
Laxman Chennai Anbuselvan
Bala Bangalore Muthu
Senthil Covai Durai
Arun Hosur Ganesh
with Regards,
D.Thirumurugan.
|
|
|
|
|
First of all, don't cross post.
Secondly, you asked the same question a few days ago and were given some advice. Why are you asking the same question again?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
pmarfleet wrote: Why are you asking the same question again?
He probably figures he might get a better answer.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|