{"id":279,"date":"2014-10-28T16:52:44","date_gmt":"2014-10-28T15:52:44","guid":{"rendered":"http:\/\/www.codereview.co\/?p=279"},"modified":"2014-10-24T09:30:01","modified_gmt":"2014-10-24T08:30:01","slug":"sql-interview-question-10-what-is-a-default-definition","status":"publish","type":"post","link":"http:\/\/www.codereview.co\/index.php\/sql-server-tutorials\/sql-interview-question-10-what-is-a-default-definition\/","title":{"rendered":"Sql Interview Question #10: What is a DEFAULT definition?"},"content":{"rendered":"<p><strong><span style=\"color: #000000;\">Sql Interview Question #10<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\"> What is a DEFAULT definition?<\/span><!--more--><\/p>\n<p><span style=\"color: #000000;\"><strong>Solution<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">A DEFAULT definition is used to add values into a column when values were omitted. The default value must be compatible with the data type of the column to which the DEFAULT definition applies.<\/span><\/p>\n<p><span style=\"color: #000000;\">DEFAULT values can be in integer and datetime fields but cannot be defined on timestamp and IDENTITY columns.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>Thanks for reading this article,<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>Next steps :<\/strong><\/span><\/p>\n<ol>\n<li><span style=\"color: #000000;\"><strong>S<\/strong><\/span><span style=\"color: #000000;\"><strong>hare this with your colleagues because Sharing is Learning<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\"><strong> Comment below if you need any assistance<\/strong><\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sql Interview Question #10 What is a DEFAULT definition?<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[136,137,13,12],"_links":{"self":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/279"}],"collection":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/comments?post=279"}],"version-history":[{"count":4,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/279\/revisions"}],"predecessor-version":[{"id":403,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/279\/revisions\/403"}],"wp:attachment":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/media?parent=279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/categories?post=279"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/tags?post=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}