{"id":684,"date":"2020-09-22T18:46:45","date_gmt":"2020-09-22T18:46:45","guid":{"rendered":"https:\/\/serkanseker.com\/?p=684"},"modified":"2020-12-08T15:58:00","modified_gmt":"2020-12-08T15:58:00","slug":"creating-microsoft-sql-server-database","status":"publish","type":"post","link":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/","title":{"rendered":"Creating Microsoft SQL Server Database"},"content":{"rendered":"\n<p>There are many database management systems available to store data. The most popular of these are MySQL and Microsoft SQL Server. In this post, I will show you how to create a database with Microsoft SQL Server and the relationships between them.<\/p>\n\n\n\n<p>First of all, you must have Microsoft SQL Server installed on your computer. If it is not installed, you can download and install it by clicking <a href=\"https:\/\/www.microsoft.com\/tr-tr\/sql-server\/sql-server-downloads\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>. Since I currently have Microsoft SQL Server Management Studio 18 installed on my computer, I will continue with this version.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Connect to Server<\/h2>\n\n\n\n<p>This is how it will open when you first start Management Studio. Here, to do <strong>Windows Authentication<\/strong>, select <strong>Database Engine<\/strong> as <strong>Server Type<\/strong> and write your own server name for <strong>Server Name<\/strong>. Server Name is automatically generated.<\/p>\n\n\n\n<p>Since we will process on our own machine here, we performed Windows Authentication. If you want to perform database operations on another server, you can do SQL Server Authentication.<\/p>\n\n\n\n<div class=\"wp-block-image has-lightbox\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/serkanseker.com\/wp-content\/uploads\/2020\/09\/Connect-to-Server.jpg\" alt=\"Connect to Server in SQL Server Management Studio\" class=\"wp-image-686\" width=\"470\" height=\"310\"\/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Add a Database<\/h2>\n\n\n\n<p>You will now see many folders in <strong>Object Explorer<\/strong>. Right-click the <strong>Databases <\/strong>folder and click <strong>New Database<\/strong>. In the New Database window that opens, type the database name and click the Ok button. We are not concerned with the other settings for now.<\/p>\n\n\n\n<div class=\"wp-block-image has-lightbox\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/serkanseker.com\/wp-content\/uploads\/2020\/09\/Add-new-database.jpg\" alt=\"Add new database\" class=\"wp-image-689\" width=\"679\" height=\"364\"\/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Add a Table<\/h2>\n\n\n\n<p>After adding the database, you can expand the <strong>Databases <\/strong>folder and see the existing databases. Now, expand the database you just created and examine the folders inside it.<\/p>\n\n\n\n<p><strong>Tables <\/strong>folder contains tables where data will be stored. To create a new table, right-click the Tables folder and then follow the path <strong>New -&gt; Table<\/strong>. This will open a window like this:<\/p>\n\n\n\n<div class=\"wp-block-image has-lightbox\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/serkanseker.com\/wp-content\/uploads\/2020\/09\/Add-new-table.jpg\" alt=\"Add new table\" class=\"wp-image-690\" width=\"682\" height=\"363\"\/><\/figure><\/div>\n\n\n\n<p>You can set <strong>Column Name<\/strong>, <strong>Data Type<\/strong> and <strong>Allow Nulls<\/strong> options according to the design you want to define our table. Here I want to create a table named Users with UserID, Username, Password and RegisterDate columns. Let&#8217;s examine each column one by one.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/serkanseker.com\/wp-content\/uploads\/2020\/09\/Identity-Specification-and-Is-Identity-property-1024x544.jpg\" alt=\"Identity Specification and Is Identity property\" class=\"wp-image-2503\"\/><figcaption>Identity Specification and Is Identity property<\/figcaption><\/figure><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">UserID<\/h3>\n<\/div><\/div>\n\n\n\n<p>The UserID column will be the <strong>Primary Key<\/strong> variable for this table. To do this, right click on it and select Set Primary Key. I choose <strong>int<\/strong> as Variable Type and want it to automatically increment every time data is added to the table. In Column Properties, change the <strong>Identity Specification<\/strong> and <strong>Is Identity<\/strong> property to <strong>YES <\/strong>as shown in the figure. Also remove the <strong>Allow Nulls<\/strong> option if it is selected to prevent blank data entry.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Username<\/h3>\n\n\n\n<p>I want the username column to be a string of 10 characters. Again, don&#8217;t select Allow Nulls here either.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">Password<\/h3>\n<\/div><\/div>\n\n\n\n<p>The password will be a string of 50 characters and null data entry cannot be made.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\">RegisterDate<\/h3>\n<\/div><\/div>\n\n\n\n<p>Select the Data Type as date in the RegisterDate column because it would be more accurate to enter our data in time and date format. Again, this column is not null.<\/p>\n\n\n\n<p>After doing these operations, save the table with Ctrl + S. While saving, I typed the table name as Users.<\/p>\n\n\n\n<div class=\"wp-block-image has-lightbox\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/serkanseker.com\/wp-content\/uploads\/2020\/09\/Database-Tables.jpg\" alt=\"Database Tables\" class=\"wp-image-699\" width=\"512\" height=\"272\"\/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>In this post, we learned how to create a database and table using Microsoft SQL Server Management Studio. In my next post I will show you queries for adding data to tables, deleting, updating, etc.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are many database management systems available to store data. The most popular of these are MySQL and Microsoft SQL Server. In this post, I will show you how to create a database with Microsoft SQL Server and the relationships between them.<\/p>\n","protected":false},"author":1,"featured_media":200,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[46],"tags":[48,47],"class_list":["post-684","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-mssql","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating Microsoft SQL Server Database - Serkan Seker TR<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating Microsoft SQL Server Database - Serkan Seker TR\" \/>\n<meta property=\"og:description\" content=\"There are many database management systems available to store data. The most popular of these are MySQL and Microsoft SQL Server. In this post, I will show you how to create a database with Microsoft SQL Server and the relationships between them.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Serkan Seker TR\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-22T18:46:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-08T15:58:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/serkanseker.com\/tr\/wp-content\/uploads\/2020\/12\/Microsoft-SQL-Server-Database.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1\" \/>\n\t<meta property=\"og:image:height\" content=\"1\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"serkanadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"serkanadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/\"},\"author\":{\"name\":\"serkanadmin\",\"@id\":\"https:\/\/serkanseker.com\/tr\/#\/schema\/person\/841fcc69b248e08e52c4190963caeaf5\"},\"headline\":\"Creating Microsoft SQL Server Database\",\"datePublished\":\"2020-09-22T18:46:45+00:00\",\"dateModified\":\"2020-12-08T15:58:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/\"},\"wordCount\":525,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/serkanseker.com\/tr\/wp-content\/uploads\/2020\/12\/Microsoft-SQL-Server-Database.jpg\",\"keywords\":[\"mssql\",\"sql\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/\",\"url\":\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/\",\"name\":\"Creating Microsoft SQL Server Database - Serkan Seker TR\",\"isPartOf\":{\"@id\":\"https:\/\/serkanseker.com\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/serkanseker.com\/tr\/wp-content\/uploads\/2020\/12\/Microsoft-SQL-Server-Database.jpg\",\"datePublished\":\"2020-09-22T18:46:45+00:00\",\"dateModified\":\"2020-12-08T15:58:00+00:00\",\"author\":{\"@id\":\"https:\/\/serkanseker.com\/tr\/#\/schema\/person\/841fcc69b248e08e52c4190963caeaf5\"},\"breadcrumb\":{\"@id\":\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#primaryimage\",\"url\":\"https:\/\/serkanseker.com\/tr\/wp-content\/uploads\/2020\/12\/Microsoft-SQL-Server-Database.jpg\",\"contentUrl\":\"https:\/\/serkanseker.com\/tr\/wp-content\/uploads\/2020\/12\/Microsoft-SQL-Server-Database.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/serkanseker.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating Microsoft SQL Server Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/serkanseker.com\/tr\/#website\",\"url\":\"https:\/\/serkanseker.com\/tr\/\",\"name\":\"Serkan Seker TR\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/serkanseker.com\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/serkanseker.com\/tr\/#\/schema\/person\/841fcc69b248e08e52c4190963caeaf5\",\"name\":\"serkanadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/serkanseker.com\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/93ddc1f96117bf468976afe93a077eda77de96bcdb48dc749903598a546786a3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/93ddc1f96117bf468976afe93a077eda77de96bcdb48dc749903598a546786a3?s=96&d=mm&r=g\",\"caption\":\"serkanadmin\"},\"sameAs\":[\"https:\/\/serkanseker.com\"],\"url\":\"https:\/\/serkanseker.com\/tr\/author\/serkanadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating Microsoft SQL Server Database - Serkan Seker TR","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Creating Microsoft SQL Server Database - Serkan Seker TR","og_description":"There are many database management systems available to store data. The most popular of these are MySQL and Microsoft SQL Server. In this post, I will show you how to create a database with Microsoft SQL Server and the relationships between them.","og_url":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/","og_site_name":"Serkan Seker TR","article_published_time":"2020-09-22T18:46:45+00:00","article_modified_time":"2020-12-08T15:58:00+00:00","og_image":[{"url":"https:\/\/serkanseker.com\/tr\/wp-content\/uploads\/2020\/12\/Microsoft-SQL-Server-Database.jpg","width":1,"height":1,"type":"image\/jpeg"}],"author":"serkanadmin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"serkanadmin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#article","isPartOf":{"@id":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/"},"author":{"name":"serkanadmin","@id":"https:\/\/serkanseker.com\/tr\/#\/schema\/person\/841fcc69b248e08e52c4190963caeaf5"},"headline":"Creating Microsoft SQL Server Database","datePublished":"2020-09-22T18:46:45+00:00","dateModified":"2020-12-08T15:58:00+00:00","mainEntityOfPage":{"@id":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/"},"wordCount":525,"commentCount":1,"image":{"@id":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#primaryimage"},"thumbnailUrl":"https:\/\/serkanseker.com\/tr\/wp-content\/uploads\/2020\/12\/Microsoft-SQL-Server-Database.jpg","keywords":["mssql","sql"],"articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/","url":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/","name":"Creating Microsoft SQL Server Database - Serkan Seker TR","isPartOf":{"@id":"https:\/\/serkanseker.com\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#primaryimage"},"image":{"@id":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#primaryimage"},"thumbnailUrl":"https:\/\/serkanseker.com\/tr\/wp-content\/uploads\/2020\/12\/Microsoft-SQL-Server-Database.jpg","datePublished":"2020-09-22T18:46:45+00:00","dateModified":"2020-12-08T15:58:00+00:00","author":{"@id":"https:\/\/serkanseker.com\/tr\/#\/schema\/person\/841fcc69b248e08e52c4190963caeaf5"},"breadcrumb":{"@id":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#primaryimage","url":"https:\/\/serkanseker.com\/tr\/wp-content\/uploads\/2020\/12\/Microsoft-SQL-Server-Database.jpg","contentUrl":"https:\/\/serkanseker.com\/tr\/wp-content\/uploads\/2020\/12\/Microsoft-SQL-Server-Database.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/serkanseker.com\/tr\/creating-microsoft-sql-server-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/serkanseker.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Creating Microsoft SQL Server Database"}]},{"@type":"WebSite","@id":"https:\/\/serkanseker.com\/tr\/#website","url":"https:\/\/serkanseker.com\/tr\/","name":"Serkan Seker TR","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/serkanseker.com\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/serkanseker.com\/tr\/#\/schema\/person\/841fcc69b248e08e52c4190963caeaf5","name":"serkanadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/serkanseker.com\/tr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/93ddc1f96117bf468976afe93a077eda77de96bcdb48dc749903598a546786a3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/93ddc1f96117bf468976afe93a077eda77de96bcdb48dc749903598a546786a3?s=96&d=mm&r=g","caption":"serkanadmin"},"sameAs":["https:\/\/serkanseker.com"],"url":"https:\/\/serkanseker.com\/tr\/author\/serkanadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/serkanseker.com\/tr\/wp-json\/wp\/v2\/posts\/684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/serkanseker.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/serkanseker.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/serkanseker.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/serkanseker.com\/tr\/wp-json\/wp\/v2\/comments?post=684"}],"version-history":[{"count":0,"href":"https:\/\/serkanseker.com\/tr\/wp-json\/wp\/v2\/posts\/684\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/serkanseker.com\/tr\/wp-json\/wp\/v2\/media\/200"}],"wp:attachment":[{"href":"https:\/\/serkanseker.com\/tr\/wp-json\/wp\/v2\/media?parent=684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/serkanseker.com\/tr\/wp-json\/wp\/v2\/categories?post=684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/serkanseker.com\/tr\/wp-json\/wp\/v2\/tags?post=684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}