SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT TOP 6 column_id, name
INTO Oracle_table
FROM sys.columns
where object_name(OBJECT_ID)= 'queue_messages_1977058079'
ORDER BY column_id;
6 rows affected

SELECT * FROM Oracle_table ORDER BY COLUMN_ID


column_id
name


1
status

2
priority

3
queuing_order

4
conversation_group_id

5
conversation_handle

6
message_sequence_number


create table SQL_Server_table(column_id INT, name VARCHAR(100))
INSERT INTO SQL_Server_table(column_id, name)
SELECT column_id, name
FROM Oracle_table;
6 rows affected

SELECT *
FROM SQL_Server_table


column_id
name


1
status

2
priority

3
queuing_order

4
conversation_group_id

5
conversation_handle

6
message_sequence_number


DECLARE @m INT = (SELECT MAX(column_id)+1 FROM Oracle_table);

DECLARE @sql NVARCHAR(MAX) = CONCAT('CREATE SEQUENCE dbo.SQL_Server_table_seq START WITH ', @m,  ' INCREMENT BY 1');

PRINT @sql;
EXEC(@sql);
CREATE SEQUENCE dbo.SQL_Server_table_seq START WITH 7 INCREMENT BY 1


ALTER TABLE SQL_Server_table
ADD CONSTRAINT df_SQL_Server_table_seq 
DEFAULT NEXT VALUE FOR dbo.SQL_Server_table_seq FOR [column_id];
SELECT *
FROM SQL_SErver_table


column_id
name


1
status

2
priority

3
queuing_order

4
conversation_group_id

5
conversation_handle

6
message_sequence_number


INSERT INTO SQL_Server_table(name)
VALUES('new_value')
1 rows affected

SELECT *
FROM SQL_SErver_table


column_id
name


1
status

2
priority

3
queuing_order

4
conversation_group_id

5
conversation_handle

6
message_sequence_number

7
new_value

column_id	name
1	status
2	priority
3	queuing_order
4	conversation_group_id
5	conversation_handle
6	message_sequence_number