June 8, 2012

sp_sequence_get_range (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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_sequence_get_range(nvarchar @sequence_name
, bigint @range_size)

MetaData:

 create procedure sys.sp_sequence_get_range  
@sequence_name nvarchar(776),
@range_size bigint,
@range_first_value sql_variant output,
@range_last_value sql_variant = null output,
@range_cycle_count int = null output,
@sequence_increment sql_variant = null output,
@sequence_min_value sql_variant = null output,
@sequence_max_value sql_variant = null output
as
declare @ret int
exec @ret = sys.sp_sequence_get_range_internal @sequence_name, @range_size, @range_first_value output, @range_last_value output,
@range_cycle_count output, @sequence_increment output, @sequence_min_value output, @sequence_max_value output
return @ret

No comments:

Post a Comment

Total Pageviews