Search
Left Quote    Nearly all men can stand adversity, but if you want to test a man's character, give him power.
- Abraham Lincoln    		 Right Quote
 
[login] | [Register]
Forum Index » General Discussion » Viewing Topic and Replies
Post Reply


        Viewing Topic: Dropping Columns in MS SQL
  This user is offline  Borio
  Subject: "Dropping Columns in MS SQL" Posted: @ 2:14 pm on May 30 2005   
Member #: 45
Rank: User - (3)
Since: 05/30/05
Posts: 3
I have to switch sveral columns type from bigint to uniqueidentifie r, so I am wondering what is the best possible way to do it. Should I just drop the bigint columns and then add the new one, or I could just drop the tables and then recreate them. Can u give me any suggestions?

    Viewed: 14,272 Times | Reply to This | To top
  This user is offline  bs0d
  Subject: "re: Dropping Columns in MS SQL" Posted: @ 4:36 pm on May 30 2005    

Member #: 1
Rank: Admin. - (1,505)
Since: 02/06/05
Posts: 600
From: USA

are you familiar with phpMyAdmin?



-bs0d | AllSyntax.com
    Viewed: 13,701 Times | Reply to This | To top
  This user is online  Guest
  Subject: "re: Dropping Columns in MS SQL" Posted: @ 2:57 am on May 30 2005    
Unregistered

i would add the new column, then switch scripts to use the new column, then drop the old column. phpmyadmin makes parts of that easier



    Viewed: 13,697 Times | Reply to This | To top
  This user is offline  misterhaan
  Subject: "re: Dropping Columns in MS SQL" Posted: @ 2:59 am on May 30 2005    

Member #: 5
Rank: User - (213)
Since: 02/11/05
Posts: 148
From: chair

oops, that was me



please note that the above post is likely made up in its entirety.
    Viewed: 13,694 Times | Reply to This | To top
  This user is offline  bs0d
  Subject: "re: haha" Posted: @ 4:54 pm on May 31 2005    

Member #: 1
Rank: Admin. - (1,505)
Since: 02/06/05
Posts: 600
From: USA

 Mister haan said...

< i>oops, that was me

lol, now I made the login to remember you!! hahaha



-bs0d | AllSyntax.com
    Viewed: 13,690 Times | Reply to This | To top
  This user is offline  misterhaan
  Subject: "re: Dropping Columns in MS SQL" Posted: @ 7:55 pm on May 31 2005    

Member #: 5
Rank: User - (213)
Since: 02/11/05
Posts: 148
From: chair

apparently you should have made the login be able to tell who i am when i've never logged in on that computer before



please note that the above post is likely made up in its entirety.
    Viewed: 13,683 Times | Reply to This | To top
  This user is offline  bs0d
  Subject: "re: Dropping Columns in MS SQL" Posted: @ 2:55 am on May 31 2005    

Member #: 1
Rank: Admin. - (1,505)
Since: 02/06/05
Posts: 600
From: USA

ahh, see I figured something like that... just giving you a hard time



-bs0d | AllSyntax.com
    Viewed: 13,679 Times | Reply to This | To top
  This user is offline  bs0d
  Subject: "re: Testing reply-to" Posted: @ 11:42 pm on Aug 01 2005    

Member #: 1
Rank: Admin. - (1,505)
Since: 02/06/05
Posts: 600
From: USA

  bs0d said...

< i>testing, one two three...


test reply to quote...



Edited at 12:42:05 am on 08/02/05

-bs0d | AllSyntax.com
    Viewed: 13,610 Times | Reply to This | To top
  This user is offline  bs0d
  Subject: "re: testing nested quote" Posted: @ 12:42 am on Aug 01 2005    

Member #: 1
Rank: Admin. - (1,505)
Since: 02/06/05
Posts: 600
From: USA

  bs0d said...

< i>   bs0d said...
[=testing, one two three...

test reply to quote...=]

testing nested quote



Edited at 02:45:30 am on 08/02/05

-bs0d | AllSyntax.com
    Viewed: 13,597 Times | Reply to This | To top
Viewing Page: 1 of 1


1 |

You must be logged in to post on the forums. Login or Register


"AllSyntax.com" Copyright © 2002-2018; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank