set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
gocreate PROCEDURE [dbo].[UpdateList]
@ipUserID int,
@ipFUserID int,
@ipType int
AS
SET NOCOUNT ON
BEGIN
declare @sql1 nvarchar(1000);
select @sql1 = 'update UserInfo set FriendList.modify(' +'''insert <Friend name ='+ '"@ipFUserID"'
+' /> as last into (/FriendList)[1]'+''') where FUserID = @ipUserID ;'
execute (@sql1)
END请问我如何才能将两个变量的值传进该sql语句里,请高手帮忙指点,谢谢!
set QUOTED_IDENTIFIER ON
gocreate PROCEDURE [dbo].[UpdateList]
@ipUserID int,
@ipFUserID int,
@ipType int
AS
SET NOCOUNT ON
BEGIN
declare @sql1 nvarchar(1000);
select @sql1 = 'update UserInfo set FriendList.modify(' +'''insert <Friend name ='+ '"@ipFUserID"'
+' /> as last into (/FriendList)[1]'+''') where FUserID = @ipUserID ;'
execute (@sql1)
END请问我如何才能将两个变量的值传进该sql语句里,请高手帮忙指点,谢谢!
@ipUserID
變量放引號外面~~
字符用
'''+变量+'''
整形用上面的
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
gocreate PROCEDURE [dbo].[YX_QP_UpdateFriendList]
@ipUserID int,
@ipFUserID int,
@ipType int
AS
SET NOCOUNT ON
BEGIN
declare @sql1 nvarchar(1000);
declare @sql2 nvarchar(1000);
select @sql1 = 'update UserFriendInfo set FriendList.modify(' +'''insert <Friend name ='+ '"@ipFUserID"'
+' /> as last into (/FriendList)[1]'+''') where FUserID = '+@ipUserID+';'
execute (@sql1)
END
但是还是出错误
Conversion failed when converting the varchar value 'update UserFriendInfo set FriendList.modify('insert <Friend name ="@ipFUserID" /> as last into (/FriendList)[1]') where FUserID = ' to data type int.