Posts
Sort by recent activity
Code Coverage Error
Latest SQL Test comes with Code Coverage tool, however it doesn't start up. I'm getting the following exception:
SQLCover.SqlCoverException: SQL Cover was not started, or did not start correctly....
Formatting SQL statements that contain WITH CHANGE_TRACKING_CONTEXT
So I've got SQL statement as follows:
WITH CHANGE_TRACKING_CONTEXT(@ContextID)
UPDATE lcoc
SET lcoc.cmpName = tmp.cmpName
, lcoc.ctyCode = tmp.ctyCode
, lcoc.cmpYearDead = tmp.cmpYearDead
, l...
Non-named parameter style for sp_executesql
I've got a perfectly valid sp_executesql statement to run my dynamic queries, however SQL Prompt marks it as an issue. There's no way to add parameter names to it.
Code sample:
EXECUTE sys.sp_execu...