Problem Transact-SQL Statement

From: Allen Yu (allenyu_at_netvigator.com)
Date: 01/06/05

  • Next message: Tom Moreau: "Re: Problem Transact-SQL Statement" 
    Date: Fri, 7 Jan 2005 00:53:00 +0800

    I've come across a Transact-SQL statement as follows:

    -- Statements start here

    select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from
    sysobjects where type = 'U'

    -- end here

    Questions:

    (1) How should the 'select' statement be interpreted?

    (2) What are the rules for using the quotation marks: ''', '',,, etc?

    Thanks!

    Allen

  • Next message: Tom Moreau: "Re: Problem Transact-SQL Statement"