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

sandip.AP
on Nov 11, 2016 03:59 AM
12291 Views

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: Download

dharmendr
on Nov 11, 2016 06:53 AM

Answer

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

This site is started with intent to serve the ASP.Net Community by providing forums (question-answer) site where people can help each other. The content posted here is free for public and is the content of its poster. The site does not provide any warranties for the posted content. If you feel any content is violating any terms please contact.