67,513
社区成员
发帖
与我相关
我的任务
分享
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[UpdateDate_Background]
@CountryName nvarchar(50)
AS
DECLARE @tablename varchar(100)
DECLARE @sql nvarchar(1000)
SET @tablename=REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(19),getdate(),12),'-',''),':',''),' ','')
SET @sql='insert into save'+@tablename+' (gpda_ID) values('+@CountryName+')'
exec (@sql)
str="汉 字";
call = conn.prepareCall("{call UpdateDate_Background ('"+str+"')}");
只要str中包含汉字或者空格以及任何标点符号时都报异常,数据插不进去