Answer Posted / kongu karunakaran

select datename(month,parametername or columnname) from
tablename

Explain the properties of sub-query in sql server?

964

---

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.

2891

---

What are policy management terms?

946

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

910

---

How you can change the database name in SQL SERVER?

1150

---

What is a view in sql?

935

---

Different types of keys in SQL?

1043

---

What is the command used to recompile the stored procedure at run time?

1033

---

What is default constraint in ms sql server?

977

---

What are the basic features of a trigger in ms sql server?

1131

---

How to create hyperlink from returned sql query ?

1083

---

What happens to a statement batch if there is a compilation error?

914

---

What is a fan-out query in SQL Azure?

121

---

how you can get the list of largest tables in a database? : Sql server administration

1002

---

What do you understand by the data quality services in sql server?

915

---