27,579
社区成员
发帖
与我相关
我的任务
分享
--使用sp_help 获得所有列名
sp_help 表名
sp_executesql N'IF OBJECT_ID(@tablename) IS NOT NULL EXEC(N''SELECT STUFF((SELECT '''',''''+name FROM sys.columns WHERE object_id = OBJECT_ID(''''''+@tablename+'''''') FOR XML PATH('''''''')),1,1,'''''''')'')',N'@tablename nvarchar(100)',
--Ctrl+F1:
sp_executesql N'IF OBJECT_ID(@tablename) IS NOT NULL EXEC(N''SELECT TOP(''+@n+N'') * FROM ''+@tablename)',N'@tablename nvarchar(100),@n int=100',
--功能:查询表的前100行数据。
--Ctrl+0:
sp_executesql N'SELECT * FROM sys.objects WHERE type IN (''U'',''V'',''P'',''FN'') AND name LIKE ''%''+@keyword+''%'' ORDER BY type,name',N'@keyword nvarchar(50)',
--功能:根据选定的部分字符查找表、视图、存储过程、函数。
DECLARE @s NVARCHAR(4000)
SET @s=''
SELECT @s=@s+','+QUOTENAME(Name) FROM syscolumns WHERE ID=OBJECT_ID('表名') AND Name NOT IN('ID') ORDER BY colid
SET @s=STUFF(@s,1,1,'')
EXEC('select '+@s+' from 表名')
select index,name