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

 assertions Rate Topic Display Mode Topic Options
Author
 Message
 Posted Friday, February 8, 2013 1:07 AM
 Grasshopper Group: General Forum Members Last Login: Monday, March 25, 2013 9:15 AM Points: 22, Visits: 33
 what is the difference between assertion and the check constraint as both of them do the same function?Please give an example
Post #1417493
 Posted Friday, February 8, 2013 1:17 AM
 Hall of Fame Group: General Forum Members Last Login: Wednesday, February 24, 2016 6:28 AM Points: 3,977, Visits: 6,431
 Does this help?Difference Between Check Constraints and Assertions My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!My thought question: Have you ever been told that your query runs too fast?My advice:INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.Need to UNPIVOT? Why not CROSS APPLY VALUES instead?Since random numbers are too important to be left to chance, let's generate some!Learn to understand recursive CTEs by example.Splitting strings based on patterns can be fast!My temporal SQL musings: Calendar Tables, an Easter SQL, Time Slots and Self-maintaining, Contiguous Effective Dates in Temporal Tables
Post #1417497
 Posted Friday, February 8, 2013 1:30 AM
 Grasshopper Group: General Forum Members Last Login: Monday, March 25, 2013 9:15 AM Points: 22, Visits: 33
 actually before posting here I did the same research but couldnt clear my doubt..So please give a simpler version of explaination
Post #1417503
 Posted Friday, February 8, 2013 9:06 AM
 Old Hand Group: General Forum Members Last Login: Friday, December 2, 2016 3:27 PM Points: 312, Visits: 705
 mehta.saurabhj (2/8/2013)what is the difference between assertion and the check constraint as both of them do the same function?Please give an exampleMaybe there's something that I'm missing but Assertions and check constraints do not do the same function.What makes you say they do? ---------------------------------------------------------------Mike Hahn - MCSomething somedayRight way to ask for help!!http://www.sqlservercentral.com/articles/Best+Practices/61537/I post so I can see my avatar I want a personal webpage I want to win the lotto I want a gf like Tiffa Oh wait I'm married!
Post #1417764
 Posted Friday, February 8, 2013 9:09 AM
 Grasshopper Group: General Forum Members Last Login: Monday, March 25, 2013 9:15 AM Points: 22, Visits: 33
 I said similar not the same functions!!
Post #1417768
 Posted Friday, February 8, 2013 9:12 AM
 SSC-Insane Group: General Forum Members Last Login: Friday, December 2, 2016 4:50 PM Points: 23,515, Visits: 37,731
 mehta.saurabhj (2/8/2013)I said similar not the same functions!!No, you said same:mehta.saurabhj (2/8/2013)what is the difference between assertion and the check constraint as both of them do the same function?Please give an example
Post #1417770
 Posted Friday, February 8, 2013 9:18 AM
 Grasshopper Group: General Forum Members Last Login: Monday, March 25, 2013 9:15 AM Points: 22, Visits: 33
 No i said similar have a look you idiot!!!
Post #1417774
 Posted Friday, February 8, 2013 9:26 AM
 SSC-Insane Group: General Forum Members Last Login: Friday, December 2, 2016 4:50 PM Points: 23,515, Visits: 37,731
 mehta.saurabhj (2/8/2013)No i said similar have a look you idiot!!!Really???? Look again at your first post, I quoted it in mine. Your statement from your original post, emphasis is mine:what is the difference between assertion and the check constraint as both of them do the same function?Please give an example
Post #1417781
 Posted Friday, February 8, 2013 9:31 AM
 SSC-Insane Group: General Forum Members Last Login: Friday, December 2, 2016 4:50 PM Points: 23,515, Visits: 37,731
 mehta.saurabhj (2/8/2013)No i said similar have a look you idiot!!!This is a professional site and this is totally uncalled for.
Post #1417787
 Posted Friday, February 8, 2013 9:35 AM
 Old Hand Group: General Forum Members Last Login: Friday, December 2, 2016 3:27 PM Points: 312, Visits: 705
 Lynn Pettis (2/8/2013)mehta.saurabhj (2/8/2013)No i said similar have a look you idiot!!!This is a professional site and this is totally uncalled for.I completely agree. If he's here to get help, he really know's how to appeal to our generous side. ---------------------------------------------------------------Mike Hahn - MCSomething somedayRight way to ask for help!!http://www.sqlservercentral.com/articles/Best+Practices/61537/I post so I can see my avatar I want a personal webpage I want to win the lotto I want a gf like Tiffa Oh wait I'm married!
Post #1417791

 Permissions