Fast Guide: SQL Server 2000 commands

Download this free guide

Download: 60-Page Expert RDBMS Guide

Trends come and go, but your DB strategy shouldn’t be a flavor of the month. Learn why you shouldn’t get distracted by new DB technology, how Facebook is using a RDBMS to do the data slicing and dicing they can’t in Hadoop, and more.

Start Download

• Corporate E-mail Address:

  You forgot to provide an Email Address.

  This email address doesn’t appear to be valid.

  This email address is already registered. Please login.

  You have exceeded the maximum character limit.

  Please provide a Corporate E-mail Address.

• • I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

  Please check the box if you want to proceed.

• • I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.

  Please check the box if you want to proceed.

By submitting my Email address I confirm that I have read and accepted the Terms of Use and Declaration of Consent.

Here are ten SQL server 2000 commands you need to know!

1. This allows you to read ten rows from a table.

select TOP 10 * from TABLE_NAME

2. This is used to show the text for a given stored procedure.

EXECUTE sp_helptext PROCEDURE_NAME

3. This is used to ensure a null field is returned as zero.

select ISNULL(FIELD_NAME, 0) from TABLE_NAME

4. This is used to show all object names in the current database matching a pattern.

select * from sysobjects where name LIKE '%PATTERN%'

5. This is used to show the table definition.

EXECUTE sp_help TABLE_NAME

6. This is used to show all DTS packages that match a pattern.

select distinct name from msdb.dbo.sysobjects where name LIKE '%PATTERN%'

7. This is used to show all constraints for table names in the current database matching a pattern.

 select * from INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE where TABLE_NAME LIKE '%PATTERN%'

8. This is used to run UPDATE STATISTICS against all user-defined tables in the current database.

EXEC sp_updatestats

9. This is used to show all stored procedures in the current database that match a pattern.

select * from sysobjects where xtype = 'P' and name LIKE '%PATTERN%'

10. This is used to ensure an empty string is returned as null.

select NULLIF(FIELD_NAME, '') from TABLE_NAME