存储过程(0分)

H

holyszq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-26

• #1

CREATE PROCEDURE LBBM_XSQKCX
(
@Table_MC VarChar(20),
@Start_D Datetime,--起始日期
@End_D Datetime,--截止日期
)
AS
Begin
Select Sum(je),Jyfs From @Table_MC
Where Jyrq Between @Start_D And @End_D Group By Jyfs
End
GO
为什么会提示要先定义变量@Table_MC
那要怎样写才能让表可以指定的。
谢谢!!!

 

L

lotusleaf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-26

• #2

好像表名不能用参数传递的

 

A

antic_ant

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-26

• #3

照下面改
CREATE PROCEDURE del_table
(
@tbl_name varchar(20),
@where varchar(100)

)
AS
declare @sql varchar(255)
select @sql='delete from '+ @tbl_name + ' where '+@where
exec(@sql)
RETURN
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-26

• #4

CREATE PROCEDURE LBBM_XSQKCX
(
@Table_MC VarChar(20),
@Start_D Datetime,--起始日期
@End_D Datetime,--截止日期
)
AS
Begin
declare @strsql varchar(200)
set @strsql=' Select Sum(je),Jyfs From'+ @Table_MC +'
Where Jyrq Between'+ @Start_D+' And'+ @End_D +'Group By Jyfs'
End

 

B

bes96261

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-29

• #5

樓主太小氣了吧，所說之貼太多為無分貼

不過樓上的幾位都有道理,antic_ant就可用(Return好像不用這一句)