mahnaz_h
جمعه 15 شهریور 1387, 22:56 عصر
declare @Nname varchar (20)
declare @Family varchar (30)
declare @Tel varchar (13)
declare @Address varchar (100)
declare @SarGhofli bit
declare @Malekiat bit
declare @Mogheiat varchar (6)
declare @Emtiazat varchar (4)
declare @NoeMoamele varchar(1)
declare @Pardakht1 float
declare @Pardakht2 float
declare @Metraj int
declare @BalkonChandMetr int
declare @Tozihat varchar (200)
declare @Id int
declare @@sqlstatus int
begin
insert into TShop (Nname,Family,Tel, Address,sarGhofli,Malekiat,Mogheiat,Emtiazat,NoeMo amele,Pardakht1,Pardakht2,Metraj,BalkonChandMetr,T ozihat)
values ('fghf','juj','52785','yujuy',0, 1 ,'bar1', '12', 'f',525,52,44, 0 , 'gdhnjgj')
declare ShopCursor cursor
for select Id from TShop
open ShopCursor
fetch ShopCursor into @Id
while (@@sqlstatus = 0)
begin
fetch ShopCursor into @Id
select @Id
end
close ShopCursor
deallocate ShopCursor
حالا این پیغام رومیده:
Server: Msg 170, Level 15, State 1, Line 36
Line 36: Incorrect syntax near 'ShopCursor'
نمی دونم چکارش کنم
declare @Family varchar (30)
declare @Tel varchar (13)
declare @Address varchar (100)
declare @SarGhofli bit
declare @Malekiat bit
declare @Mogheiat varchar (6)
declare @Emtiazat varchar (4)
declare @NoeMoamele varchar(1)
declare @Pardakht1 float
declare @Pardakht2 float
declare @Metraj int
declare @BalkonChandMetr int
declare @Tozihat varchar (200)
declare @Id int
declare @@sqlstatus int
begin
insert into TShop (Nname,Family,Tel, Address,sarGhofli,Malekiat,Mogheiat,Emtiazat,NoeMo amele,Pardakht1,Pardakht2,Metraj,BalkonChandMetr,T ozihat)
values ('fghf','juj','52785','yujuy',0, 1 ,'bar1', '12', 'f',525,52,44, 0 , 'gdhnjgj')
declare ShopCursor cursor
for select Id from TShop
open ShopCursor
fetch ShopCursor into @Id
while (@@sqlstatus = 0)
begin
fetch ShopCursor into @Id
select @Id
end
close ShopCursor
deallocate ShopCursor
حالا این پیغام رومیده:
Server: Msg 170, Level 15, State 1, Line 36
Line 36: Incorrect syntax near 'ShopCursor'
نمی دونم چکارش کنم