Revolving around the core of technology
Good afternoon!
I'm running a query in WINSQL that has many subqueries inside of it and I wanted to declare a variable or constant so all of the WHERE statements that have a specific date range can be changed from one central location.
I can't seem to find any source that can explain how I can accomplish this. Could anyone please help?
Kendall,
WinSQL does not have any syntax of its own. Whatever you type goes to your back-end server, which then parses the script. The only exception to this rule is a Query Terminator (https://web.synametrics.com/QueryTerminator.htm ), which causes WinSQL to break the script and submit them one after another.
Therefore, if you get any errors related to the syntax of your query, refer to the documentation of your back-end server to see what is the correct method.