is there more the two primary key in a single table?
- 26 Answers
- 28709 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
What do you mean by stored techniques? How would we use it?
What is bulkcopy in sql?
What is the recommended total size of your memory optimized tables?
What stored by the model?
What are the types of subquery?
How can i Relate Tables in SSIS
What is transaction server implicit?
What is function of ROLLUP ?
What are sql servers used for?
Why can there be only one clustered index and not more than one?
What is primary key, unique key, and foreign key?
Explain what are the authentication modes in sql server?
What is GUID in sql server?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Does group by or order by come first?
