Fast Guide: SQL Server 2000 commands

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