EXEC does not require quotation marks?

• miklushka

  SSC Veteran

  Points: 218

  More actions

  September 24, 2014 at 6:38 am

  #73575

  What will be output for this query:

  CREATE PROC MyProc_p

  (@param VARCHAR(30))

  AS

  SELECT @param AS Passed_param

  GO

  EXEC MyProc_p test_string

  GO

  EXEC MyProc_p 'test_string'

  GO

  EXEC MyProc_p test string

  GO

  EXEC MyProc_p 'test string'

  GO

  EXEC MyProc_p [test string]

  GO

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  September 24, 2014 at 8:48 am

  #1747866

  Why don't you try it on SSMS?

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2