Shulou(Shulou.com)06/01 Report--

- -- use DSCSYSgoDECLARE @ TableName nvarchar = 'COPTD' @ DataBase nvarchar (4000) = 'TOPLED2015', @ SQL nvarchar (4000), @ Where nvarchar (4000) =' where 'set @ SQL =' select MD001,MD003,MD004,MD005,MD006,MD007 from DSCSYS..ADMMD where MD001 ='+'+ @ TableName +''and substring (MD003,1,2) = substring (''+ @ TableName +') 4) 'exec (@ SQL)- -set @ SQL = STUFF (SELECT' '+ rtrim (MD003) +' as''+ rtrim (MD004) +''FROM ADMMD where MD001 = @ TableName and substring (MD003,1,2) = substring (@ TableName,4,2) FOR xml path (''),) set @ SQL = replace ('select * from','*') @ SQL) + @ DataBase +'..'+ @ TableName exec (@ SQL)- -select MD001 MD003,MD004,MD005,MD006,MD007,* from DSCSYS..ADMMD where MD001 = 'PURTC' and MD003 =' UDF12'update DSCSYS..ADMMD set UDF01 = 'warranty life' where MD001 = 'PURTC' and MD003 =' UDF12'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.