ADD A COLUMN OF ZEROS TO TABLE SQL SERVER

Chintoo Semi

Total Post:135

Points:947
Posted by  Chintoo Semi
C# 
C#
 912  View(s)
Ratings:
Rate this:
Hi Everyone!

I have a table in sql server, but want to add a extra column full of zeros

What would be the best approach to do this

att1 att2
---------
1.0   5.8
2.7   3.8
5.1   6.8
becomes

att1 att2  extra
----------------
1.0   5.8   0.0
2.7   3.8   0.0
5.1   6.8   0.0


Thanks in advance!
  1. AVADHESH PATEL

    Post:604

    Points:4228
    Re: Add a column of zeros to table sql server

    Hi Chintoo!


    you can try as following approach 

    ALTER TABLE {TABLENAME} 
    ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} 
    CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}

    I hope it resolve your problem!

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!