摘要： 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 阅读全文

摘要： 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+''+&# 阅读全文