摘要:
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... 阅读全文
摘要:
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 ... 阅读全文