SQL Execute Stored Procedure

[Marten]

Hi All,

I have created an stored procedure in an SQL server.  

I would like to create a table whith a  variable name. 

EXEC CreateTable[:Test] 

It creates always a table with the same name.  The name between brackets [] 

This Test parameter should be variable, how can I archieve this? 

 

 

 

 

[AlexUT]

Hi Marten,

Please visit Unitronics Helpdesk Portal

https://support.unitronics.com/index.php

and search for "stored"

Look "SQL Dynamic Table Name" article.

 

 

[Marten]

Thanks,

I do not completely understand. 

I have created and tested  a stored procedure in management studio, 

input variable is @|TableName 

 

But how to adress the variable name in Unilogic?

 

It works but only inserts a static/constant table name, not dependent on a var.

 

In the example it provides information on how to insert a table, and this works. But how to call/handle the  [dbo].[Dymanic_Query] :TableName especcially the : TableName