Auto generation key field

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Vinoth Kumar » Auto generation key field

Auto generation key field

Rate Topic

Display Mode

Topic Options

Author

Message

vinoth-750003

Posted Saturday, January 03, 2009 6:28 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 10:24 PM
Points: 128, Visits: 72

Comments posted to this topic are about the item Auto generation key field

Post #629392

Adam Gardner

Posted Tuesday, January 13, 2009 10:19 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, October 17, 2012 10:36 AM
Points: 16, Visits: 48

What is the purpose of this syntax from the article?:

isnull(complaint_ID,null)

Post #635619

Adam Gardner

Posted Tuesday, January 13, 2009 10:23 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, October 17, 2012 10:36 AM
Points: 16, Visits: 48

Also, wouldn't there be a potential concurrency issue with this approach (i.e. select max)? Don't you need to wrap this in a lock and actually perform the insert to prevent collisions?

Post #635625

vijayak

Posted Wednesday, April 08, 2009 4:21 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 11, 2010 7:54 AM
Points: 306, Visits: 24

how data will be inserted into Complaint table

Post #692903

« Prev Topic | Next Topic »

Permissions