I'm new in MS SQL Server; comming from Firebird and PostgreSQL. I'm trying to import the SQL Script of a database I have in PostgreSQL 8; one basic SQL functionality is the "domain", as the way to create a user datatype; in my database I have one basic domain: OID:
CREATE DOMAIN dom_oid AS numeric(18,0) DEFAULT nextval('oid_secuence');
Is there a similar way to create this kind of types in SQL Server?
Thank you,
Guillermo
Hi,
did you have a look on CREATE TYPE in the BOL ? I don′t know if your question is more concentrated on the syntax for the creation of a type or using the sequence. There is no sequence concept in SQL Server, you will have to do all the logic on your own.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment