摘要: CREATE TABLE [dbo].[Student2]([StuID] [int] NULL,[StuNum] [varchar](50) SPARSE NULL,[StuNamePY] [varchar](50) SPARSE NULL,[StuNameWB] [varchar](50) SPARSE NULL,[StuName] [varchar](50) SPARSE NULL,[IDNumber] [varchar](18) SPARSE NULL,[FileNo] [varchar](50) SPARSE NULL,[DocType] [varchar](50) SPARSE N 阅读全文
posted @ 2012-05-08 14:12 qanholas 阅读(217) 评论(0) 推荐(0) 编辑
摘要: declare @TableType varchar(max) = ''declare @tablename varchar(max)set @tablename='student'select @TableType=@TableType+case when types.name in ('varchar','nvarchar','char','nchar','varbinary')then 'declare @'+columns.name+''+&# 阅读全文
posted @ 2012-05-08 14:10 qanholas 阅读(215) 评论(0) 推荐(0) 编辑
点击右上角即可分享
微信分享提示