Answer / Gunjan Sharma

Linked Server is a feature in SQL Server that allows you to access and execute database objects located on other servers as if they were local. It enables data manipulation across heterogeneous data sources, making it possible to perform queries that span multiple databases or even different types of database systems.

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

Can we use trigger new in before insert?

1 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1 Answers   HCL, Wipro,

---

What is merge replication?

1 Answers  

---

What is set nocount on?

1 Answers  

---

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

---

What is the difference between referencing and joining?

1 Answers  

---

What is data source document?

1 Answers  

---

Explain candidate key, alternate key, and composite key?

1 Answers  

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

What are the purposes of floor and sign functions?

1 Answers  

---