When I execute the following SQL statement: execute dbo.testtable_pricesmaller 50 ![]() I find it very strange when I receive the following error: Could not find the stored procedure 'dbo.testtable_pricesmaller'. (It is listed in the following tree structure of the Object Explorer) Databases Select * from testtable where price = are able to view the Stored Procedures on the Object Explorer of the Microsoft SQL Server Management Studio. I created a stored procedure testtable_pricesmaller as follows use testbase Which I used the Microsoft SQL Server 2008 Management Studio. ![]() I have created a table testtable inside the database testbase that have the following structure: product_no (int, not null)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |