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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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...- johnny90
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
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...- johnny90
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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...- johnny90
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
