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 is deploy, process and build? : sql server analysis services, ssas

0 Answers  

When we can say that is in BCNF?

3 Answers   BitWise,

What is the difference between rank and dense_rank?

0 Answers  

What is sql language?

0 Answers  

How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  

Can you explain what are commit and rollback in sql?

0 Answers  

Can we write a distributed query and get some data which is located on other server and oracle database?

0 Answers  

select names starts with a,b,c

8 Answers   Scope International,

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

What functions can a view be used to performed?

0 Answers  

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

What is a primary key?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories