摘要:
USE DBGOCREATE TABLE tblCategory (Code INT, CategoryName VARCHAR(20),LastUpdated date)INSERT tblCategoryVALUES(1,'Cloths','01.01.2007'),(2,'Wear','01.01.2006'),(3,'Wears','03.10.2005'),(4,'Computers','03.04.2007') ,(5,'Hardware& 阅读全文
摘要:
一:拼接字符串较长的USE DBGO/****** Object: StoredProcedure [StoreHouse].[GetReturnGoodsInfo2] Script Date: 04/12/2013 16:34:50 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER procedure [StoreHouse].[GetReturnGoodsInfo2](@cols VARCHAR(8000),@col_id VARCHAR(400),@sqlon VARCHAR(8000),@sqlwhere VARCHA. 阅读全文