Answer Posted / anand k

For Ex. We are Using State Table for this scenario.

Records In State Table is (Total 50 Rec)
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming
--------

Now we are Selecting 25th record from the state table.

SELECT STA.*
FROM [State] STA,
(SELECT StateName,ROW_NUMBER() OVER (ORDER BY StateName)
ROWNO FROM [State] ) ROW
WHERE ROW.ROWNO = 25
AND ROW.StateNAme = STA.StateName
ORDER BY StateName

What are the filtered indexes?

978

---

What is subquery in sql?

989

---

What is function of CUBE ?

971

---

What is cursor in ms sql server?

1092

---

How can we migrate from SQL server to SQL Azure?

113

---

What is page in sql server?

901

---

Why do you want to join software field as you have done your BE in Electronics?

2105

---

What is sqlcmd?

963

---

What is report snapshot?

142

---

What are a database and a data warehouse?

972

---

what are user defined datatypes and when you should go for them? : Sql server database administration

964

---

Explain the etl (extraction, transformation, and loading)?

940

---

what are the different types of SSRS reports?

146

---

optimization techinques

2637

---

How to throw custom exception in Stored Procedure?

994

---