Hi,
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
Domain - User Data Types
Hot Topic
- Importing dBase files with the SSIS Import/Export Wizard
- SQL Server Business Intelligence Development Studio not found
- Connect Oracle10g from SSIS
- Rounding Calculated Member
- HOw to force SQL 2005 to use my D Drive to install files instead of C
- can not drop user from database
- Problem running package with 'larger' amount of data
- How to convert Dynamic Properties to SSIS Package Config?
- sql server management studio nov ctp
- Join filter failure
SQL Server
- Differences from preview to deploy...
- connecting to sqlexpress from classic asp
- Capturing and reporting execution errors
- How to retrieve data from query and link the data to a data number?
- Problem dropping replication support
- How to Do Text Mining
- Need help rotating a table
- PipelineBufferLeak
- search char in String
- CurrentMember failed with (Multiple Items) in the 'filter fields'
Domain - User Data Types
Aleksandar Petkovic
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
---