首页 > 代码库 > SQL

SQL

--插入语句INSERT INTO Sys_BusinessPermit SELECT Sys_Manager as BusinessValue,PermitValue FROM Sys_Permit WHERE ModCode=01090207--查询语句SELECT a.name FROM sysobjects a INNER JOIN syscolumns b on a.id=b.id and b.name=modvalue

 

SQL