What is table-valued sub query?

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  

---

Where the sql logs gets stored? : sql server database administration

0 Answers  

---

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  

---

how do u find least salary in a table

4 Answers  

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

0 Answers  

---

Why Master database is required?

0 Answers   Abacus,

---

List down some advantages of sql stored procedure?

0 Answers  

---

How connect excel to sql server?

0 Answers  

---

What are the advantages of having an index on the sql server?

0 Answers  

---

What are the restrictions while creating batches in sql server?

0 Answers  

---

Explain timestamp datatype?

0 Answers  

---