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 lazy writer?

1 Answers   Wipro,

---

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

---

What is a filestream?

0 Answers  

---

How you can get a list of all the table constraints in a database? : Sql server administration

0 Answers  

---

When cursors are useful?

0 Answers  

---

How to find out the list schema name and table name for the database?

0 Answers  

---

What do you understand by mirroring?

0 Answers  

---

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

---

what is the difference between openrowset and openquery?

0 Answers  

---

How to name query output columns in ms sql server?

0 Answers  

---

Diffrent types of function

1 Answers   Wipro,

---

What is the function of sql server agent windows service?

0 Answers  

---