Create Store Procedure in MS SQL Server 2005 using VB.NET

• Yav Chhuong

  Grasshopper

  Points: 19

  More actions

  December 22, 2005 at 10:02 pm

  #169943

  I am new to MS SQL Server 2005. I know that we can create stored procedure in MS SQL Server 2005 two ways: T-SQL and VB.NET or C#. Can one tell me how can i do that?

• Jason Witty-257283

  Mr or Mrs. 500

  Points: 500

  More actions

  December 23, 2005 at 1:22 am

  #611257

  1. open up visual studio 2005

  2. choose other project types, database project.

  3. setup your db reference

  4. right click on queries and choose add new query.

  5. choose stored procedure script and name your .sql file.

  6. fill in you sql statement in the sproc template or use design sql to generate it visually.

  7. choose project -> run

  I recently adopted this method of writing stored procedures so i could take advantage of the source control features of vss2005