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 is change data capture (cdc) in sql server 2008?

1030

---

Explain indexes disadvantages?

1097

---

How to find the version of sql server? : sql server database administration

1122

---

Explain indexed views?

989

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1036

---

What is user-defined scalar function?

976

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1027

---

Explain what is use of dbcc commands?

1065

---

what is the difference between openrowset and openquery?

1095

---

How to check parameter value in stored procedure sql server?

983

---

How to provide values to stored procedure parameters in ms sql server?

1047

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1047

---

Explain how to use linked server?

1000

---

How to get a list of columns using the "sys.columns" view in ms sql server?

956

---

Can a table be created inside a trigger?

977

---