What is Files and Filegroups in SQL Server & it's implementation.

1 Answers   Zenith,

---

When you use @@error and try-catch?

0 Answers  

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

What is the difference between executequery () and executeupdate ()?

0 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

What is data mart? : sql server analysis services, ssas

0 Answers  

---

Explain about temporary stored procedure?

0 Answers  

---

select names starts with a,b,c

8 Answers   Scope International,

---

What is sql injection? How to protect against sql injection attack?

0 Answers  

---

List few advantages of stored procedure.

0 Answers  

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

What is data source in connection string?

0 Answers  

---