Dear All,
I am facing a Problem in executing a SP fr Sybase12.0
Use Test1
go
create table Data1(ID int,Names varchar(30),Names1 varchar(30),Primary
key(ID))
go
create procedure SP_Insert
AS BEGIN
Declare @[EMAIL PROTECTED]
int ,@[EMAIL PROTECTED]
int
Set @[EMAIL PROTECTED]
=3D 100000
Set @[EMAIL PROTECTED]
=3D 0
While @[EMAIL PROTECTED]
< @[EMAIL PROTECTED]
BEGIN
Insert into Data1 Values(@[EMAIL PROTECTED]
'hello1','hello1')
select @[EMAIL PROTECTED]
=3D @[EMAIL PROTECTED]
+ 1
END
END
Exec SP_Insert
Go
For this I am getting an error:
Error] Script lines: 6-32 -------------------------
Incorrect syntax near '@[EMAIL PROTECTED]
'.
Msg: 102, Level: 15, State: 1
Procedure: SP_Insert, Line: 9 =03
Can some one help me on this?
----Mike
|
