Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. johnny90

    SQL is filling up my hard disk up, need help

    Hi everyone I am a newbie in sql statement, and I am trying to extract data from a sql database in sql 2000. when i try to excute the sql code below it completely drains my hard drive from 80 gb to 0 and the i never could extract the data at all. Can anyone help me out please, i am competely...
  2. johnny90

    minor hippcup on the alter table statement

    Thanks for that code but i forgot to tell you that there is already a default value of (null) which need to be changed to ('undefined'). Therefore the code you gave didn't work. It came up with this error Server: Msg 1781, Level 16, State 1, Line 1 Column already has a DEFAULT bound to it...
  3. johnny90

    minor hippcup on the alter table statement

    Hi all I was try to do the following things but i am getting a syntax error in the sql analyster of the sql server 2000 Case: Alter the “rm” table. Change the default value for the “dp_abbr” field to (‘Undefined’). ************************************ Code is: ALTER TABLE rm ALTER COLUMN...

Part and Inventory Search

Back
Top