yes, CREATE TABLE [dbo].[custrate]( [id] [int] NOT NULL, [patname] [ch

is there more the two primary key in a single table?

Question Posted / simi

26 Answers
31794 Views
Eforce, Systematix, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

why would you use sql agent? : Sql server database administration

1119

What stored by the msdb? : sql server database administration

954

What are acid properties of transaction?

895

What is the report builder?

131

Why would you use sql agent?

1215

How to get a list all databases on the sql server?

1027

What are ddl triggers and types of ddl trigger?

978

How can we solve concurrency problems?

995

How to delete existing triggers using "drop trigger"?

994

Is mysql the same as sql server?

914

What do you understand by mirroring and mention the advantages of the mirroring?

1008

What is amo? : sql server analysis services, ssas

1046

How do I start sql server 2017?

888

What is the difference between functions and scalar functions?

1127

What is triggers and its types?

955