Sending Variable Information to an EXEC() Call : EXEC « Transact SQL « SQL Server / T-SQL Tutorial
Home
SQL Server / T-SQL Tutorial
1.
Query
2.
Insert Delete Update
3.
Table
4.
Table Join
5.
Data Types
6.
Set Operations
7.
Constraints
8.
Subquery
9.
Aggregate Functions
10.
Date Functions
11.
Math Functions
12.
String Functions
13.
Data Convert Functions
14.
Analytical Functions
15.
Sequence Indentity
16.
View
17.
Index
18.
Cursor
19.
Database
20.
Transact SQL
21.
Procedure Function
22.
Trigger
23.
Transaction
24.
XML
25.
System Functions
26.
System Settings
27.
System Tables Views
28.
User Role
29.
CLR
SQL Server / T-SQL Tutorial
»
Transact SQL
»
EXEC
20.19.5.Sending Variable Information to an EXEC() Call
DECLARE @IntVal
int
SET @IntVal =
21
EXEC
(
'us
p_MyProc
' +
STR
(
@IntVal
))
GO
20.19.EXEC
20.19.1.
The syntax of the EXEC statement
20.19.2.
EXECUTE AS
20.19.3.
Dynamic Selects
20.19.4.
A stored procedure with dynamic execution by using EXEC
20.19.5.
Sending Variable Information to an EXEC() Call
20.19.6.
Switch database in EXEC
20.19.7.
Statement Limit
20.19.8.
Parse exception in another level of scope: Exception in EXEC
20.19.9.
Execute a dynamic statement and return the result with OUTPUT
20.19.10.
Use more than one sql statement in EXEC
20.19.11.
Insert into with EXEC
20.19.12.
Using EXEC () to Execute a Dynamic TOP n Query
java2s.com
|
Contact Us
|
Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.