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

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

0 Answers   HCL,

How many instances per computer are there in sql server 2000?

0 Answers  

what types of replication are supported in sql server? : Sql server database administration

0 Answers  

Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

How to get all stored procedures in sql server?

0 Answers  

How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  

What are the steps you will take to improve the performance of a poor performing query?

0 Answers  

What are the different types of replication you can set up in sql server?

0 Answers  

How would you choose between a clustered and a non-clustered index?

0 Answers  

Write down the syntax and an example for create, rename and delete index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories