every quote that exists between your forst and last...

you've got to look at the execution plan to be sure...

a simple SELECT TOP 2000 FROM SOMETABLE would probably not bloat temp db, but throw in an ORDER BY, and...

I currently maintain a system that does EDI 864 records;(?? didn't really notice they are numbered)

if you have the schema and sample EDI file, I could look to see if...

I've been in touch with some of the guys at a SQLServerCentral related site http://www.sqlshare.com/ to build on skills i do not get to use every day.

I met a few...

this caught my eye, i've done a lot of stuff with following foreign key chains;

how would you expect the table T2 to be displayed? it has two children inder it...would...

just like sa and Builtin\Administrators, and login you create that is part of the sysadmin will inherit the ability to do anything to any database.

CREATE LOGIN [superman] WITH PASSWORD=N'NotARealPassword',

DEFAULT_DATABASE=[master],...

it looks to me that although logically the unique key is just two columns, in actuality for db purposes, shouldn't it include the deleted column as well?

Field1 ...

rvasanth

If this is more for documentational purposes, and not something you are trying to run live for every query, I think i have a potential solution. As already...

it's not truncating the data, jsut the display of it;

change this setting in SSMS: it's Under Tools>>Options; the default is to limit the results to 256 characters, like you've identified.

ok, still easy to do...can we assume the query results will be seen in text mode?

yes, if you have a valid username/password, you can connect multiple times.

different people can connect from other computers using the same username and password as well.

there is no practical limit...

i feel for you;

i did a search for "ascii art hearts" and found lots of examples;

i found this nice one ad wrapped it with the SELECT...UNION ALL, same that your...

I've got a snippet I put together that searches for invalid views/procs/functions; if those objects don't compile anymore, it has to be due to a dependent object like a table...

a fairly common question, actually; search for "unused procedures" and "unused tables", you'll see a ton of discussions, all pointing to Lutz's conclusion: any process, whether a trace or anything...

damn Lutz; your's looks much better than mine, so i decline to post it 🙂

very nice job.

blade, if you look at Lutz's contribution, it's doing all your updates as calculations...no...