User Profile

Collapse

Profile Sidebar

Collapse
ymcj
ymcj
Last Activity: Mar 29 '06, 03:18 AM
Joined: Mar 27 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ymcj
    replied to column name change
    in SQL Server
    Thanks. I'm using MS SQL 2000
    How do i get that extension converted to SQL 2K?
    Not really good at MySql
    See more | Go to post

      Leave a comment:

    • ymcj
      started a topic column name change
      in SQL Server

      column name change

      Hi, I'm trying to change the column name - date to Sdate in all the tables in my database. As i have many to change so i tried to search all tables and have it change automatically rather than manually however my query doesn't seem to do the job? requesting assistance from anyone is appreciated thank you!


      DECLARE @sSQL AS VarChar(500), -- SQL Statement
      @sTableName AS VarChar(100) -- TableName

      DECLARE CursorTable...
      See more | Go to post
      • ymcj
        started a topic Column name to be changed - URGENT!!
        in General

        Column name to be changed - URGENT!!

        Hi, I'm trying to change the column name - date to Sdate in all the tables in my database. As i have many to change so i tried to search all tables and have it change automatically rather than manually however my query doesn't seem to do the job? requesting assistance from anyone is appreciated thank you!


        DECLARE @sSQL AS VarChar(500), -- SQL Statement
        @sTableName AS VarChar(100) -- TableName
        ...
        See more | Go to post
        No activity results to display
        Show More
        Working...