Answer Posted / srinu

No Join is required

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2266

---

What are the underflow and overflow behaviors on float literals?

1061

---

How many servers can we create in a single subscription?

158

---

How will you go about resolving deadlocks?

912

---

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

2181

---

Why Master database is required?

1060

---

How to create user defined functions with parameters?

1166

---

What are the dis_advantages of stored procedures, triggers, indexes?

2172

---

how to take backup bcp out for a column in table in sql server?

2047

---

How to turn on the mssql api module in php?

1017

---

What is schemabinding a view?

865

---

what is raid? : Sql server database administration

974

---

How to convert a unicode strings to non-unicode strings?

1031

---

What is dbcc? Give few examples.

955

---

What is the difference between ddl and dml?

1005

---