Home » Source Code » Using T-SQL to write a stored procedure

Using T-SQL to write a stored procedure

cshlj
2015-09-06 22:00:27
The author
View(s):
Download(s): 0
Point (s): 1 
Category Category:
SQL ServerSQL Server Transact-SQLTransact-SQL

Description

Application background

Introduce the basic usage of T-SQL stored procedure, for beginners learning to use. A stored procedure is a set of Transact-SQL statements precompiled, as a unit of storage on the server and executed on the server. The stored procedure can take input, output parameters, return values. With the advantages of stored procedures are as follows:(1) the safety of stored procedure can force the application, can prevent SQL injection attacks.(2) the stored procedure can greatly reduce network traffic. (3) the stored procedure is registered in the server, the implementation of high efficiency.(4) the storage process greatly improves the maintainability of the application and the design efficiency.

Key Technology

In the SQL defined in Server 2008, execute, modify the stored procedure. The use of create procedure or create proc stored procedure, use exec or execute to execute a stored procedure, the use of alter proc or alter procedure to modify an existing stored procedure. The use of input, output parameters. Contains the user login, change password, fuzzy query, stored procedure.
Sponsored links

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
testProcedure.sql3.41 kB2015-09-07 09:45
...
Sponsored links

Comments

(Add your comment, get 0.1 Point)
Minimum:15 words, Maximum:160 words
  • 1
  • Page 1
  • Total 1

Using T-SQL to write a stored procedure (1.46 kB)

Need 1 Point(s)
Your Point (s)

Your Point isn't enough.

Get 22 Point immediately by PayPal

Point will be added to your account automatically after the transaction.

More(Debit card / Credit card / PayPal Credit / Online Banking)

Submit your source codes. Get more Points

LOGIN

Don't have an account? Register now
Need any help?
Mail to: support@codeforge.com

切换到中文版?

CodeForge Chinese Version
CodeForge English Version

Where are you going?

^_^"Oops ...

Sorry!This guy is mysterious, its blog hasn't been opened, try another, please!
OK

Warm tip!

CodeForge to FavoriteFavorite by Ctrl+D