Comments
1 comment
-
Official comment
Hi Ed,
SQL Prompt does not currently include a built-in feature to automatically expand or inline
sp_executesql
statements into their fully parameterized DML equivalents like you're asking for. If you'd like to make a feature request, I'd suggest visiting our User Voice site.
Add comment
Please sign in to leave a comment.
Does SQL Prompt have any feature that will take an instance of an sp_executesql statement and convert into the DML command?
For example how to convert
this:
exec sp_executesql N'insert into AuditLoginAngularCafeApps (sProductName,ElevateUserId,SessionIP,DtIn) values(@productname,@elevateuserid,@sessionip,@datein) ',N'@productname nvarchar(8),@elevateuserid nvarchar(22),@sessionip nvarchar(18),@datein datetime',@productname=N'crmiqnet',@elevateuserid=N'john.doe@MySpace.com',@sessionip=N'::ffff:172.20.90.7',@datein='2025-05-19 19:40:16.320'
to this:
insert into AuditLoginAngularCafeApps (sProductName,ElevateUserId,SessionIP,DtIn)
values('crmiqnet','john.doe@MySpace.com','::ffff:172.20.12.7','2025-05-19 19:40:16.320')