Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000?

Answer Posted / ricky

in sql server 2000 we can create the uniqe and primary key
constraint in computeted coloumn.....but in sql server 2005
we can not create the uniqe and primery constraints in
computed coloumn.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between left join and inner join in sql server?

797


What is sleeping status in sql server?

741


You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

728


What is server-level principal?

114


Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

768


What is model database? : SQL Server Architecture

824


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1835


What are the different Authentication modes in SQL Server and how can you change authentication mode?

850


What is the default schema of your login session in ms sql server?

769


Tell me what do you understand by a view? What does the with check option clause for a view do?

820


Can we insert data into a view?

860


How to list all dsn entries on your local machine using odbc_data_source()?

786


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

793


What is fill factor and pad index?

778


How do you use a subquery to find records that exist in one table and do not exist in another?

777