How is SQL Prompt helping your team? Share your experience.

This post is just a suggestion for a new feature.

Converting T-SQL into its dynamic equivalence and vice versa. 
It would be nice to click on context menu and transform T-SQL statement into its dynamic equivalent. 
For example the following T-SQL statement 

DECLARE @BusinessEntityID tinyint = 101
SELECT BusinessEntityID, NationalIDNumber, JobTitle, LoginID FROM AdventureWorks2012.HumanResources.Employee WHERE BusinessEntityID = @BusinessEntityID


DECLARE @IntVariable INT;  
DECLARE @ParmDefinition NVARCHAR(500);  

SET @SQLString =  
     N'SELECT BusinessEntityID, NationalIDNumber, JobTitle, LoginID  
       FROM AdventureWorks2012.HumanResources.Employee   
       WHERE BusinessEntityID = @BusinessEntityID';  

The opposite case is also extremely very useful!
I hope you understood my suggestion. :)
Best regards!


Sign In or Register to comment.