Viewing 15 posts - 58,411 through 58,425 (of 59,048 total)
You could convert this to a sproc or use it as is...
SET @ObjectToFind = 'PutNameOfObjectToFindHere'
so.Name,so.XType
FROM dbo.SysObjects so,
dbo.SysComments sc
...
January 29, 2006 at 3:49 pm
Ok, thanks... always a pleasure Sergiy.
January 28, 2006 at 8:40 pm
I agree with PW... store the date as a DateTime field or you'll kick yourself in the near future.
One method to display the date from a DateTime column using the...
January 28, 2006 at 12:44 pm
Serqiy, As you are aware, in MS-SQL Server 2000, you can't create a variable with the TEXT datatype. Where did you store the 20k XML before you used it as...
January 28, 2006 at 12:37 pm
Roger that! Confirmation in both directions is always a wonderful thing...![]()
January 28, 2006 at 9:07 am
It doesn't work quite like you'd expect... although the VALUE of the seed works as posted above and in Books-Online, it doesn't work WHEN you'd like it to if you...
January 28, 2006 at 8:28 am
It could also be a 2 digit year Julian date format in the form of DDDYY where "DDD" is the day of the year. But, as many have already said,...
January 27, 2006 at 7:21 pm
Hmmmm... Ken, I can't say I agree... here's some test code to demonstrate why...
The first part of the code makes a test table of a million rows. After all, if...
January 27, 2006 at 7:01 am
Yakov,
As many have said, this is (or should be) common knowledge. But, I for one, appreciate your boldness for publishing what you did. You found a nifty tool in Query...
January 27, 2006 at 4:22 am
Uh huh... The only difference between what you and the author did is you didn't list all the steps.
January 27, 2006 at 4:10 am
Sysobjects will have new pages and extents for each new table.
And, I have to discount DTS as always slower... I've always been able to beat it.
January 25, 2006 at 10:40 pm
set @sPool = 'w' + RTRIM(@sPool) + 's'
print @sPool
January 25, 2006 at 10:34 pm
Dang... didn't read the post close enough... my apologies for the previous lamer post.
January 25, 2006 at 4:51 pm
To add to my previous, RayM's answer is absolutely correct. Further, if you have to do such a thing on a hundred thousand rows to send as a file, then...
January 25, 2006 at 7:19 am
I really wish people would stop saying that... sometimes SQL is the only client application you have.
January 25, 2006 at 7:11 am
Viewing 15 posts - 58,411 through 58,425 (of 59,048 total)