摘要： SET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS OFF GOCREATE function dbo.f_split(@SourceSql varchar(8000),@StrSeprate varchar(10))returns @temp table(a varchar(100))--实现split功能 的函数as begindeclare @i intse... 阅读全文

摘要： SELECT d.cDealer_Code, d.cDealer_Name, A.cPact_No, A.cIn_DateFROM dbo.tbl_Work AS w INNER JOIN (SELECT cPact_No, cCorp_Code, dFrom_Date, dTo_Date, dRegDate, iA... 阅读全文