CREATE PROCEDURE mypro
@cs varchar(50),
@ip varchar(50)
as
select mydata from mytable where (cs=@cs) and (myip like '%'+@ip+'%')
GO
@cs varchar(50),
@ip varchar(50)
as
select mydata from mytable where (cs=@cs) and (myip like '%'+@ip+'%')
GO
解决方案 »
- 请问以金额为来group by 的sql怎么写?谢谢
- sql2000修改所有表的字段内容
- excel做的表,怎么把第一行的字段和第二行开始的数据导入到sql server里,用了DTS不行,它把第一行的字段也作为一行数据放在数据表里了,
- 请问如何编写如下表的sql脚本
- 如何设置 timeStamp 字段不自动更新
- 怎样获得当前的msde安装的硬盘路径?
- 求一较高难度的SQL语句:实现Update两个Select搭配的查询结果
- insert into select 语句如何对一字段实现自动增长
- 存储过程多次调用同一张表怎么处理?
- 一个综合SQL SERVER,DELPHI,ADO的问题,急切求解
- 求一SQL语句
- 问一下BC问题。。。
@ip才是参数。select mydata from mytable where (cs=@cs) and (myip like '%'+@ip+'%')
也不行。
@cs varchar(50),
@ip varchar(50)
as
exec('select mydata from mytable where cs='''+@cs+''' and myip like ''%'+@ip+'%''')
@cs varchar(50),
@ip varchar(50)
as
select mydata from mytable where (cs=@cs) and (myip like '''%'+@ip+'%''')
GO
@cs varchar(50),
@ip varchar(50)
as
select mydata from mytable where (cs=@cs) and (@ip like '%'+RTRIM(myip)+'%')
GO