sql常用语句

--查询作业SELECT * FROM   msdb.dbo.sysjobs --查询作业步骤msdb.dbo.sp_help_jobstep @job_name = N'作业名'--查询作业计划msdb.dbo.sp_help_jobschedule @job_name = N'作业名'--打印存储过程sp_helptext --查看表结构SELECT TOP 100 PERCENT dbo.sysobjects.name AS 表名称, dbo.syscolumns.name AS 字段名称, dbo.systypes.name AS 数据类型, dbo.syscolumns.length AS 长度, dbo.syscolumns.xprec AS 精度,     dbo.syscolumns.xscale AS 小数位数, ISNULL(g.value, '') AS 字段说明FROM dbo.syscolumns INNER JOINdbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id INNER JOINdbo.systypes ON dbo.syscolumns.xtype = dbo.systypes.xtype LEFT OUTER JOINdbo.sysproperties AS g ON dbo.syscolumns.id = g.id AND dbo.syscolumns.colid = g.smallidWHERE   (dbo.sysobjects.type = 'U') and dbo.sysobjects.name='TDGL'ORDER BY 表名称, dbo.sysobjects.id