2
Answers

insert itemname into corresponding columns in sql 2005

Maneesh A N

Maneesh A N

11y
952
1
if we have got itemid in tableSalesItem, how to save itemname into corresponding columns in database.means ,example  itemname 'tea' ,corresponding itemid '1' getting,but not inserting...how to use if..else condition for each catagory...

tableSalesItem(i want to insert vTea    Coffee
                                                    Tea    Coffee  like this,here i have doubt..how?)

vTea        int,
vCoffe      int,
vSoft        int,
vMineral   int,
vFax         int,


tableItem(already inserted)

vItemName      iItemId

 
Tea                    1
Coffee                2
Soft                    3
Mineral               4
Fax                     5
Answers (2)
0
Suthish Nair

Suthish Nair

NA 31.7k 4.6m 11y
Please close the duplicate thread. Already another thread is active and please do not create duplicate threads going forward.
0
Maneesh A N

Maneesh A N

NA 179 82.9k 11y
pls Ans Sir
Next Recommended Forum