Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Michaël Hardman » Create/ drop unique key
Add to briefcase

Create/ drop unique key Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
mi_ka_ze
Posted Friday, September 18, 2009 3:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 25, 2013 1:55 AM
Points: 10, Visits: 109
Comments posted to this topic are about the item Create/ drop unique key
Post #790211
grahams-701143
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: Saturday, March 09, 2013 3:23 AM
Points: 40, Visits: 99
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
Douglas Osborne-456728
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.