procedure to insert and delete using sql server 2008

Question

Need procedure for insert two table at a time and truncate table
Like table1
Button1 I need to insert these two tables in front end asp.net using c# (web application)
Date 18.8.13
Productname cement
Price 300
Extra 10 (310*14.5/100)=44.95
Vat 14.5/100
Total 354.95

Table2

Date
Productname: closeup
Price 50
Vat 14.5/100
Total 57.25

Button 2 click event I need to truncate table1

Iftikar Hussain · Answer

then create procedure for inserting data into these two table along with truncate If you don't know how to create procedure then go thru the below link http://www.codeproject.com/Articles/38682/Overview-of-SQL-Server-Stored-Procedure Regards Iftikar

selvi subramanian · Answer

i need to truncate the table.. hussain i need to multiply the dropdown value and textbox value .

Iftikar Hussain · Answer

why do you want to truncate? It will delete all record

selvi subramanian · Answer

truncate the table hussain

Jignesh Trivedi · Answer

hi Can you please provide more information? so that we can help you. we are not getting you problem.

Iftikar Hussain · Answer

Hi Create procedure for deleting record from table1 . You want to truncate or delete data from TABLE1 Regards Iftikar