Answer / sarika jayadave

USE <DATABASE NAME>
GO
ALTER TABLE [SERVER NAME].[TABLE NAME]
ADD CONSTRAINT [PRIMARY KEY NAME]
PRIMARY KEY CLUSTERED
(
[ORDER BY FILED NAME] ASC
)

Answer / saravakumar

USE [AdventureWorks]
GO
ALTER TABLE [Sales].[Individual]
ADD CONSTRAINT [PK_Individual_CustomerID]
PRIMARY KEY CLUSTERED
(
[CustomerID] ASC
)

What is the difference between ddl,dml and dcl commands?

0 Answers   BirlaSoft, Verifone,

---

How do I save a stored procedure in sql server?

0 Answers  

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

0 Answers  

---

Define union, union all, minus, intersect?

0 Answers  

---

Does index slows down insert statements?

0 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

What are subqueries in sql server?

0 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers  

---

What are a scheduled jobs or what is a scheduled tasks?

0 Answers  

---

What is BCP? When do we use it?

2 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---