I am trying to run the following script but it is failing and I do not know why:
DROP TABLE table;
CREATE SEQUENCE seq START WITH 0;
CREATE TABLE table (
id VARCHAR(512) PRIMARY KEY AS ('0000000000' + CAST(NEXT VALUE FOR seq AS VARCHAR(512)), 10),
field VARCHAR(512),
field VARCHAR(512)
);
I want to cast the number to string in order to match the requirements of other part of the code
How about a different approach? Just use an identity column for the table. Then add a generated column that provides your string representation:
CREATE TABLE t (
t_id int identity(1, 1) primary key,
t_id_str as (right('0000000000' + CAST(t_id AS VARCHAR(512)), 10))
);
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments