Answer Posted / kumar

You will be do following things one by one in sql server.

first create table.

1.create table tablename(sno int identity(1,1) primar key,
names varchar(100))

insert the record one by one.

2.
Insert into tablename(names) values ('arun')
Insert into tablename(names) values ('arun')
Insert into tablename(names) values ('arun')
Insert into tablename(names) values ('arun')
.
.
.
.
To Insert 1000 record one by one.

Then to execute the following query to get last 3 record.

select top 3 * from tablename
order by 1 desc


you will be get the correct answer ok.

By
kumar

Define constraints and give an example of their use?

983

---

what is checksum in sql server.........???

1618

---

What is the meaning of resultset type_scroll_insensitive?

910

---

What is the native system stored procedure to execute a command against all databases?

968

---

What is a rollup clause?

908

---

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

989

---

Does a sql server 2005 select statement require a from?

970

---

What are the different types of subquery?

1097

---

How can I know what locks are running on which resource?

898

---

What is the difference between sdf and mdf?

1232

---

What are sql dirty pages?

969

---

What is 2nf example?

941

---

How to query multiple tables jointly?

919

---

What are types of scd? : sql server analysis services, ssas

973

---

can a table be moved to different filegroup? : Sql server administration

910

---