Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to get table current identity value in sql server

SELECT IDENT_CURRENT('Pets') AS Result;
Comment

SQL Server Get the current identity value of the table

SELECT IDENT_CURRENT('table_name')
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql date time string format python 
Sql :: select top 10 rows in sql 
Sql :: postgresql create schema in specific database 
Sql :: show tables in cassandra cql 
Sql :: random name function in mysql for nvarchar 
Sql :: convert date to dd/mm/yyyy sql 
Sql :: get comma separated values in sql server 
Sql :: get value from a table an insert it with other values in another table sql 
Sql :: postgresql extract hour and minutes from timestamp 
Sql :: oracle trigger 
Sql :: psql select unique 
Sql :: laravel get sql query eloquent with parameters 
Sql :: reseed sql table primary key 
Sql :: count columns psql(PostreSQL) 
Sql :: copy table postgres 
Sql :: Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates. 
Sql :: postgres set column based on another column 
Sql :: DB: in eloquent using sql 
Sql :: postgresql add leading zeros 
Sql :: oracle create table if not exists 
Sql :: row number mssql 
Sql :: install squirrel sql ubuntu 
Sql :: select new table sql 
Sql :: how to test for sql injection 
Sql :: wildcard in sql 
Sql :: events mysql 
Sql :: oracle tablespace tables list 
Sql :: how to select one row in mysql 
Sql :: oracle percentage 
Sql :: oracle difference between two dates in years 
ADD CONTENT
Topic
Content
Source link
Name
9+7 =