Forum Replies Created

Viewing 2 posts - 91 through 92 (of 92 total)

  • RE: Vertical Data To Horizontal

    THANK YOU!!! That was exactly what I was looking for!

  • RE: HOW TO ALTER /RENAME TABLE NAME WITH TSQL CODE?

    To rename a table

    Exec sp_Rename 'schema.original_table_name','new_table_name','object'

    Go

    To rename a field

    Exec sp_Rename 'schema.table_name.original_field_name','new_field_name','column'

    Go

    Note: The rule requiring [brackets] around partially invalid names (i.e. - dbo.[1_Table_Name]) should be used in the original name section...

Viewing 2 posts - 91 through 92 (of 92 total)