Fruits Boy

--利用存储过程执行创建一张虚拟表，并向表中添加数据 --下例是将一张角色表的数据copy到虚拟表中，并返回数据 IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE NAME=proc_RoleInfo_Pageing)DROP PROCEDURE proc_RoleInfo_PageingGOCREATE PROCEDURE proc_RoleI

update syscolumns set name = lower(name) where id = (select id from sysobjects where xtype='u' and name='Web_DispAssets')update sysobjects set name=lower(name) where name='Web_DispAssets'select * from sysobjects where xtype='u'