StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POStored Procedure Dynamic SQL stored result in variable
primarykey
Id
7834286
data
AcceptedAnswerId
7834559
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-10-20T10:04:22.313
FavoriteCount
0
LastActivityDate
2011-10-20T10:25:12.233
LastEditDate
LastEditorUserId
0
OwnerUserId
883398
ParentId
0
PostTypeId
1
Score
1
ViewCount
2387
LastEditorDisplayName
text
Body
I have A stored procedure written <pre><code>DECLARE @AreaID AS INT DECLARE @DayPrior AS INT DECLARE @TableName AS VARCHAR(50) DECLARE @StoreQuery AS NVARCHAR(MAX) DECLARE @SQL_ExtractDlSql AS NVARCHAR(MAX) DECLARE @ParameterDefinition AS NVARCHAR(2000) SET @AreaID = 1 SET @DayPrior = 1 SET @TableName = 'Tbl_Lube' SET @SQL_ExtractDlSql = 'SELECT Download_SQL From HDDDataPackage.dbo.tbl_HDD_DataDownloadSetting Where AreaId=@AreaID AND TableName=@TableName' SET @ParameterDefinition = '@AreaID INT,@DayPrior INT,@TableName VARCHAR(50)' EXECUTE sp_executesql @SQL_ExtractDlSql, @ParameterDefinition, @AreaID, @DayPrior, @TableName PRINT @SQL_ExtractDlSql </code></pre> I above Stored procedure, I get What I wanted on print, but instead of doing that, I wanted the selected data stores as a variable. Then what I done is I declared a variable @StoreSql and made some modified into the SQL statement show below: Variable Declaration: <pre><code>DECLARE @StoreSql AS NVARCHAR(MAX) </code></pre> Modified the Code: <pre><code>SET @SQL_ExtractDlSql = 'SELECT @StoreSql = Download_SQL From HDDDataPackage.dbo.tbl_HDD_DataDownloadSetting Where AreaId=@AreaID AND TableName=@TableName' </code></pre> I executed the code, I get error Must declare the scalar variable "@StoreSql". I have totally no idea how to deal with this.Any one can help.Beside,I am new to sqlserver,new to stored procedures. Please don't hesitate to point out my any mistake,any..such as logic or etc. I learn from mistake. Regards LiangCk
Tags
<sql-server-2008><variables><stored-procedures><scope><dynamic-sql>
Title
Stored Procedure Dynamic SQL stored result in variable
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USWorgon
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POStored Procedure Dynamic SQL stored result in variable
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.