Script to Generate DataDictionary for Database

This Procedure is used to generate the datadistionary for a database.It gives following columns : table_id, table_name,column_order,column_name, column_description Usage: Create the Procedure in the database where the datadisctionary need to be generated.Call : Execute Generate_getDataDictionary Return the result in Tabular format.

What's wrong with this query?

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

Cross-Tab reports in SQL Server 2005

Microsoft introduces new operators PIVOT and UNPIVOT in SQL Server 2005. Traditionally we create queries using the CASE statement and aggregate function in order to produce cross-tab reports. This article illustrates the usage of the new operators, PIVOT and UNPIVOT.

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