You could convert this to a sproc or use it as is...

DECLARE @ObjectToFind VARCHAR(200)

SET @ObjectToFind = 'PutNameOfObjectToFindHere'

 

 SELECT DISTINCT

        so.Name,so.XType

   FROM dbo.SysObjects so,

        dbo.SysComments sc

 ...

Ok, thanks... always a pleasure Sergiy.

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...

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...

Roger that!  Confirmation in both directions is always a wonderful thing...

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...

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,...

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...

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...

Uh huh... The only difference between what you and the author did is you didn't list all the steps.

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.

set @sPool = 'w' + RTRIM(@sPool) + 's'

print @sPool

Dang... didn't read the post close enough... my apologies for the previous lamer post.

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...

I really wish people would stop saying that... sometimes SQL is the only client application you have.