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 ««12

Generating Hex on Insert Expand / Collapse
Author
Message
Posted Wednesday, August 6, 2014 12:49 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 3,519, Visits: 9,396
CodeMuddler (8/5/2014)
I have to agree with what autoexcrement said earlier, why not get rid of the trigger altogether and use a persisted computed column?


I agree, in this case the computed column is not only a cleaner solution but more than 2 times quicker than the trigger.
Post #1600065
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse