Community forum

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


  1. Forum
  2. Support
  3. General problem solving
  4. Unable execute SQL Query via VC
krishnat
2014-03-24T13:00:04Z
Hi,

When I tried executing a SQL query through VC i am getting the following error

Error in SQL query: Must declare the scalar variable "@market".

Exception in Task: Must declare the scalar variable "@market".

Whereas I am able to execute the same query in query analyzer.

FYI - I have declared the @market variable (Declare @market varchar (500))
 Reply
 View All Posts by User
Sponsor
Forum information
Support
2014-03-25T07:49:13Z
Originally Posted by: krishnat 

Hi,

When I tried executing a SQL query through VC i am getting the following error

Error in SQL query: Must declare the scalar variable "@market".

Exception in Task: Must declare the scalar variable "@market".

Whereas I am able to execute the same query in query analyzer.

FYI - I have declared the @market variable (Declare @market varchar (500))




Please attach screenshots. It sounds like you do not use Stored procedure tab in the SQL Task.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
 Reply
 View All Posts by User
Similar Topics
Users browsing this topic
  1. Forum
  2. Support
  3. General problem solving
  4. Unable execute SQL Query via VC
 

© VisualCron

Scroll to Top