I am trying to do something quite simple, but I cannot get it to work. I just want to print out a command containing a single quotation mark, and I've been unable to find anywhere on the web that says how to do this. Books have been no help, either!
This is an example of what I am trying to do:
PRINT 'SET STATE = 'Pending', DATE = GetDate()'
This, of course, doesn't work because the second quote ends the PRINT statement. I tried using backslashes to quote it to no avail.
I'm sure it's easy to do. I just couldn't find it anywhere! Any help is appreciated. Thanks!
This is an example of what I am trying to do:
PRINT 'SET STATE = 'Pending', DATE = GetDate()'
This, of course, doesn't work because the second quote ends the PRINT statement. I tried using backslashes to quote it to no avail.
I'm sure it's easy to do. I just couldn't find it anywhere! Any help is appreciated. Thanks!