` Getting MS SQL identity value (Mark Riffey ) - Icetips Article

Templates, Tools and Utilities for Clarion Developers
	Home Products Download Documentation Demos Support Articles About Buy ALL PRODUCTS Build Automator Checkbox Fixer Icetips Utilities Magic Buttons Magic Entries Magic Locks OutlookBar Power ToolBar Report Previewer SQL Templates TaskPanel Window Fixer XP Theme Xplore GOLD SUBSCRIPTION SILVER SUBSCRIPTION SOLO SUBSCRIPTION Compare Gold/Silver Products Documentation Demos Free SQL Stuff Other Free Stuff PAR2 files Tips & Tricks - NEW Icetips Blog Icetips News Icetips on Facebook Icetips on Twitter Icetips on Youtube All Articles Search articles Top Ten articles Articles by Category Video tutorials What is Clarion? Support Options Live Support Email & Mail Icetips Blog Icetips on Twitter Gold Subscription Silver Subscription Solo Subscription Recurring Subscription Compare Gold & Silver Renew Your Subscription Multiple Copy Pricing

Icetips Article

Back to article list Search Articles Add Comment Printer friendly Direct link

Par2: Getting MS SQL identity value
2009-08-20 -- Mark Riffey

The /autoinc option below returns the autoinc value to you in your sysid
field. I suggest using the other options as well, but your mileage may
vary.

/BUSYRETRIES=200 /MULTIPLEACTIVERESULTSETS=TRUE /BUSYHANDLING =2
/AUTOINC=Select @@IDENTITY

Today is March 31, 2025, 11:55 am
This article has been viewed 35303 times.

Back to article list Search Articles Add Comment Printer friendly

Lost Password

Subscribe

Gold Subscription
Buy Now

Silver Subscription
Buy Now

Solo Subscription
Buy Now

Multiple Copy Pricing

Renew Subscription

Templates, Tools and Utilitiesfor Clarion Developers

Icetips Article

Templates, Tools and Utilities
for Clarion Developers