Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Auto generation key field Expand / Collapse
Author
Message
Posted Saturday, January 3, 2009 6:28 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 10:24 PM
Points: 129, Visits: 72
Comments posted to this topic are about the item Auto generation key field
Post #629392
Posted Tuesday, January 13, 2009 10:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 8, 2014 4:18 PM
Points: 17, Visits: 52
What is the purpose of this syntax from the article?:

isnull(complaint_ID,null)
Post #635619
Posted Tuesday, January 13, 2009 10:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 8, 2014 4:18 PM
Points: 17, Visits: 52
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
Posted Wednesday, April 8, 2009 4:21 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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 »

Add to briefcase

Permissions Expand / Collapse