is there more the two primary key in a single table?
Answer Posted / simi
yes,
CREATE TABLE [dbo].[custrate](
[id] [int] NOT NULL,
[patname] [char](50) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL,
[rate] [int] NULL,
CONSTRAINT [PK__custrate__12FE9D09] PRIMARY KEY CLUSTERED
(
[id] ASC,
[patname] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How would you go about developing a ssrs report?
plss anybody specify tha constrian management system in dbms
What is a data collection table?
What is the difference function and stored procedure?
What is the difference between inner join and equi join?
Can sql servers link to other servers like oracle?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
How are the exceptions handled in sql server programming?
what is bit datatype? : Sql server database administration
What are the advantages of paper records?
Can I work with several databases simultaneously? : sql server management studio
What is difference between join and natural join?
what type of index will get created after executing the above statement? : Sql server database administration
How to insert data with null values?
What to check if a User database is locked?