how to Insert new row in database?

suppose your table have 100 rows
you wants to insert row at 6

you need to take five steps

1.first put data into temp table  rows 6 to 100
2. delete rows from 6 to 100
3.set auto identity key of your table to 5
4.insert your row
5.Insert your data from temp table to your table
6.Drop temp table

now lets see in practical..
assume you have Id as your primary key of your table
 
1.select Question_no,question,ans1,ans2,ans3,ans4,correct ans,practical_lab,sub_topic
into #temp from table where Id>5

2.delete from table where where Id>5

3.DBCC CHECKIDENT (table , reseed, 5)

4.insert into table(Question_no,question,ans1,ans2,ans3,ans4,correct ans,practical_lab,sub_topic) values(value1,value2,......etc.)

5.insert into table(Question_no,question,ans1,ans2,ans3,ans4,correct ans,practical_lab,sub_topic) select Question_no,question,ans1,ans2,ans3,ans4,correct ans,practical_lab,sub_topic from #temp

6.drop table #temp