Writing stored procedures manually is tedious and error prone, is there a better way?
A hard to find Visual Studio feature allows building stored procedures visually. Through the the Server Explorer pane navigate to servers and then to your database. Right click on Stored Procedures and select “New Stored Procedure” or double click on an existing one. When it opens you can right click and select “Design SQL Block”. The interface is just like Queries in Microsoft Access. As you add tables to the design tab Visual Studio automatically add’s relationships between them. You can right click on the relationship to perform inner vs outer joins. This FAQ was contributed by dmittakarin8.
Related Questions
- Writing stored procedures manually is tedious and error prone, is there a better way?
- What is the most common error that students make in their writing assignments?
- What is the most common error that students make in their writing assignments?
- Is there a problem with Connection pooling and stored procedures?
- Is there a problem with Connection pooling and stored procedures?
- What are the procedures for writing a TAA?
