{"id":1253,"date":"2017-03-23T22:27:26","date_gmt":"2017-03-23T16:57:26","guid":{"rendered":"http:\/\/pramodsingla.com\/?p=1253"},"modified":"2017-03-23T22:27:26","modified_gmt":"2017-03-23T16:57:26","slug":"exam-70-461-notes-set-theory","status":"publish","type":"post","link":"https:\/\/pramodsingla.com\/?p=1253","title":{"rendered":"Exam 70-461 Notes – Set Theory"},"content":{"rendered":"
    \n
  1. \n

    Ordered list of returned result set is called Cursor<\/strong>.<\/h2>\n<\/li>\n
  2. \n

    Without “order by<\/strong>”\u00a0clause query doesn’t return results in particular order even if clustered index is there.<\/h2>\n<\/li>\n
  3. \n

    Standard SQL must have “Select” and “have” whereas T-SQL can work with only “Select”<\/h2>\n<\/li>\n
  4. \n

    “dbo”.”order” standard where as [dbo].[order] is Microsoft format.<\/h2>\n<\/li>\n
  5. \n

    T-SQL is based upon SQL which in turn based upon relational model which further is based upon set theory and predicate logic.<\/h2>\n<\/li>\n<\/ol>\n

    \u00a0 \u00a0 \u00a0 \u00a0 \u00a0T-SQL<- SQL <-\u00a0relational model<- set theory and predicate logic.<\/strong><\/h2>\n","protected":false},"excerpt":{"rendered":"

    Ordered list of returned result set is called Cursor. Without “order by”\u00a0clause query doesn’t return results in particular order even[…]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[8],"tags":[77,149],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/1253"}],"collection":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1253"}],"version-history":[{"count":0,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/1253\/revisions"}],"wp:attachment":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}