Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / kirubaharan

Unable to create index 'PK'.
Cannot define PRIMARY KEY constraint on Computed column in
table.
Could not create constraint. See previous errors.

Is This Answer Correct ?    2 Yes 0 No

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

Answer / 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

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

Answer / 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

More SQL Server Interview Questions

how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,

Can you explain full-text query in sql server?

0 Answers  

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

What are approximate numeric data types in ms sql server?

0 Answers  

How to Get the last identity value used

4 Answers  

Explain sql server service broker?

0 Answers  

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

What is Service Broker in sql server 2012?

0 Answers   UGC Corporation,

What do you understand by a stored procedure?

0 Answers  

What are triggers in ms sql server?

0 Answers  

What is the difference between mysql and mysqli?

0 Answers   HCL,

What is a transaction and why is it important?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories