How to Write stored procedure in SQL Server

[Benito]

How to use the stored procedure in SQL Server 2000, I think there is only one way to create a stored procedure: as a T-SQL statement. That was the course to take in every previous edition of SQL Server. Please let me know if there is any other method to implement.

[BlackSunReyes]

I think your problem solution is here: To create a stored procedure

1. In Object Explorer, connect to an instance of Database Engine and then expand that instance.
   
2. Expand Databases, expand the database in which the stored procedure belongs, and then expand Programmability.
   
3. Right-click Stored Procedures, and then click New Stored Procedure.
   
4. On the Query menu, click Specify Values for Template Parameters.
   
5. In the Specify Values for Template Parameters dialog box, the Value column contains suggested values for the parameters. Accept the values or replace them with new values, and then click OK.

for more information please check here.

[pancham]

The Base Class Library includes classes that provide functionality for improved string functioning, advanced math operations, file access, cryptography, and more. The first thing we need to do is write our .Net code for our Stored Procedure and compile it. In this case, we are simply going to send the string "Hello World from SQLCLR !!" back to the client. .NET languages such as VB .NET and C# offer object-oriented capabilities such as encapsulation, inheritance and polymorphism.

[Timothi]

Naturally, you must specify what usp_blahCookies means. SQL 2005 makes this easy. In order for us to use this code in SQL Server 2005 we must first compile it into an assembly. We can then load it into SQL Server and create our TSQL Stored Procedure header for our .Net code. In SQL Server Management Studio, under the Object Explorer, expand the database you want to add the Stored Procedure to, expand Programmability, right-click on Stored Procedures and select New Stored Procedures.