Is @.@.sqlstatus not a global variable. Why am I getting this error.
Code Snippet
declare @.obj_type varchar(50);
declare @.obj_name varchar(50);
declare @.schema varchar(100);
select @.schema = 'new';
declare schema_object cursor for
select obj.type, obj.name
from sys.objects obj join sys.schemas s on (s.schema_id = obj.schema_id)
where s.name = @.schema
open schema_object
fetch schema_object into @.obj_type, @.obj_name;
while (@.@.sqlstatus = 0)
begin
fetch schema_object into @.obj_type, @.obj_name;
end
close schema_object
Msg 137, Level 15, State 2, Line 14
Must declare the scalar variable "@.@.sqlstatus".
I think u must use @.@.Fetch_Status instead of @.@.sqlstatus but I'm not sure about that
just give a try
No comments:
Post a Comment