how to get last primary key in sql

Solved:
If you want to get last primary key id instead of Max() aggregate function:
IDENT_CURRENT('dbo.TableName') this is the best method to get last primary key id this is helpful for logic's

Comments

Post a Comment

Popular posts from this blog

ConfigurationManager ConnectionStrings not available in c#

ConfigurationManager not show ConnectionStrings until you will not add reference System.Configuration dll, right click on Project -- Add Reference after click to Assemblies then Framework and find System.Configuration dll vs2010: Project -- Add Reference after click to .NET components and find System.Configuration dll If also add this reference but then again its not showing its a simple way to solve you add System.Configuration.ConfigurationManager.ConnectionStrings
Read more

How to make script with data in sql

Image
Solved  Now we describe to step by step for easy to understand that how to make script with schema and data in SQL Server. 1- First you right click on desired database which you want to make script then select Tasks --> Generate Scripts... 2- Show new window for generating script click to Next button. 3- Select all object to specific database after click on Next button. 4- Click to Advance button show script advanced options ( Types of data to script ) option to select Schema and data then click to OK button. click to Next button on previous window. 5- This window for showing summary for generating script. 6- Finally successfully generate the script and you can click to Finish button.
Read more