Skip to content
-
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.
T-SQL<- SQL <- relational model<- set theory and predicate logic.