Determine (Identify) parameters type in query in SQL Server

ilanocf says:

when the user executes this query, the system displays a grid showing the parameters and their respective types for the user to type their respective values

Please explain the above statement with example.

hello dharmendr,

Thank you in advance for your attention. Well as I said I created a register only of SQL queries and what I need to do is the following:

• A user selects a registered query in a datagrid.
• When executing this query, I need the system to check if it has parameters and what their types are, so I pass in the parameters those endings _S (for string), _I (for integer), _L (for like) ...
• Then the system should open a modalpopup bringing the fields referring to these parameters, that is, if in the query below I have the UF_S and NAME_L parameters, the system will show me two TextBox for the user to type the values ​​of each parameter

SELECT A.ID, A.STATEID, A.NAME, B.UF FROM CITIES TO INNER JOIN B ON STATES (B.ID = A.STATEID) WHERE B.UF = :UF_S AND A.NAME LIKE :NAME_L

Then the user asks to run and my DataGrid is generated based on the values ​​passed in the fields.

The idea is to make the system bring me a modalpopup bringing fields referring to each parameter where the user informs the value of each one of them.

Hi ilanocf,

No it is not possible to determine the parameters and their types from query.

If you are using Stored Procedure the you can determine the  parameters and their types using the following query.

SELECT name 'ParameterName',
	type_name(user_type_id) 'DataType',
	max_length 'Length'
FROM sys.parameters
WHERE object_id = object_id('ProcedureName')

It will return list of ParameterName, DataType and Length.