Saturday, 6 July 2013

Create html table by using sql store procedure

          Hi ,
                                    In this article we will see how to create html table inside html table
by using sql server to show data of select statement.
step 1:: Create table


CREATE TABLE #TEMP (EMP_NAME VARCHAR(100),CHILD_NAME VARCHAR(100),CHILD_HOBBY VARCHAR(100),CHILD_AGE INT)

step 2:: Insert data in table


insert into #temp (emp_name ,child_name,child_hobby,child_age) values('KEDAR','ADITYA','CRI',2)

insert into #temp (emp_name ,child_name,child_hobby,child_age) values('KEDAR','ADITYA','READ',2)

insert into #temp (emp_name ,child_name,child_hobby,child_age) values('KEDAR','PRANAV','CRI',4)

insert into #temp (emp_name ,child_name,child_hobby,child_age) values('KEDAR','PRANAV','READ',4)

insert into #temp (emp_name ,child_name,child_hobby,child_age) values('RAKESH','KHANds','TE',24)

insert into #temp (emp_name ,child_name,child_hobby,child_age) values('RAKESH','KHANsd','ME',42)

insert into #temp (emp_name ,child_name,child_hobby,child_age) values('RAKESH','IMRANd','JI',23)

insert into #temp (emp_name ,child_name,child_hobby,child_age) values('RAKESH','IMRANd','CI',23)


step 3:: Use below query for select data and create html table inside html table.

 

step 4::Output

No comments:

Post a Comment

8451831077