What use an dwhere we use @ , # , @@Hi,
Can anyone explain me the meaning of @,#,@@ and where we use thwm in sql ...
declare @Status varchar(50)
create table #temp1([ID] int,[Name] varchar(102))
DECLARE Sample_Cursor CURSOR FOR
SELECT ID FROM sampleTable;
FETCH NEXT FROM Sample_Cursor;
While @@FETCH_STATUS = 0
Ex: We executes FETCH from one cursor, and then calling a stored procedure that opens and processes the results from another cursor. When control is returned from the called stored procedure, @@FETCH_STATUS reflects the last FETCH executed in the stored procedure, not the FETCH statement executed before the stored procedure is called.