Viewing 15 posts - 12,916 through 12,930 (of 18,923 total)
What is it you need to do exactly??
September 26, 2005 at 7:16 am
Well actually everything gets updated to 'N'.
You don't need the exists clause here, just use a left join to make this update >>
UPDATE A Set A.col_1 = CASE WHEN B.col_1...
September 26, 2005 at 6:55 am
Search on this site or the web... quite easy to find.
September 24, 2005 at 7:29 am
Here's the script version :
alter dbo.TableName
add ColumnName int not null identity(1,1)
GO
much simpler... and can be reran whenever needed.
September 23, 2005 at 5:04 pm
Oh, can't help you there...
.
September 23, 2005 at 5:02 pm
You shouldn't get errors if you add a primary key.
You can always import the data, then add the PK...
September 23, 2005 at 2:50 pm
Just go with the with encryption.
Make sure that you have backups of the code cause you won't be able to access it again.
However I must tell you that there are...
September 23, 2005 at 2:49 pm
No real hurry here... Gonna have to hurry if I don't want to miss the week-end
.
September 23, 2005 at 2:48 pm
...Been told that for 15 years...
Time will tell.
September 23, 2005 at 2:40 pm
Post the code. You are not using the insert/deleted tables correctly and probabely using variables when you shouldn't.
September 23, 2005 at 2:39 pm
Don't know how to change it but it can make a difference if there's too much noise on the network.
September 23, 2005 at 2:20 pm
I'm not the kind to fall for that
.
September 23, 2005 at 1:59 pm
So you're afraid of girls, how is it you are married??
September 23, 2005 at 1:55 pm
Viewing 15 posts - 12,916 through 12,930 (of 18,923 total)