How to Pass Columns Name and Table Name as Parameter to Stored Procedure in MySQL

sandip.A...

SOLVED CLOSED ACTIVE ANSWERED
User: sandip.AP
Posted: on Nov 11, 2016 03:59 AM
Forum: MySQL
Answer: 1
Views: 15630

Currently i am Creating Some Stored Procedure in mysql, but i would like to Use Some Dynamic Stored Procedure, means i would like to pass Parameters in mysql Stored Procedure.

I request to you how to Pass Columns name and Table name as Paramaters.

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Nov 11, 2016 06:53 AM
Report

Hi sandip.AP,

Check with the below query. This is with SQL Server. So you need to change as per mysql query.

DECLARE @Date DATETIME, @Col_Name VARCHAR(MAX), @Table_Name VARCHAR(50)
SET @Date = CurDate()
SET @Col_Name = 'AJB1_STR1'
SET @Table_Name = 'k01_block1_ajb1'

DECLARE @DynamicQuery NVARCHAR(MAX)
SET @DynamicQuery = 'SELECT	' + @Col_Name +' FROM ' + @Table_Name + ' WHERE Date(LocalCol)= ' + @Date

EXEC(@DynamicQuery)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to Pass Columns Name and Table Name as Parameter to Stored Procedure in MySQL

Company

Explore

Follow us

Contact Us