{"id":370,"date":"2014-08-26T11:30:30","date_gmt":"2014-08-26T03:30:30","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=370"},"modified":"2014-08-26T11:30:30","modified_gmt":"2014-08-26T03:30:30","slug":"sql-server-2012-new-feature-sequence-numbers-2","status":"publish","type":"post","link":"https:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html","title":{"rendered":"SQL Server 2012 New Feature &#8211; Sequence Numbers"},"content":{"rendered":"<p>Coba sedikit explorasi dengan sequence number di SQL Server 2012. Para developer mungkin tidak asing identity column pada saat kita akan membuat sebuah field pada sebuah column di sebuah table. dimana pada column tersebut kita bisa setup sebuah nilai identity column dan nilai increment nya.<!--more--><\/p>\n<p>Namun itu hanya berlaku pada 1 buah tabel, nah sekarang bagaimana caranya agar nilai yang berurut tersebut bisa kita sebar di beberapa tabel namun ? disini lah fungsi dari fitur Sequence Number dapat berperan.<\/p>\n<p>Type data dari Sequence Number dapat diterapkan pada semua jenis data integer, namun jika sebuah sequence tidak di deklarasikan tipe datanya maka secara default dia akan memiliki type data BigInt.<\/p>\n<p>Sebuah sequence Number memiliki ruang urutan mulai dari -2,147,483,648 sampai dengan 2,147,483,647. Jadi jika kita akan membuat Sequence Number yang memiliki pertambahan nilai 1 mulai dari -2,147,483,648 sampai dengan 2,147,483,647 dapat dibuat dengan cara<\/p>\n<pre class=\"lang:tsql decode:true\">CREATE SEQUENCE Schema.SequenceName    \r\nAS int    \r\nINCREMENT BY 1 ;<\/pre>\n<p>jika kita akan membuat Sequence Number yang memiliki pertambahan nilai 1 mulai dari 1 sampai dengan 2,147,483,647 dapat dibuat dengan cara<\/p>\n<pre class=\"lang:tsql decode:true\">CREATE SEQUENCE Schema.SequenceName\r\n    AS int    \r\nSTART WITH 1    \r\nINCREMENT BY 1 ;<\/pre>\n<p>untuk lebih memperjelas penjelasan diatas, mari kita sama2 melakukan eksperimen dibawah ini.<\/p>\n<p>Pertama yang kita lakukan adalah menentukan schema mana yang akan diterapkan Sequence Number. Misal saya akan gunakan database AdventureWorks2012 dengan schema <strong>TestSN<\/strong>. karena scehma TestSN tidak ada di database tersebut, maka saya bikin baru<\/p>\n<pre class=\"lang:tsql decode:true \">Use AdventureWorks2012 ;\r\nGo \r\nCREATE SCHEMA TestSN ;  \r\nGO<\/pre>\n<p>setelah itu kita membuat Sequence Numbernya didalam Schema tersebut yang saya beri nama <strong>UrutTmbh1<\/strong><\/p>\n<pre class=\"lang:tsql decode:true \">Create SEQUENCE TestSN.UrutTmbh1\r\n AS INT    \r\nSTART WITH 10000     \r\nINCREMENT BY 1;\r\nGo<\/pre>\n<p>anda dapat mencek nya hasil pembuatan sequence tersebut di Database AdventureWork2012 seperti gambar berikut<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-371\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png\" alt=\"04\" width=\"257\" height=\"293\" \/><\/a><\/p>\n<p>Saya akan coba terapkan Sequence ini pada 2 buah tabel. Saya coba buat 2 tabel contoh dulu<\/p>\n<pre class=\"lang:tsql decode:true \">CREATE TABLE Employees(\r\n    EmployeeId INT NOT NULL PRIMARY KEY,\r\n    Name NVARCHAR(255) NULL);\r\nGo\r\nCREATE TABLE Contractors(\r\n    ContractorId INT NOT NULL PRIMARY KEY,\r\n    Name NVARCHAR(255) NULL);\r\nGo<\/pre>\n<p>Setelah tabel diatas tercipta, mari kita masukkan 1 buah data masing-masing pada tabel tersebut dengan cara berikut :<\/p>\n<pre class=\"lang:tsql decode:true \">INSERT INTO Employees (EmployeeId, Name)\r\n   VALUES (NEXT VALUE FOR TestSN.UrutTmbh1, 'Jane');\r\nGo\r\n\r\nINSERT INTO Contractors (ContractorId, Name)\r\n   VALUES (NEXT VALUE FOR TestSN.UrutTmbh1, 'John');\r\nGo<\/pre>\n<p>Tampak bahwa saya untuk memasukkan nilai EmployeeId pada tabel Employees dengan menggunakan klausa NEXT VALUE FOR. Bgitu juga dengan field Contractor Id pada table Contractor.<\/p>\n<p>Jika kita coba lihat hasilnya adalah seperti berikut :<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/05.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-372\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/05.png\" alt=\"05\" width=\"266\" height=\"252\" \/><\/a><\/p>\n<p>Tampak terbentuk sebuah urutan angka (Sequence number) pada 2 field yang berbeda dan berbeda tabel juga.<\/p>\n<p>Demikian semoga dapat dipahami dan bermanfaat.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Coba sedikit explorasi dengan sequence number di SQL Server 2012. Para developer mungkin tidak asing identity column pada saat kita akan membuat sebuah field pada sebuah column di sebuah table. dimana pada column tersebut kita bisa setup sebuah nilai identity column dan nilai increment nya.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html\">Continue reading<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":371,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[26],"class_list":["post-370","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-sequence-numbers"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server 2012 New Feature - Sequence Numbers - Suherman Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2012 New Feature - Sequence Numbers - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Coba sedikit explorasi dengan sequence number di SQL Server 2012. Para developer mungkin tidak asing identity column pada saat kita akan membuat sebuah field pada sebuah column di sebuah table. dimana pada column tersebut kita bisa setup sebuah nilai identity column dan nilai increment nya. Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html\" \/>\n<meta property=\"og:site_name\" content=\"Suherman Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:published_time\" content=\"2014-08-26T03:30:30+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png\" \/>\n\t<meta property=\"og:image:width\" content=\"257\" \/>\n\t<meta property=\"og:image:height\" content=\"293\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"SQL Server 2012 New Feature &#8211; Sequence Numbers\",\"datePublished\":\"2014-08-26T03:30:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html\"},\"wordCount\":322,\"commentCount\":2,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png\",\"keywords\":[\"Sequence Numbers\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html\",\"url\":\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html\",\"name\":\"SQL Server 2012 New Feature - Sequence Numbers - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#primaryimage\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png\",\"datePublished\":\"2014-08-26T03:30:30+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#primaryimage\",\"url\":\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png\",\"contentUrl\":\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png\",\"width\":257,\"height\":293},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012 New Feature &#8211; Sequence Numbers\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/suherman.asia\/w2\/#website\",\"url\":\"http:\/\/suherman.asia\/w2\/\",\"name\":\"Suherman Blog\",\"description\":\"Just Another Geek Site\",\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/suherman.asia\/w2\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/suherman.asia\",\"https:\/\/www.facebook.com\/emantin34\",\"https:\/\/x.com\/emantin34\"],\"url\":\"https:\/\/suherman.asia\/w2\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2012 New Feature - Sequence Numbers - Suherman Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2012 New Feature - Sequence Numbers - Suherman Blog","og_description":"Coba sedikit explorasi dengan sequence number di SQL Server 2012. Para developer mungkin tidak asing identity column pada saat kita akan membuat sebuah field pada sebuah column di sebuah table. dimana pada column tersebut kita bisa setup sebuah nilai identity column dan nilai increment nya. Continue reading","og_url":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2014-08-26T03:30:30+00:00","og_image":[{"width":257,"height":293,"url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png","type":"image\/png"}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"SQL Server 2012 New Feature &#8211; Sequence Numbers","datePublished":"2014-08-26T03:30:30+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html"},"wordCount":322,"commentCount":2,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"image":{"@id":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#primaryimage"},"thumbnailUrl":"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png","keywords":["Sequence Numbers"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html","url":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html","name":"SQL Server 2012 New Feature - Sequence Numbers - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"primaryImageOfPage":{"@id":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#primaryimage"},"image":{"@id":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#primaryimage"},"thumbnailUrl":"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png","datePublished":"2014-08-26T03:30:30+00:00","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#primaryimage","url":"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png","contentUrl":"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/04.png","width":257,"height":293},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/sql-server-2012-new-feature-sequence-numbers-2.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"SQL Server 2012 New Feature &#8211; Sequence Numbers"}]},{"@type":"WebSite","@id":"http:\/\/suherman.asia\/w2\/#website","url":"http:\/\/suherman.asia\/w2\/","name":"Suherman Blog","description":"Just Another Geek Site","publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/suherman.asia\/w2\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","caption":"admin"},"logo":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/suherman.asia","https:\/\/www.facebook.com\/emantin34","https:\/\/x.com\/emantin34"],"url":"https:\/\/suherman.asia\/w2\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/comments?post=370"}],"version-history":[{"count":1,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/370\/revisions"}],"predecessor-version":[{"id":373,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/370\/revisions\/373"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media\/371"}],"wp:attachment":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}