Interested to Buy Any Domain ? << Click Here >> for more details...
Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000?
- 3 Answers
- 10535 Views
- Infosys, I also Faced
- E-Mail Answers
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
how to trace the traffic hitting a sql server? : Sql server database administration
How to grant a permission in ms sql server using "grant execute" statements?
What is relationship? What number of sorts of relationship are there?
What is inner join in sql server joins?
How to return the top 5 rows from a select query in ms sql server?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is sql server profiler trace data file?
wat wil hapn if we give the both read and deny read permission to user?
How to copy data from one table to another table?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
How to get the definition of a trigger back?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Explain the steps needed to create a scheduled job?
What is the sql case statement used for?
What is awe?
