Skip to content

Instantly share code, notes, and snippets.

@mikebuchanon

mikebuchanon/sqlvar_example.sql

Created July 4, 2013 15:42
Show Gist options
  • Save mikebuchanon/5928714 to your computer and use it in GitHub Desktop.
Save mikebuchanon/5928714 to your computer and use it in GitHub Desktop.
Download ZIP
An example of using SQL Variables in ANGEL's SQL Query Manager
Raw
sqlvar_example.sql
-- This script finds a specific user in a specific course
SQLVAR: $COURSE_ID$ = [?Enter a course id]
SQLVAR: $USER_ID$ = [?Enter a user id]
--Execute the script
SELECT * FROM dbo.COURSE_ROSTER WHERE COURSE_ID LIKE $COURSE_ID$ AND USER_ID LIKE $USER_ID$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment