Loading ...
Sorry, an error occurred while loading the content.
 

Re: [SQLQueriesNoCode] ALL CAP db conversion

Expand Messages
  • Razvan Socol
    I m assuming that you use SQL Server 2000: EXEC sp_execresultset SELECT UPDATE +QUOTENAME(o.name)+ SET
    Message 1 of 2 , Jan 31, 2005
      I'm assuming that you use SQL Server 2000:
       
      EXEC sp_execresultset '
      SELECT ''UPDATE ''+QUOTENAME(o.name)+'' SET ''+QUOTENAME(c.name)+''=UPPER(''+QUOTENAME(c.name)+'')''
      FROM sysobjects o INNER JOIN syscolumns c ON o.id=c.id
      WHERE o.xtype=''U'' AND OBJECTPROPERTY(o.id,''IsMSShipped'')=0
      AND c.xtype IN (35, 99, 167, 175, 231, 239)
      '

      Razvan
      ----- Original Message -----
      From: Jeff
      Sent: Monday, January 31, 2005 11:03 PM
      Subject: [SQLQueriesNoCode] ALL CAP db conversion



      Hello all,

      Does anybody know, off hand, the query to update all alpha data in a
      db to all caps?

      Thank you in advance,

      Jeff
    Your message has been successfully submitted and would be delivered to recipients shortly.