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. Quote 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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.