sql server stored procedure tutorial for beginners

In SQL Server, there are not many opportunities to extend the storage process for direct use.I have summarized several useful extended stored procedures as follows: -- Obtain the version number of MS SQLExecute master .. sp_msgetversionGo-- The effect is as follows:Character_value------------------------------------------8.00.760 1 3 (The number of affected r

Create or replace PROCEDURE CMPP_SUBMIT_REMOVE_PROCEDUREIsDEndTime date; -- each processing is a time point -- get the ID of the data to be processedCursor c_cmpp_submit (endTime date) isSelect id from cmpp_submitWhere (ih_process Or (ih_process = 'wait _ for_response 'and ih_retry And ih_timestamp ICount number; -- CounterBegin -- dEndTime: = trunc (SYSDATE-1/288), 'mi'); -- obtains the processing time and processes the data five minutes ago.DEndTime

Small, with parametersif (exists (SELECT * from sys.objects where name = ' proc_get_purchasing2 '))drop proc Proc_get_studentGoALTER proc PROC_GET_PURCHASING2 (@today int)As--declare @today intDeclaration variablesdeclare @weeks nvarchar (3)Set Variable value set @weeksSet @weeks =case when @today = 1 Then ' Monday ' When @today = 2 Then ' Tuesday 'Else ' ERROR 'EndPrint @weeksEXEC proc_get_purchasing2 @today =2With loopsif (exists (SELECT * from sys.objects where name = ' Proc_get_purchasing3 '

Creates a temporary table that reports errors when inserting data into a temporary table. A start prompt does not open the primary key, and then the primary key is turned on to prompt the above error exception. Find information from the Internet did not find, and then to the group to ask you Daniel, a Daniel told me is not set the primary key. I took a closer look at the hint and realized that I had set the primary key temporarily. Code before the primary key: CREATE TABLE #TT ( cours

Many friends may have been using SQL Server for development for some time, but have not or rarely used the stored procedures in the project, perhaps some friends think that there is no need to use stored procedures and so on. In fact, when you finish the maintenance phase of a project, you will find that the

We know that SQL Server has a very strong selection of drivers for a linked server (linked server), a linked server (linked server) that was recently established with the Microsoft OLE DB driver for ODBC, and when the

c++|server| backup | stored Procedure | server | client | data | database 1.Create A backup database stored procedure in master database. CREATE PROCEDURE backupdb @database varchar (1

is declared and needs to be inserted before the BEGIN keyword: dynamic RESULT sets 1LANGUAGE sql*/create PROCEDURE a_test2 ( V_c VARCHAR (()) DYNAMIC RESULT sets 1LANGUAGE sqlbegin DECLARE t_sql VARCHAR2 (a); DECLARE t_a VARCHAR2 (); DECLARE t_b VARCHAR2 (); DECLARE t_c VARCHAR2 (); DECLARE t_d VARCHAR2 (); --The t_stmt behind the for is consistent with the following

; set @userId = @userId; set @UserName = @UserName; set @passDate = @passDate; Set @inOut = @inOut; exec [dbo]. [Sendinfotoremotedb] @CardNo = @CardNo, @CardStyle = @CardStyle, @userId = @userId, @UserName = @UserName, @passDate = @ Passdate, @inOut = @inOutprint ' Send message successfully! ‘;Then the result was first run successfully, but the second time prompted Ims_srv_lnk to exist and not run. Back to think about the code inside the connection

Create a linked server. Linked servers allow users to distribute heterogeneous queries to OLE DB data sources. Create a link using sp_addlinkedserverServer, you can run distributed queries against the server. If the linked server is defined as an instance of SQL Server, the

SQL Server stored procedure syntax:Create PROC [edure] procedure_name [; number] [{@parameter data_type} [VARYING] [= default] [OUTPUT]] [,... n] [with {RECOMPILE |Encryption | RECOMPILE, encryption}] [for REPLICATION] as sql_statement [... n]I. Introduction of Parameters 　 1, procedure_nameThe name of the new

The concept of stored procedures Stored procedure procedure is a set of SQL statements that are compiled and stored in a database to complete a specific function, and are executed by specifying the name of the

SQL stored procedure definition and stored procedure benefits SQL stored procedure definition and stor