SQL Server Hidden Gem - How to get next value of Identity for a column in a table

Hi,

This is very nice tip if you ever wanted to find the next value of identity column without doing an insert, I repeat without doing an Insert.

Lets say you have a table named company. Then you would use this command

SELECT IDENT_CURRENT('company') + IDENT_INCR('company')

where IDENT_CURRENT gives the current or last identity value used by that table and IDENT_INCR gives the increment you/anyone had set during creation of table. It could 1, 2 etc depending on your logic.

The other way of finding next value of identity is after an insert statement by using SCOPE_IDENTITY(). You would add 1 or 2 and so on depending on the autoincrement setting you used during the table creation.

Hope this helps.

Comments

Post a Comment

Popular posts from this blog

Translators not loaded --- Translators error in Dreamweaver for coldfusion.htm

I use Dreamweaver 8 on Windows XP and recently started to get this error message for no reason. It just started one day. the following translators were not loaded due to errors coldfusion.htm has configuration information that is invalid. This could also happen for XSLT.htm has configuration information that is invalid, ASP.htm: has configuration information that is invalid. ASP.NET.htm: has configuration information that is invalid. and so on. The solution to this problem is to delete FileCache_X.dat files from the Dreamweaver user configuration folder, where X is a random number and it could be different for your system. See below Dreamweaver 8 on Windows XP: C:\Documents and Settings\[username]\Application Data\Macromedia\Dreamweaver 8\Configuration All the best. I was able to successfully solve this problem
Read more

Making text bold in Adobe Acrobat

If you want to make a text bold in Adobe Acrobat, you will have to 1. first select Advanced Editing Toolbar. 2. In advanced edit toolbar, select TouchUp Text tool. 3. Then select the text you want to make bold, right click, and select properties. 4. Under Text tab, you will find Font option. 5. Select Font option and you will see Bold option for the font that is being used. For example, if selected text is font type Verdana , then under Fonts option, you should see a Verdana Bold option. If you do not see respective Bold Font, then you would have to pick a font that supports Bold Option. I know, its unlike Word but atleast we know the way now how to do make text bold in Adobe Acrobat.
Read more

Java Keytool Export Private Key, PKCS#12 or .p12 export or conversion from java keystore

So, I had to create a PKCS#12 type or .p12 extension certificate from a java keystore which was created using java keytool. FYI, I have jdk 1.4.2. I came to know that using keytool you cannot export the private key. I tried various options available in keytool i.e. create a keystore of type PKCS#12 to begin with instead of the default JKS (java keystore). -storetype PKCS12. All this didnt work and on further search on google, I came across 2 free products which can help you a lot in terms of handling the keystore, generate keystore, export private key and so on. You can download these free products from here. The tools are portecle-1.5 http://sourceforge.net/projects/portecle/ KeyTool IUI – GUI http://www.icewalkers.com/download/KeyTool-IUI/3073/adl/ For my needs, i.e. generate a PKCS#12 certificate from an existing java keystore, portecle-1.5 worked just fine and it was very easy to use. I also tried the KeyTool IUI – GUI just for testing the tool and it helped me to export the p...
Read more