CREATE PROCEDURE WHOutBill_DirectorConfirm
@TableName varchar(50),
@OutBillID varchar(20),
@DirectorDate datetime
AS
exec("update " + @TableName + " set DirectorDate='" +convert(varchar(19), @DirectorDate,120) + "',BillState='主管确认' where OutBillID='" + @OutBillID + "'")
GO
@TableName varchar(50),
@OutBillID varchar(20),
@DirectorDate datetime
AS
exec("update " + @TableName + " set DirectorDate='" +convert(varchar(19), @DirectorDate,120) + "',BillState='主管确认' where OutBillID='" + @OutBillID + "'")
GO
轉為字符型就OK
select convert(varchar(19),getdate(),120)+'ab'
@TableName varchar(50),
@OutBillID varchar(20),
@DirectorDate datetime
AS
declare @s varchar(8000)
set @s="update " + @TableName + " set DirectorDate='" +convert(varchar(19), @DirectorDate,120) + "',BillState='主管确认' where OutBillID='" + @OutBillID + "'"
exec(@s)
GO
exec('update ' + @TableName + ' set DirectorDate='''+@DirectorDate+''',BillState='主管确认' where OutBillID='''+@OutBillID+'''')试试
@TableName varchar(50),
@OutBillID varchar(20),
@DirectorDate datetime
AS
exec("update " + @TableName + " set DirectorDate='" +convert(varchar(19), @DirectorDate,120) + "',BillState='主管确认' where OutBillID='" + @OutBillID + "'")
GO
好像还是不能运行,连语法都通不过
CREATE PROCEDURE dt_da
@dt_ta varchar(50),
@dt_mc varchar(50)
AS
exec("update" + @dt_ta +" set mc='" +@dt_mc+"'")
GO
我想更新的表用变量表示都报错说=号旁有错误楼主你哪里会有错吗借用你的地方很抱谦,这个变量如何表示