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

Add comment

Please sign in to leave a comment.