查找表结构信息和查找表记录 存储过程
可以把存储过程设置为快捷方式
在sql 2005中设置路径为: 工具--选项--键盘 设置完后腰重新打开 sql 2005环境
--查找表结构信息
create proc [dbo].[GetTableInfo] @tablename1 varchar(50)
as
begin
declare @sql1 nvarchar(500)
set @sql1='select columns.name,b.name,columns.length,columns.isnullable
,MS_Description.value as Description
from syscolumns as columns
left join sys.extended_properties as MS_Description
on MS_Description.major_id=columns.ID and MS_Description.minor_id=columns.colid
left join systypes b on columns.xtype=b.xusertype
Where columns.ID=OBJECT_ID('''+@tablename1+''')';
exec sp_executesql @sql1
end
go
--sp_helptext 获取存储过程和函数信息
--查找一个表记录
CREATE proc [dbo].[ExcuteTable] @tablename0 varchar(50)
as
begin
declare @sql0 nvarchar(100)
set @sql0='select * from '+@tablename0
exec sp_executesql @sql0
end