Answer Posted / r.rajesh

sp_columns table_name

What stored by the tempdb ? : sql server database administration

1030

---

How to disconnect from a sql server using mssql_close()?

1082

---

How to check table values in sql server?

940

---

What is snapshot parameter in ssrs?

150

---

what are candidate key, alternate key and composite key? : Sql server database administration

894

---

How to optimize stored procedures in sql server?

1165

---

What is the recommended total size of your memory optimized tables?

955

---

How do I find the query plan in sql server?

940

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1488

---

What is the difference between update lock and exclusive lock?

960

---

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

2215

---

What is a coalesce function?

1165

---

Can two tables have the same primary key?

1182

---

Explain mixed authentication mode of sql server?

1032

---

Data table as parameter in sql server?

1021

---