Answer Posted / sreeja.t.pillai

SELECT MIN(EmpSal) Min_Salary FROM Employee_Details

Explain what is the use of custom fields in report?

898

---

What are date and time data types in ms sql server?

1074

---

Define Business Edition in SQL Azure?

100

---

what kind of lan types do you know? : Sql server database administration

964

---

What is Federation and Federation Member?

92

---

Explain “row_number()” in sql server with an example?

984

---

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

2216

---

Explain the xml support sql server extends?

1023

---

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., }

2319

---

Do you know what is sql injection?

983

---

Can you create a logon trigger in sql server 2005 express edition?

1063

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

938

---

How do I view views in sql server?

987

---

How can you list all the table constraints in a database?

920

---

explain databases and sql server databases architecture? : Sql server database administration

942

---