天蓝色dw中的identity(1,1) [英] identity(1,1) in azure dw
问题描述
创建表格[MTNG_DW_Dev].[raw_cna_mtng] .new_employees
(
id_num int IDENTITY(1,1),
fname varchar(20),
minit char(1),
lname varchar(30)
);
INSERT [MTNG_DW_Dev].[raw_cna_mtng] .new_employees
(fname,minit,lname)
值
('Karin','F','Josephs');
插入[MTNG_DW_Dev].[raw_cna_mtng] .new_employees
(fname,minit,lname)
值
("Pirkko","O","Koskitalo");
当我在新配置的azure dw服务器中运行上述简单语句时.身份列从16开始,下一个值增加20.下面是我看到的输出
16 卡琳 F 约瑟夫48 卡琳 F 约瑟夫
而不是
1 Karin
F 约瑟夫
2 Karin
F 约瑟夫斯
我需要配置任何属性以使身份增量使用1吗?
adithya
以下示例使用IDENTITY属性为自动增加标识号.
对于Azure SQL数据库:返回序列号
查询数据:
在查询窗口中,运行" 选择 * 来自 返回输出.
对于Azure SQL数据仓库:返回随机数
在查询窗口中,运行" 选择 * 来自 返回输出.
希望这会有所帮助.
CREATE TABLE [MTNG_DW_Dev].[raw_cna_mtng].new_employees
(
id_num int IDENTITY(1,1),
fname varchar (20),
minit char(1),
lname varchar(30)
);
INSERT [MTNG_DW_Dev].[raw_cna_mtng].new_employees
(fname, minit, lname)
VALUES
('Karin', 'F', 'Josephs');
INSERT [MTNG_DW_Dev].[raw_cna_mtng].new_employees
(fname, minit, lname)
VALUES
('Pirkko', 'O', 'Koskitalo');
when i running above simple statement in newly configured azure dw server . Identity column is starting with 16 and next value is being incrimented by 20 .Below is the output i am seeing
16 Karin F Josephs48 Karin F Josephs
instead of
1 Karin
F Josephs
2 Karin
F Josephs
i need configure any property for usage of identity increment by 1?
adithya
Create a destination table:
The following example creates a new table using the IDENTITY property for an automatically incrementing identification number.
CREATE TABLE new_employees ( id_num int IDENTITY(1,1), fname varchar (20), minit char(1), lname varchar(30) ); INSERT new_employees (fname, minit, lname) VALUES ('Karin', 'F', 'Josephs'); INSERT new_employees (fname, minit, lname) VALUES ('Pirkko', 'O', 'Koskitalo');
For Azure SQL Database: Return sequential number
Query the data:
In the query window, run "select * from new_employees;" returns the output.
For more details, refer "TABLE IDENTITY (Property)".
For Azure SQL Data Warehouse: Return random number
In the query window, run "select * from new_tab;" returns the output.
Hope this helps.
这篇关于天蓝色dw中的identity(1,1)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!