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 a hint?

0 Answers  

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

What are the purposes and advantages stored procedure?

0 Answers  

Do you know what is normalization of database? What are its benefits?

0 Answers  

Detail about query optimizer?

0 Answers  

What is co-related sub query?

0 Answers  

How to create new tables with "select ... Into" statements in ms sql server?

0 Answers  

What is difference between join and natural join?

0 Answers  

What is the New in SQL server 2008?

0 Answers  

how to connect sybase to sql server 2005?.

1 Answers   ABC,

Explain the advantages of merge replication?

0 Answers  

What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,

For more SQL Server Interview Questions Click Here
Categories