ALTER PROCEDURE Tbcompany_get_mailinfo
@ids varchar(500)
ASSELECT name + '[' + sex + ']['+ province + city + ']'+ Company as member FROM Tbcompany WHERE uid in(@ids)
@ids varchar(500)
ASSELECT name + '[' + sex + ']['+ province + city + ']'+ Company as member FROM Tbcompany WHERE uid in(@ids)
解决方案 »
- 大神请进,关于SQL查询语句的疑问~!~~~~~~~~
- 一个简单的SQL 问题(相对于高手)
- 如何用SQL语句根据表2中的分值计算出表1中各字段的合计值?
- 请教一个SQL语句(在线等,马上就结)
- 我被卡住了,BOSS们拉我一把!
- 如何查看自己编写的触发器的源码?
- 发布时遇到"distributor_admin"未在该服务器上定义为远程登录(小弟没分了以后再补)
- 一个数据库中联合查询的问题
- 帮忙有分加,怎样单独导入一个存储过程?很急,在线等待
- 如何在 SQL SERVER 中用变量作表名 insert @table_name
- sql2000安装典型错误
- 好奇怪的问题急啊!!!!!!!!!!!!!!!
@ids varchar(500)
AS
exec('SELECT name + ''['' + sex + ''][''+ province + city + '']''+ Company as member FROM Tbcompany WHERE uid in('+@ids+')')
是不是这种格式:10000007,10000010,10000011
如:SELECT name + '[' + sex + '][' + province + city + ']' + company AS member
FROM Tbcompany
WHERE (uid IN (1000010, 1000007)) 可以查出来在存储过程中查询不出来,狂晕
马上给分
WHERE uid in(@ids) 出不来,因为相当于:WHERE (uid IN ('1000010, 1000007')),当然出不来