Answer Posted / antony

select distinct A.id,A.salary from employee A,employee B
where A.salary = B.salary and A.id <> b.id;

Does server sql treat char as a variable-length or fixed-length column?

1044

---

Explain filtered indexes benefits?

1001

---

How to provide values to user defined function parameters?

1010

---

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

957

---

What are the new features in sql server 2016?

969

---

How to access the inserted record of an event?

1049

---

How do you know if sql server is running on your local system?

1044

---

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

2241

---

What do you mean by authentication modes in sql server?

1087

---

What is the use of sql profiler in sql server 2012?

900

---

How do you rename a table in sql server?

1032

---

What is the order by used for?

1024

---

Explain subquery and state its properties?

1049

---

Explain isolation levels that sql server supports?

1044

---

What is transact-sql ddl trigger?

1111

---