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 you clear a log file?

0 Answers  

What is the use of group by clause?

0 Answers  

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

How do you read transaction logs

1 Answers  

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

What are the two types of concurrency?

4 Answers  

What do you understand by recursive stored procedure?

0 Answers  

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

Distinguish between commit and rollback?

0 Answers  

how do we find every fifth record in a table

14 Answers   Aspire, HCL,

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

0 Answers  

What is candidate key with example?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories