Stored procedure take field.. Moderators to help the bai-CodePudding

See figure, the storage process query results, I only show the fields, after the search is inserted into the FFF333 table, could you tell me how to get each warrior, and solve the problem points again ha

CodePudding user response:

I'm sorry, didn't see.

CodePudding user response:

reference 1/f, started the first response:

I'm sorry, didn't see.

,,, is to query data storage process, inserted the FUP this field to a new table, the table name casually, understand

CodePudding user response:

or, as long as I through the storage process query language words of queries to FUP this field,,,, and then insert a new table,,,, it is hard to understand

CodePudding user response:

 
The create table # r (all [field]) 

Insert into # r (all [field]) 
The exec [stored procedure name] [parameter] 

The create table # r2 (FUP decimal (18, 6)) 

Insert into # r2 (FUP) 
The select FUP from # r

CodePudding user response:

reference 4 floor started the first response:

 
The create table # r (all [field]) 

Insert into # r (all [field]) 
The exec [stored procedure name] [parameter] 

The create table # r2 (FUP decimal (18, 6)) 

Insert into # r2 (FUP) 
The select FUP from # r

Hello, the moderator, the all fields are stored in the process of all fields? Want to knock out one by one

CodePudding user response:

All fields are stored procedure returns all the fields,
Can open the stored procedure code, for example the last line is a select statement (set),
Can manually run the stored procedure code, and then the select statement or select... Into new [table name]...
Then right-click in SSMS to obtain new [table name] table statements, don't have knocked.

CodePudding user response:

refer to 6th floor started the first response:

all field is the stored procedure returns all the fields,
Can open the stored procedure code, for example the last line is a select statement (set),
Can manually run the stored procedure code, and then the select statement or select... Into new [table name]...
Then right-click in SSMS to obtain new [table name] table statements, don't knocked.

Rao a big circle, directly select statement clock again, add a into table, to take what her ha ha