摘要: USE [zlhomeV3.0]GO/****** Object: StoredProcedure [dbo].[SpChangeNewHouseAgency] Script Date: 06/21/2012 15:54:38 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROCEDURE [dbo].[SpChangeNewHouseAgency] @Options VarChar(100), @Id bigint=Null Output, @Name nvarchar(50)=Null... 阅读全文
posted @ 2012-07-09 09:59 小开的一天 阅读(9697) 评论(0) 推荐(0) 编辑
摘要: USE [zlhomeV3.0]GO/****** Object: UserDefinedFunction [dbo].[Split] Script Date: 07/09/2012 09:56:02 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE FUNCTION [dbo].[Split]( @List nvarchar(max), @SplitOn nvarchar(5)) RETURNS @RtnValue table( Id int identity(1,1), Value nvarchar(max))AS ... 阅读全文
posted @ 2012-07-09 09:58 小开的一天 阅读(169) 评论(0) 推荐(0) 编辑