--插入语句 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‘
原文：http://www.cnblogs.com/yueyuepeng/p/4161022.html