Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: change old schema name into new schema name

    Try this:

    /* Schema fix all tables.sql

    By: MJW 02/05/2010

    Desc: change all tables from one schema to another

    */

    declare @sql varchar(8000), @table varchar(1000), @oldschema varchar(1000), @newschema varchar(1000)

    set @oldschema = 'dbo'

    set @newschema...

  • RE: New line help

    Not sure what you mean by 'within the cell in the result row' but you can use the char() function to insert formatting codes into any string.

    New code:

    BEGIN

    DECLARE @Return VARCHAR(8000)

    SELECT...

Viewing 2 posts - 1 through 2 (of 2 total)