Answer Posted / rajkumar

select getdate()

Write the SQL query to drop, truncate and delete table.

1020

---

How to list all columns in a table using odbc_columns()?

1025

---

How do you clear a log file?

1106

---

Is it ok to shrink transaction log?

1048

---

What are the differences between decimal and float in ms sql server?

1340

---

What is ms sql server index?

1145

---

query processing

2213

---

what are the important architecture components of SSRS?

146

---

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.

2982

---

What is 1nf 2nf?

1057

---

What are the properties of primary key?

1014

---

What is difference between table aliases and column aliases? Do they affect performance?

1015

---

What are the different types of upgrades that can be performed in sql server?

1211

---

What is user-defined multi-statement table-valued function?

1110

---

How do I trace a query in sql server?

994

---