title: How can I use single quote inside sql command?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1586560/how-do-i-escape-a-single-quote-in-sqlserver">How do I escape a single quote in sqlserver?</a>  </p>
  </blockquote>
  
  
  
  <p>I got a script below that drop everything on the database from <a href="http://alagad.com/2008/09/18/delete-almost-everything-from-your-mssql-database/" rel="nofollow noreferrer">this link</a>. It does error when I execute on this line.</p>
  
  <pre><code>SET @statement = '
  IF(@type = 'F') or (@type = 'C') or (@type = 'D') or (@type='F') or (@type='K')
  </code></pre>
  
  <p>The reason is because the single quote. I want to know how can I fix this error?</p>
  
  <pre><code>/*** drop (pretty much) everything before rebuilding the database ***/
  DECLARE
      OBJECTS CURSOR FOR SELECT
          so.name,
          so.type,
          so.type_desc,
          p.name AS parentName
      FROM
          sys.objects AS so
      LEFT JOIN sys.objects AS p ON so.parent_object_id = p.object_id
      WHERE
          so.schema_id = 1
      ORDER BY
          CASE
      WHEN so.type = 'F' THEN
          0
      WHEN so.type = 'TR' THEN
          1
      WHEN so.type = 'U' THEN
          2
      WHEN so.type = 'F' THEN
          3
      ELSE
          4
      END OPEN OBJECTS DECLARE
          @name AS nvarchar (MAX) DECLARE
              @type AS nvarchar (2) DECLARE
                  @type_desc AS nvarchar DECLARE
                      @parentName AS nvarchar (MAX) DECLARE
                          @statement AS nvarchar (MAX) FETCH NEXT
                      FROM
                          OBJECTS INTO @name,
                          @type,
                          @type_desc,
                          @parentName
                      WHILE @@FETCH_STATUS = 0
                      BEGIN
  
                      SET @statement = '    IF(@type = ' F ')
  BEGIN
  PRINT ' DROPING FK : ' + @name + ' OF type ' + @type + ' (' + @type_desc + ') '
  SET @statement = ' ALTER TABLE ' + @parentName + ' DROP CONSTRAINT ' + @name
  EXECUTE(@statement)
  END
  ELSE IF (@type = ' TR ')
  BEGIN
  PRINT ' DROPING TRIGGER : ' + @name + ' OF type ' + @type + ' (' + @type_desc + ') '
  SET @statement = ' DROP TRIGGER ' + @name
  EXECUTE(@statement)
  END
  ELSE IF (@type = ' U ')
  BEGIN
  PRINT ' DROPING TABLE : ' + @name + ' OF type ' + @type + ' (' + @type_desc + ') '
  SET @statement = ' DROP TABLE ' + @name
  EXECUTE(@statement)
  END
  ELSE IF (@type = ' FN ')
  BEGIN
  PRINT ' DROPING FUNCTION : ' + @name + ' OF type ' + @type + ' (' + @type_desc + ') '
  SET @statement = ' DROP FUNCTION ' + @name
  EXECUTE(@statement)
  END
  ELSE
  PRINT ' Didn 't drop object ' + @name + ' of type ' + @type + ' (' + @type_desc + ')'    FETCH NEXT
                      FROM
                          OBJECTS INTO @name,
                          @type,
                          @type_desc,
                          @parentName
                      END CLOSE OBJECTS DEALLOCATE OBJECTS
  </code></pre>