2009年6月2日
临时表 select into和insert into select
摘要： SELECT [FORM_ID] ,identity(int,50,1) AS Line_No ,[BU] ,[WEBSITE] ,'Y' as [IS_ACTUAL_LINE] ,[CUSTOMER_TYPE] ,[CUSTOMER_GROUP] ,[CUSTOMER_NAME] ,[CUSTOMER_CODE] ,[REBATE_TYPE] ,[MODEL_VERSION] ,[PART_N... 阅读全文
posted @ 2009-06-02 14:36 只想做好 阅读(9092) 评论(0) 推荐(0) 编辑
临时表，select into，insert into select 使用
摘要： SELECT [FORM_ID] ,identity(int,50,1) AS Line_No ,[BU] ,[WEBSITE] ,'Y' as [IS_ACTUAL_LINE] ,[CUSTOMER_TYPE] ,[CUSTOMER_GROUP] ,[CUSTOMER_NAME] ,[CUSTOMER_CODE] ,[REBATE_TYPE] ,[MODEL_VERSION] ,[PART_N... 阅读全文
posted @ 2009-06-02 14:36 只想做好 阅读(725) 评论(0) 推荐(0) 编辑
.临时表 select into和insert into select
摘要： SELECT [FORM_ID] ,identity(int,50,1) AS Line_No ,[BU] ,[WEBSITE] ,'Y' as [IS_ACTUAL_LINE] ,[CUSTOMER_TYPE] ,[CUSTOMER_GROUP] ,[CUSTOMER_NAME] ,[CUSTOMER_CODE] ,[REBATE_TYPE] ,[MODEL_VERSION] ,[PART_N... 阅读全文
posted @ 2009-06-02 14:36 只想做好 阅读(486) 评论(0) 推荐(0) 编辑