Answer Posted / latha k

declare @N INT
SET @N = 3
SELECT *
FROM [user] AS [user]
WHERE @N = (SELECT COUNT(DISTINCT(user1.Salary))
FROM [user] AS [user1]
WHERE user.Salary <= user1.Salary
)

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

956

---

What is the purpose of object explorer and its features? : sql server management studio

1215

---

What do you understand by SQL*Net?

1037

---

Can a table be created inside a trigger?

972

---

Is resultset an interface?

976

---

Please explain go command in sql server?

1058

---

Which tools are available to manage SQL Azure databases and servers?

115

---

How you can get the list of largest tables in a database?

1018

---

How does Report Builder support Analysis Services cubes?

156

---

What are acid properties of transaction?

950

---

How much does sql server 2016 cost?

1076

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

999

---

Differentiate between a having clause and a where clause.

965

---

What is the use of stored procedure?

943

---

How to modify an existing stored procedure in ms sql server?

1082

---