摘要: Select identity(int,1,1) as iid,* into tmpTableName from TableNameSelect * from tmpTableNamedrop table tmpTableName 阅读全文
posted @ 2010-11-24 20:07 南阳·源 阅读(205) 评论(0) 推荐(0) 编辑
摘要: CREATE PROCEDURE [dbo].[P_MissiveRights]-- Add the parameters for the stored procedure here@UserCode varchar(50) ASBEGINSET NOCOUNT ON;declare @UserBiaoShi intdeclare @id intdeclare @sql0 nvarchar(400... 阅读全文
posted @ 2010-11-24 20:00 南阳·源 阅读(862) 评论(0) 推荐(0) 编辑