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

Create/ drop unique key Expand / Collapse
Author
Message
Posted Friday, September 18, 2009 3:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 8:19 AM
Points: 17, Visits: 159
Comments posted to this topic are about the item Create/ drop unique key
Post #790211
Posted Thursday, September 24, 2009 6:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 2:19 AM
Points: 40, Visits: 113
You can get rid of the need for the cursor

SELECT @R=@R+column_name+',' from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where constraint_name =@uq_name

G
Post #793197
Posted Friday, September 25, 2009 8:37 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, January 26, 2011 1:32 PM
Points: 146, Visits: 327
I agree - any time I see a CURSOR declaration in the first few lines of code...
Post #793858
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse