Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000?
Answer Posted / uma lakshman
Because SQL Server 2000 supports indexes on computed
columns, you can create UNIQUE and PRIMARY KEY constraints
on computed columns
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is sql server transaction log file?
What is the impact on other user sessions when creating indexes?
What is the definition for sql server 2000?
Do you know what is difference between stored procedure and user defined function?
What are different types of views?
What is Extended user-defined?
What is TDS(Tabular Data Stream) Gateway?
Do you know the capabilities of cursors?
What is acid mean in sql server?
Explain the architecture of ms sql reporting service?
What are the different types of sql server replication? : sql server replication
What are approximate numeric data types in ms sql server?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Explain difference between cross join and full outer join?
What are the difference between primary key and unique key? : sql server database administration