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

assertions Expand / Collapse
Author
Message
Posted Friday, February 8, 2013 1:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, February 10, 2013 8:00 AM
Points: 9, Visits: 51
OMG! I've worked with SQL Server for over 10 years and I've never heard of assertions. Really. This is the first time I hear there is something like that in SQL Server. Maybe I am the idiot
Post #1417884
Posted Friday, February 8, 2013 1:25 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 12,903, Visits: 32,146
Mike Seattle (2/8/2013)
OMG! I've worked with SQL Server for over 10 years and I've never heard of assertions. Really. This is the first time I hear there is something like that in SQL Server. Maybe I am the idiot


Neither SQL Server, Oracle Nor MYSQL support Assertions either;

it think this is one of those Things Celko thought was great in theory and injected into some obscure ANSI standard, but noone else thought it worthy, and ignored implementing it.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1417888
Posted Saturday, February 9, 2013 2:20 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 39,984, Visits: 36,353
Mike Seattle (2/8/2013)
OMG! I've worked with SQL Server for over 10 years and I've never heard of assertions. Really. This is the first time I hear there is something like that in SQL Server.


While there are asserts in SQL, they are not something that you can create, they're a query plan operator only, so unless you spend time diving into query plans, you'll never see them.

Assertions are more commonly associated with front end languages, as in
http://msdn.microsoft.com/en-us/library/system.diagnostics.debug.assert%28v=vs.100%29.aspx



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1417990
Posted Monday, February 11, 2013 8:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:07 AM
Points: 266, Visits: 1,688
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


mehta.saurabhj (2/8/2013)
I said similar not the same functions!!


mehta.saurabhj (2/8/2013)
No i said similar have a look you idiot!!!


If we were going to vote for who on this thread is most deserving of having their intelligence questioned, I know who I would choose.
Post #1418456
Posted Monday, February 11, 2013 8:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:07 AM
Points: 266, Visits: 1,688
Good comeback, Potsie.
Post #1418470
Posted Monday, February 11, 2013 8:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 25, 2013 9:15 AM
Points: 22, Visits: 33
Editor: Comment removed as offensive
Post #1418474
Posted Monday, February 11, 2013 8:33 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 39,984, Visits: 36,353
Please take the language and the random insults elsewhere, they have no place on a professional forum.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1418476
Posted Monday, February 11, 2013 8:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 25, 2013 9:15 AM
Points: 22, Visits: 33
Editor: comment removed as it was offensive
Post #1418480
Posted Monday, February 11, 2013 8:44 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 39,984, Visits: 36,353
Well, I do hope some future employer doesn't run across this thread.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1418486
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse