这段SQL SERVER的存储过程的语法有什么错误?我怎么查不出来了.(20分)

L

liuyang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-18

• #1

CREATE PROCEDURE p_sxr @intyear char(4)
AS
declare @varday datetime
declare @varstring varchar(20)
delete from jjr where year(rq ) = @intyear and lx = 0
@varstring = "01/" | "01/" | convert(char(4) , @intyear)
@varday = convert(datetime,@varstring)
GO

检查语法的时候总提示 @varstring 附近有语法错误

 

G

gong666

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-18

• #2

@varstring = "01/" | "01/" | convert(char(4) , @intyear)
~~~~ ~~~
你这个|符号是什么意思，好象标准的sql语法中，没这操作符

 

P

pengjinlongex

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-18

• #3

CREATE PROCEDURE p_sxr (@intyear int)
AS
declare @varday datetime
declare @varstring varchar(20)
delete from jjr where year(rq ) = @intyear and lx = 0
set @varstring = '01/' + '01/' +convert(char(4) , @intyear)
set @varday = convert(datetime,@varstring)
GO

 

Z

ZergWang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-18

• #4

呵呵，我也没见过这个东东。（"01/" | "01/" | convert(char(4) , @intyear)）
不过，变量付值好象要用SET 吧。
set @varstring = '01/01/' + convert(char(4) , @intyear)
set @varday = convert(datetime,@varstring)

 

A

antic_ant

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-18

• #5

参照一下
CREATE PROCEDURE TollOperation_add
(
@fvtype_id varchar(6),
@operation smallint,
@fvid_b varchar(20),
@fvid_e varchar(20),
@taker varchar(10),
@operateid int output
)
as
begin tran
insert into tolloperation (fvtypeid,operation,fvid_begin,fvid_end,taker)values(@fvtype_id,@operation,@fvid_b,@fvid_e,@taker)
select @operateid= @@IDENTITY
commit tran

GO

 

L

liuyang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-21

• #6

多人接受答案了。