Regarding StoredProcedure
-
Hi I want to know how to write storedprocedure when search creiteria is Present. Here the query to give the list of "select ID, Salesmennummer , Salesname Commision, Areacode from sales_master Areacode Salesmennummer Salesname Commision 1 1000 Rams 200 2 2000 Johny 1000 I Want to search above list by areacode or Salesmennummer or Salesname. so PlZ help me how to write storedprocedure for this. Thanq.
-
Hi I want to know how to write storedprocedure when search creiteria is Present. Here the query to give the list of "select ID, Salesmennummer , Salesname Commision, Areacode from sales_master Areacode Salesmennummer Salesname Commision 1 1000 Rams 200 2 2000 Johny 1000 I Want to search above list by areacode or Salesmennummer or Salesname. so PlZ help me how to write storedprocedure for this. Thanq.
Have a look at the example B in CREATE PROCEDURE[^]
The need to optimize rises from a bad design.My articles[^]