How can we help you today? How can we help you today?

Does SQL Prompt have auto--convert from/to sp_executeSQL

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') 
 

Ed Carden
0

Comments

1 comment

Sort by
  • Josh Head
    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. 

    Josh Head

Add comment

Please sign in to leave a comment.