What is the result of

DECLARE @var AS...

What's wrong with this query?

select
category_nm
, q.category_id
, count(*)
...

What would this match in a regular expression?

^(com|net|edu|org)

In SQL Server 2000, are GUIDs created with...

Deleting Sets of Rows in huge table

There was a problema user was reflecting http://groups.yahoo.com/group/sqlcon/message/1119What I did was following steps1. Divide the count of table into segments for divide2. Then use the even Odd functionality for smooth looping3. Use a simple while loop and SET ROWCOUNT functionality for further deletions across table with checkpoint4. It saved the log swell up and resources […]

Which result is returned?

Select
Case
When Round(convert(float,1.135), 2)...

What results do you get from this?

SELECT...

Scrip to export excel file in a Loop

Script to Get Exl Output in a Do while loop. Example taken is Authors table in PUB database, where excel is generated for each state the file in state name.U can modify the script to include filename in u'r format (eg. state + date)

Global System UDF to return ISO Date string

Updated for Permission assignment change 1/11/1006. Ok, I'll bet that you are asking, What is a Global System UDF, right? By Global I mean that the UDF is available from any database on the server. By System I mean that the two part naming rule does not apply to this scalar function. The UDF conversion […]

You have an extremely long (> 100 lines) stored...