sql常用語句

--查詢作業(yè)
SELECT?*?FROM???msdb.dbo.sysjobs?
--查詢作業(yè)步驟
msdb.dbo.sp_help_jobstep?@job_name?=?N'作業(yè)名'
--查詢作業(yè)計(jì)劃
msdb.dbo.sp_help_jobschedule?@job_name?=?N'作業(yè)名'
--打印存儲過程
sp_helptext?


--查看表結(jié)構(gòu)
SELECT?TOP?100?PERCENT?dbo.sysobjects.name?AS?表名稱,?dbo.syscolumns.name?AS?字段名稱,?dbo.systypes.name?AS?數(shù)據(jù)類型,?dbo.syscolumns.length?AS?長度,?dbo.syscolumns.xprec?AS?精度,
?????dbo.syscolumns.xscale?AS?小數(shù)位數(shù),?ISNULL(g.value,?'')?AS?字段說明
FROM?dbo.syscolumns?INNER?JOIN
dbo.sysobjects?ON?dbo.syscolumns.id?=?dbo.sysobjects.id?INNER?JOIN
dbo.systypes?ON?dbo.syscolumns.xtype?=?dbo.systypes.xtype?LEFT?OUTER?JOIN
dbo.sysproperties?AS?g?ON?dbo.syscolumns.id?=?g.id?AND?dbo.syscolumns.colid?=?g.smallid
WHERE???(dbo.sysobjects.type?=?'U')?and?dbo.sysobjects.name='TDGL'
ORDER?BY?表名稱,?dbo.sysobjects.id