{"type":"rich","height":"190","categories":[],"title":"SQL Server\u306eIDENTITY\u5024","description":"\u57fa\u672c\u4e8b\u9805 IDENTITY\u5024\u306b\u306fSEED(\u521d\u671f\u5024), INCR(\u5897\u5206)\u3068\u3044\u3046\u6982\u5ff5\u304c\u3042\u308b\u3002 \u307e\u305f\u3001IDENT_????\u3068\u3044\u3046\u95a2\u6570\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u308b(\u4ee5\u4e0b) IDENT_CURRENT \u73fe\u5728\u5024 IDENT_SEED \u521d\u671f\u5024 IDENT_INCR \u5897\u5206 CREATE TABLE foo ( [ID] INT IDENTITY(25, 2) PRIMARY KEY, [NAME] NVARCHAR(16) NOT NULL, [AGE] INT ); INSERT INTO foo (NAME) VALUES (N'\u3042'), (N'\u3044'), (N'\u3046'); SELECT * FROM foo; ID N\u2026","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","url":"https://imagawa.hatenadiary.jp/entry/2016/08/13/144923","blog_url":"https://imagawa.hatenadiary.jp/","published":"2016-08-13 14:49:23","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fimagawa.hatenadiary.jp%2Fentry%2F2016%2F08%2F13%2F144923\" title=\"SQL Server\u306eIDENTITY\u5024 - \u4eca\u5ddd\u9928\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","image_url":null,"blog_title":"\u4eca\u5ddd\u9928","width":"100%","author_url":"https://blog.hatena.ne.jp/imagawa_yakata/","author_name":"imagawa_yakata"}