The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_describe_cursor_columns(nvarchar @cursor_source, nvarchar @cursor_identity)
MetaData:
-- Creation of sp_describe_cursor_columns create procedure sys.sp_describe_cursor_columns ( @cursor_return CURSOR VARYING OUTPUT, @cursor_source nvarchar (30), @cursor_identity nvarchar (128) ) AS declare @scope int select @cursor_source = LOWER (@cursor_source collate Latin1_General_CI_AS) -- Check if the cursor exists by name or handle. -- If cursor_status ( @cursor_source, @cursor_identity ) >= -1 begin if convert(varchar(30), @cursor_source) = 'local' OR convert(varchar(128), @cursor_source) = 'variable' select @scope = 1 else if convert(varchar(30), @cursor_source) = 'global' select @scope = 2 set @cursor_return = CURSOR LOCAL SCROLL DYNAMIC FOR SELECT column_name, ordinal_position, column_characteristics_flags, column_size, convert(smallint, case when data_type_sql > 32767 then 0 else data_type_sql end) as "data_type_sql", column_precision, column_scale, order_position, order_direction, hidden_column, columnid, objectid, dbid, dbname FROM sys.syscursorrefs scr, sys.syscursorcolumns scc WHERE scr.cursor_scope = @scope and scr.reference_name = @cursor_identity and scr.cursor_handl = scc.cursor_handle ORDER BY 2 FOR READ ONLY open @cursor_return end
No comments:
Post a Comment