?
Solved

Setting the TABLE type parameter in Execute Procedure dialog in SSMS

Posted on 2014-01-22
8
Medium Priority
?
346 Views
Last Modified: 2014-05-05
How do I set the TABLE type parameter in the Execute Procedure dialog in SSMS
0
Comment
Question by:shanthi_joseph
  • 4
  • 2
7 Comments
 
LVL 12

Expert Comment

by:Saurabh Bhadauria
ID: 39802407
0
 

Author Comment

by:shanthi_joseph
ID: 39802410
I wished to enter the values in the Execute Procedure dialog, not in the script. Do you know how to enter the values for the TABLE type parameters in this dialog.
0
 
LVL 12

Expert Comment

by:Saurabh Bhadauria
ID: 39802491
I didn't get you point.. can you give here any example, what you want to acheive.


Thanks,
Saurabh
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:shanthi_joseph
ID: 39805587
I wish to enter the value for TABLE type parameter in the Execute Procedure dialog (please refer to attachment) obtained by right-clicking the stored procedure and selecting 'Execute Stored Procedure...' option.
execute-procedure-dialog.png
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39808094
Step 1: Declare a variable of the table type.
Step 2: Populate the table with INSERT statements
Step 3: Execute the Stored Procedure using the variables of type table as parameters.
0
 

Accepted Solution

by:
shanthi_joseph earned 0 total points
ID: 40033820
I do not require a solution to this problem.
0
 

Author Closing Comment

by:shanthi_joseph
ID: 40041608
I do not require a solution to this problem.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question