declare @count int
declare @count1 int
set @count = 0
set @count1 = 2
while @count < 10
Begin
Set @Count = @count + 1
Print (@count) = (@count*@count1)
END
---------------------
Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '='.
-------------
I want this t...
more >>I have a web app with a search based on Indexing Service and SQL 2000
(on the same box). Now, I need to move it to a new web server and a
separate dedicated SQL 2005. So, what should I do to be able to use
the same search using remote server?
...
more >>
