Lab Sql

I have this business_table ref_ID name parent_id ----------------------------- ABC-0001 … Read more Hierarchical Query Match With Multiple Tables Its Challenging

I need to order attribute names in alphabetic order and I've created following code, but it lef… Read more Order Attribute Names In Xml Using T-sql

What is the most elegant way to create a string of binary zeros, of type varbinary(max), if the len… Read more Create A Binary String Of Zeros, With Variable Length

Say I have a table with 100,000 User IDs (UserID is an int). When I run a query like SELECT COUNT(… Read more Higher Query Result With The Distinct Keyword?

I would like to take the Getdate() results of, for example 2011-10-05 11:26:55.000 into 11:26:55… Read more Get Time From Getdate()

While renaming the column name, the square bracket is included in the column name, which I think is… Read more Is This A Problem In The Sp_rename Function Or Sql Server Itself?

I have a VARBINARY(MAX) field in a database table which contains ~35k characters. This field is a c… Read more Copying A Large Field (varbinary(max)) To File / Clipboard

Possible Duplicate: how do find the number of rows in a table when the table name is in a variable?… Read more Use A Variable For Table Name