有表A 结构如下
id(int)标识列 userName userPasswordSQL存储过程如下
create procedure proc_delWord
@useSelect varchar(100)
as
delete from word where charindex(id,@useSelect) > 0
go将id列改为varchar时测试正确 但
charindex()函数 表达式一不允许是int类型的 表的结构不允许改变
要实现同样功能,该如何修改存储过程?
id(int)标识列 userName userPasswordSQL存储过程如下
create procedure proc_delWord
@useSelect varchar(100)
as
delete from word where charindex(id,@useSelect) > 0
go将id列改为varchar时测试正确 但
charindex()函数 表达式一不允许是int类型的 表的结构不允许改变
要实现同样功能,该如何修改存储过程?
或
cast(id as varchar(100))
@useSelect varchar(100)
as
delete from word where charindex(cast(id as varchar),@useSelect) > 0
go
@useSelect varchar(100)
as
delete from word where charindex(cast(id as varchar), @useSelect) > 0
go