| 1._____ This allows you to read ten rows from a table. 2. _____This is used to show the text for a given stored procedure. 3._____ This is used to ensure a null field is returned as zero. 4._____ This is used to show all object names in the current database matching a pattern. 5. _____This is used to show the table definition. 6. _____This is used to show all DTS packages that match a pattern. 7._____ This is used to show all constraints for table names in the current database matching a pattern. 8._____ This is used to run UPDATE STATISTICS against all user-defined tables in the current database. 9._____ This is used to show all stored procedures in the current database that match a pattern. 10._____ This is used to ensure an empty string is returned as null. | a) EXEC UPDATE STATISTICS
b) EXECUTE sp_help TABLE_NAME
c) select * from all_CONS_COLUMNS where table_name like '%PATTERN%'
d) EXECUTE sp_helptext PROCEDURE_NAME
e) select distinct name from msdb.dbo.sysdtspackages where name LIKE '%PATTERN%'
f) select * from TABLE_NAME where rowcount <= 10
g) select * from INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE where TABLE_NAME LIKE '%PATTERN%'
h) select ISNULL(FIELD_NAME, 0) from TABLE_NAME
i) select TOP 10 * from TABLE_NAME
j) select distinct name from msdb.dbo.sysobjects where name LIKE '%PATTERN%'
k) EXECUTE sp_helptext TABLE_NAME
l) select * from sysobjects where name LIKE '%PATTERN%'
m) select NULLIF(FIELD_NAME, '') from TABLE_NAME
n) EXEC sp_updatestats
o) select * from sysobjects where xtype = 'P' and name LIKE '%PATTERN%'
p) select * from sysobjects where uid = 1 and name LIKE '%PATTERN%'
|
- 
