mssql´æ´¢¹ý³Ìas֮ǰ֮ºóµÄ±äÁ¿ÉêÃ÷ÓÐʲôÇø±ð£¿

create    PROCEDURE zdy_CBFY (@SFSS VARCHAR(1),@DWBH varchar(20),@KMBH VARCHAR(10),@KJND VARCHAR(4))
AS
DECLARE @ZWkmye  varchar(20),@zwkmzd  varchar(20),@ZWSSKMYE  varchar(20)
set @zwkmye='zwkmye'+@kjnd
SET @ZWKMZD='ZWKMZD'+@KJND
SET @ZWSSKMYE='ZWSSKMYE'+@KJND
ÆäËû³ÌÐòÓïÑÔ
GO
AS ´æ´¢¹ý³ÌÓï·¨µÄÒ»²¿·Ö£¬AS֮ǰÊÇ´æ´¢¹ý³Ì²ÎÊýºÍÊôÐÔ¶¨Ò壬ASºóÃæ±íʾ´æ´¢¹ý³ÌÄÚÈݵĶ¨Òå¡£
GO ²»ÊÇ Transact-SQL Óï¾ä£»ËüÊÇ¿ÉÓÉ sqlcmd ºÍ osql ʵÓù¤¾ßÒÔ¼° SQL Server Management Studio ´úÂë±à¼­Æ÷ʶ±ðµÄÃüÁî¡£
SQL Server ʵÓù¤¾ß½« GO ½âÊÍΪӦ¸ÃÏò SQL Server ʵÀý·¢Ë͵±Ç°Åú Transact-SQL Óï¾äµÄÐźš£µ±Ç°ÅúÓï¾äÓÉÉÏÒ» GO ÃüÁîºóÊäÈëµÄËùÓÐÓï¾ä×é³É£¬Èç¹ûÊǵÚÒ»Ìõ GO ÃüÁÔòÓɼ´Ï¯»á»°»ò½Å±¾¿ªÊ¼ºóÊäÈëµÄËùÓÐÓï¾ä×é³É¡£
GO ÃüÁîºÍ Transact-SQL Óï¾ä²»ÄÜÔÚͬһÐÐÖС£µ«ÔÚ GO ÃüÁîÐÐÖпɰüº¬×¢ÊÍ¡£
SELECT * into erp_tticst001502 from  OPENQUERY(ERP,'select t$sitm,t$pdno from baan.tticst001502 where substr(t$pdno,1,4)=''A907''')
insert into erp_tticst001502 select * from OPENQUERY(ERP,'select t$sitm,t$pdno from baan.tticst001103 where substr(t$pdno,1,4)=''F907''') WHERE
T$pdno not in (select t$pdno from  erp_tticst001502) and t$sitm not in  (select t$sitm from  erp_tticst001502)
SELECT b.t$sitm,a.t$dsca,d.t$clot,e.t$corn,e.t$item from erp_tdsls400102 e,LC00019999.erp_ttcibd001102 a,erp_tticst001502 b,LC00019999.jhq_swc_ttisfc001102 c, LC00019999.jhq_swc_twhltc100102 d  where a.t$ctyp='001'  and b.t$pdno=c.t$pdno and
c.t$pdno=d.t$pdno and e.t$clot=d.t$clot and b.t$sitm=a.t$item  (±ðÃûÖмäµÄas¿ÉÒÔÊ¡ÂÔ)
SELECT b.t$sitm,a.t$dsca,C.t$pdno,d.t$clot,e.t$corn,e.t$item,f.vin from BI_MES.mes.dbo.mes_product_item_with_lot f, erp_tdsls400102 e,LC00019999.erp_ttcibd001102 a,erp_tticst001502 b,LC00019999.jhq_swc_ttisfc001102 c, LC00019999.jhq_swc_twhltc100102 d  where a.t$ctyp='002'  and b.t$pdno=c.t$pdno and
c.t$pdno=d.t$pdno and e.t$clot=d.t$clot and b.t$sitm=a.t$item and f.lot_code=d.t$clot
(Á´½Ó·þÎñÆ÷ÖÐÈ¡Êý¾Ý¿âµÄ¸ñʽ)