hr8886 Posted December 8, 2009 Share Posted December 8, 2009 -Write a stored procedure that accepts an INV_NUMBER, CUS_CODE, and INV_DATE, and inserts them as a new row in the INVOICE table in your "DB" database. Then run the procedure to add one new row. -Create a non-clustered index on the P_PRICE column of the PRODUCT table in your "DB" database and then delete the index you created. Link to comment https://forums.phpfreaks.com/topic/184340-need-help-making-these-sql-queries/ Share on other sites More sharing options...
trq Posted December 8, 2009 Share Posted December 8, 2009 Where exactly are you stuck? Were not here to do homework for people. Link to comment https://forums.phpfreaks.com/topic/184340-need-help-making-these-sql-queries/#findComment-973255 Share on other sites More sharing options...
Gamic Posted December 13, 2009 Share Posted December 13, 2009 Create Procedure Create Index Try to do this yourself and we may be inclined to help. Link to comment https://forums.phpfreaks.com/topic/184340-need-help-making-these-sql-queries/#findComment-976476 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.