摘要:
if object_id(N'tempdb.db.#t') is not nulldrop table #tcreate table #t(name varchar(255), [rows] bigint, reserved varchar(20), data varchar(20), index... 阅读全文
摘要:
--变量@tablename保存表名declare @tablename nvarchar(100)--将用户表全部保存到临时表#tablename中SELECT [name] into #tablename FROM sysobjectsWHERE type = 'U';--当#tablename... 阅读全文
摘要:
INSERT INTO CC11 SELECT convert(nvarchar(30),convert(decimal(11,0),PCTID)),convert(nvarchar(30),convert(decimal(11,0),PCODE)) ,0 FROM CC1--convert(nva... 阅读全文