create table tb (id int ,sex varchar(20),name varchar(30))
insert into tb (id,sex,name) values(1,'男','一')
insert into tb (id,sex,name) values(2,'男','二')create proc tb_select
@sex varchar(20),
@name varchar(20),
@sum nvarchar(20) output
as
begin
declare @s nvarchar(500)
declare @n nvarchar(20)
set @s='select @sum=name from tb where sex='''+@sex+''' and name='''+@name+''''
exec sp_executesql @s,N'@sum nvarchar(20) output',@n
end--调用测试
declare @s varchar(20)
--set @s=''
exec dbo.tb_select '男','二',@s[code=SQL]
select @s
--为什么@s还是null值或'',为什么没有改变啊??请高手帮我看看,谢谢[/code]
insert into tb (id,sex,name) values(1,'男','一')
insert into tb (id,sex,name) values(2,'男','二')create proc tb_select
@sex varchar(20),
@name varchar(20),
@sum nvarchar(20) output
as
begin
declare @s nvarchar(500)
declare @n nvarchar(20)
set @s='select @sum=name from tb where sex='''+@sex+''' and name='''+@name+''''
exec sp_executesql @s,N'@sum nvarchar(20) output',@n
end--调用测试
declare @s varchar(20)
--set @s=''
exec dbo.tb_select '男','二',@s[code=SQL]
select @s
--为什么@s还是null值或'',为什么没有改变啊??请高手帮我看看,谢谢[/code]
解决方案 »
- 请教 sql2005 中xp_cmdshell 无法执行net user却可以执行net use 问题
- sql2005索引怎么创建?
- 求一个能下能装好使的SQLSERVER2005中文
- 如何使用sql翻译下面语句
- 请问如何解决 8位数字帐号的管理 ,就相当 9千 多万条的记录 的管理 !!!!!,我头都大了!!!!!!!!!!!!!!!!!!!!!!
- 这种要求能用存储过程实现吗?急
- sql语法:float转换成int问题
- 如何把查询结果马上保存为EXCEL文件?用替代表行不行?===========救命!
- 请问一个数据库的问题。。
- 动态表名的问题
- 有关存储过程返回值的问题
- 行列转换处理,求高手帮写一下
insert into tb (id,sex,name) values(1,'男','一')
insert into tb (id,sex,name) values(2,'男','二')create proc tb_select
@sex varchar(20),
@name varchar(20),
@sum nvarchar(20) output
as
begin
declare @s nvarchar(500)
declare @n nvarchar(20)
set @s='select @sum=name from tb where sex='''+@sex+''' and name='''+@name+''''
exec sp_executesql @s,N'@sum nvarchar(20) output',@n output
end
insert into tb (id,sex,name) values(1,'男','一')
insert into tb (id,sex,name) values(2,'男','二')go
create proc tb_select
@sex varchar(20),
@name varchar(20),
@sum nvarchar(20) output
as
begin
declare @s nvarchar(500)set @s='select @sum=name from tb where sex='''+@sex+''' and name='''+@name+''''
exec sp_executesql @s,N'@sum nvarchar(20) output',@sum output
end
go--调用测试
declare @s nvarchar(20)
--set @s=''
exec dbo.tb_select '男','二',@s output
select @sdrop table tbdrop proc tb_select
insert into tb (id,sex,name) values(1,'男','一')
insert into tb (id,sex,name) values(2,'男','二')go
create proc tb_select
@sex varchar(20),
@name varchar(20),
@sum nvarchar(20) output
as
begin
declare @s nvarchar(500)set @s='select @sum=name from tb where sex='''+@sex+''' and name='''+@name+''''
exec sp_executesql @s,N'@sum nvarchar(20) output',@sum output
end
go--调用测试
declare @s nvarchar(20)
--set @s=''
exec dbo.tb_select '男','二',@s output
select name=@sdrop table tbdrop proc tb_select/*
name
--------------------
二(所影响的行数为 1 行)
*/