Does Visual Studio .NET provide integration with SQL Server?
Yes. Visual Studio .NET provides a very high level of integration with SQL Server. You can connect to SQL Server using Server Explorer. After you are connected, you can browse the database and even create new objects. In particular, you can create and edit stored procedures written in the native SQL Server procedure language TSQL.