Answer Posted / udathayadav

select * from tablename.aliasname where nth=select
count(sal) from tablename where aliasname.sal<=sal

How do you size a resultset?

965

---

Why truncate is ddl command?

1116

---

You want to use a perspective in an mdx query. How do you select the perspective?

246

---

How do I start sql server?

1030

---

What are examples of triggers?

1125

---

What is the sql case statement used for? Explain with an example?

1039

---

What are the differences between user defined functions and stored procedures?

1135

---

Explain about local stored procedure?

1028

---

Why truncate is ddl?

1133

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

966

---

Does a server store data?

953

---

How do I view a procedure in sql server?

1037

---

What are different types of raid configurations? : SQL Server Architecture

1133

---

Explain the commands in sql server?

1096

---

Explain Geometry datatype in sql server 2008 with example

1049

---