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 are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

How do I setup a sql server database?

0 Answers  

---

Mention the 3 ways to get a count of the number of records in a table.

0 Answers  

---

What do you understand by check constraint in sql server?

0 Answers  

---

What is etl - extraction, transformation, and loading?

0 Answers  

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

---

How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,

---

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

---

How to disable stored procedure sql server?

0 Answers  

---

Explain what is analysis service repository?

0 Answers  

---

Which table keeps the locking information?

0 Answers  

---

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

---