【【【【【【 存储过程结构问题 libin_ftsafe(子陌红尘)等高人请进 谢谢】】】】】】

[噯卟釋手]

我想实现这样的效果 但是有语法错误 呵呵 @type 是存储过程的参数

create proc_test @type varchar(20)
as
begin
if @type = '0'
(if exists(....)
select .....from ... where ...)

if @type = '1'
(if exists(....)
select .....from ... where ...)

if @type = '2'
(if exists(....)
select .....from ... where ...)
end
go

[噯卟釋手]

何解？

[Liroyal]

何解？

[goregrypeck]

create proc_test @type varchar(20)
as

if @type = '0'
begin
(if exists(....)
select .....from ... where ...)
end

if @type = '1'
begin
(if exists(....)
select .....from ... where ...)
end
if @type = '2'
begin
(if exists(....)
select .....from ... where ...)
end
go

[NinGoo]

create procedure proc_test @type varchar(20)

[子陌红尘]

example:

create procedure proc_test @type varchar(20)
as
begin
if (@type = '0')
begin
if exists(select * from myfortune)
select * from myfortune where 1=1
end
if @type = '1'
begin
if exists(select * from myfortune)
select * from myfortune where 1=1
end
if @type = '2'
begin
if exists(select * from myfortune)
select * from myfortune where 1=1
end
end
go

[NinGoo]

其余的同意 goregrypeck(派克)

[Andy__Huang]

create proc proc_test @type varchar(20) --你少了proc
as
set nocount on
set ansi_warnings off

if @type = '0'
begin
if exists(....)
select .....from ... where ...
end
if @type = '1'
begin
if exists(....)
select .....from ... where ...
end

if @type = '2'
begin
if exists(....)
select .....from ... where ...
end

go

[goregrypeck]

create procedure proc_test @type varchar(20)
as

if @type = '0'
begin
(if exists(....)
select .....from ... where ...)
end

if @type = '1'
begin
(if exists(....)
select .....from ... where ...)
end
if @type = '2'
begin
(if exists(....)
select .....from ... where ...)
end
go

[噯卟釋手]

晕 我没说清楚
我的结构是这个样子的：

create proc proc_test @type varchar(20)
as
begin
if @type = '0'
(if exists(....)
select .....from ... where ...
else
select .....from ... where ...)

if @type = '1'
(if exists(....)
select .....from ... where ...
else
select .....from ... where ...)

if @type = '2'
(if exists(....)
select .....from ... where ...
else
select .....from ... where ...)
end
go

如何改改？

[子陌红尘]

create proc proc_test @type varchar(20)
as
begin

if @type = '0'
begin
if exists(....)
select .....from ... where ...
else
select .....from ... where ...
end

if @type = '1'
begin
if exists(....)
select .....from ... where ...
else
select .....from ... where ...
end

if @type = '2'
begin
if exists(....)
select .....from ... where ...
else
select .....from ... where ...
end

end
go

[噯卟釋手]

谢谢 谢谢~~~~~~~~~~~~~~~~~~


给分啦

[vinsonshen]

改成这样试试：

create proc proc_test @type varchar(20)
as
begin
if @type = '0'
begin
(if exists(....)
select .....from ... where ...
else
select .....from ... where ...)
end
else if @type = '1'
begin
(if exists(....)
select .....from ... where ...
else
select .....from ... where ...)
end
else if @type = '2'
begin
(if exists(....)
select .....from ... where ...
else
select .....from ... where ...)
end
end