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!