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
)

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

---

How do I find sql server instance name?

0 Answers  

---

What is an execution plan? When would you use it?

0 Answers  

---

What is bcp? When does it use?

0 Answers  

---

What are the components of dbms?

0 Answers  

---

When would you prefer to have a minimum number of indexes?

0 Answers  

---

Why would you use sql agent?

0 Answers  

---

How optimize sql query with multiple joins in sql server?

0 Answers  

---

How to use union to merge outputs from two queries together in ms sql server?

0 Answers  

---

Define the term DML, DDL and DTL?

1 Answers  

---

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

---