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
What are the differences between left join and inner join in sql server?
What is sleeping status in sql server?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is server-level principal?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is model database? : SQL Server Architecture
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is the default schema of your login session in ms sql server?
Tell me what do you understand by a view? What does the with check option clause for a view do?
Can we insert data into a view?
How to list all dsn entries on your local machine using odbc_data_source()?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is fill factor and pad index?
How do you use a subquery to find records that exist in one table and do not exist in another?