Skip to content

Instantly share code, notes, and snippets.

@nisar1

nisar1/auto increment mssql.sql

Last active August 29, 2015 13:57
Show Gist options
  • Save nisar1/9567276 to your computer and use it in GitHub Desktop.
Save nisar1/9567276 to your computer and use it in GitHub Desktop.
Download ZIP
auto increment value
Raw
auto increment mssql.sql
SELECT AUTO_INCREMENT FROM information_schema.tables WHERE table_name = 'item_tbl' AND table_schema = 'db_sanitary2'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment