How to use copy and concatenate commands in SQL?

0 Answers   Amdocs,

---

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

---

Does sql server use t sql?

0 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---

Can we update data in a view?

0 Answers  

---

What is data compression?

0 Answers  

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  

---

Why can there be only one clustered index and not more than one?

0 Answers  

---

whate is advantages of sql server 2000

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

How to concatenate two strings in SQL Server.

0 Answers   HCL,

---

Does table partitioning improve performance?

0 Answers  

---