Exam 70-461 Notes – Set Theory
Posted by Pramod Singla on March 23, 2017
-
Ordered list of returned result set is called Cursor.
-
Without “order by” clause query doesn’t return results in particular order even if clustered index is there.
-
Standard SQL must have “Select” and “have” whereas T-SQL can work with only “Select”
-
“dbo”.”order” standard where as [dbo].[order] is Microsoft format.
-
T-SQL is based upon SQL which in turn based upon relational model which further is based upon set theory and predicate logic.
Leave a Reply