sql的update问题！！

[zhouwei7682719]

UPDATE [cnc1163_db].[dbo].[HengJia]
SET [ID] = <ID, int,>
,[HengJiaID] = <HengJiaID, uniqueidentifier,>
,[HengJiaName] = <HengJiaName, nvarchar(30),>
,[CuXiaoYu] = <CuXiaoYu, nvarchar(50),>
WHERE <搜索条件,,>

怎么把它改成 set [ID],[HengJiaID],[HengJiaName],[CuXiaoYu]= '5','铝合金','单片桁架','fdsak'
就是后面的这些不分开'5','铝合金','单片桁架','fdsak' 进行插入！！

[leo_lesley]

不可能~~~~~~~

[--小F--]

什么意思啊?

[nianran520]

写个截取字符转的标量函数。

[喜-喜]

[Quote=引用 2 楼 fredrickhu 的回复:]
什么意思啊?
[/Quote]

就是这样

set [ID],[HengJiaID],[HengJiaName],[CuXiaoYu]= '5','铝合金','单片桁架','fdsak'  

--让上面的语句等同于：

set [ID]='5',[HengJiaID]='铝合金',[HengJiaName]='单片桁架',[CuXiaoYu]='fdsak' 

--这个不太会！！！

[zhouwei7682719]

[Quote=引用 1 楼 leo_lesley 的回复:]
不可能~~~~~~~
[/Quote]汗！　是不是哦？　为什么

[nianran520]

if object_id('dbo.getitempart','FN') is not null 
drop function dbo.getitempart
go
create function dbo.getitempart(@str varchar(8000),@separator varchar(20),@item int)
returns varchar(30)
as
begin
	declare @ret varchar(30),@i int
	select @i = 1
	select @str = @str + case right(@str,1) when @separator then '' else @separator end
	while charindex(@separator,@str) > 0
	begin
		if @i = @item
		begin
			select @ret = substring(@str,1,charindex(@separator,@str) - 1)
			break
		end
		select @str = stuff(@str,1,charindex(@separator,@str),''),
		@i = @i + 1
	end
	return @ret
end
go
select dbo.getitempart('5,铝合金,单片桁架,fdsak',',',2)


------------------------------
铝合金

(1 行受影响)