sqlserver數據庫連接字符串 sqlserver 字符串連接函數 _sqlserver數據庫連接字符串

文章插圖

文章插圖
方案一：
Create FUNCTION [dbo].Get_Contract_StyleNo(@AutoInc bigint)
RETURNS VARCHAR(Max)
AS
BEGIN
DECLARE @Content NVARCHAR(MAX)
SET @Content = ”
SELECT @Content = case when @Content=” then ” else @Content + ‘,’ end + GoodsNo
FROM (select distinct GoodsNo from EXP_Contract_Clothing_Goods where [email protected]) m
RETURN @Content
END
GO
構造標量函數
使用xml
構造通用存儲過程
方案三：
——默認條件，MainID=AutoInc
alter procedure [dbo].[SP_SumStr]
(
@MTable Varchar(100)–主表
,@ZTable Varchar(100)–子表
,@MColumn Varchar(100)–主表更新字段
,@ZColumn Varchar(100)–子表拼接字段
,@ConditionSql Varchar(500)–傳入的條件語句
)
as
set nocount on
begin
declare @strSql varchar(3000)
select top 1 AutoInc as MainID, Convert(nvarchar(500),CnName) as GoodsNo
into #result
from SYS_Staff where 1<0
set @strSql = ‘insert into #result select distinct MainID,’+ @ZColumn +’ from ‘[email protected]+’ ‘ + @ConditionSql
exec(@strSql)
DECLARE @Content NVARCHAR(MAX)
SET @Content = ”
SELECT @Content = case when @Content=” then ” else @Content + ‘,’ end + GoodsNo FROM #result
set @strSql = ‘Update a set a.’[email protected]+’=’[email protected]+’ from ‘+ @MTable +’ a left join ‘[email protected]+’ b on a.AutoInc=b.MainID ‘ + @ConditionSql
exec(@strSql)
—-SELECT @Content
end
【sqlserver數據庫連接字符串 sqlserver 字符串連接函數】set nocount off