var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Max value for sequence table
How do I determine the max value for Sequence table in SQL Server?
Check out http://www.w3schools.com/sql/sql_functions.asp.
All the SQL you need when starting out is in the tutorial too.
ur codings are working excelent.
that would depend on the datatype you are using for the identity column.
smallest is tinyint at 255, biggest is bigint at 9,223,372,036,854,775,807
there is no sequence table in sql server
Unless he is talking about IDENTITY column, in which case he should use either
Yes I am talking about identiy colum, how do I determine it's max value?
Originally Posted by Peso
SCOPE_IDENTITY @@IDENTITY IDENT_CURRENT
returns [Error Code: 102, SQL State: S0001] Incorrect syntax near on SQLServer 2005.
You can use the functions mentioned above.
Read about them in Books Online, because they all have their strengts and weaknesses.
I prefer the SCOPE_IDENTITY() function.
ah, i get it. i thought OP wanted the max allowed value.