Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBARules
Starting Member
1 Post |
 Posted - 2012-02-03 : 17:07:54
|
| Hi,My table has 12K records and I just added a new column calls QUARTER into my table. I like to insert a number 1 into the QUARTER column for all of 12K records. How can I do this?Thanks. |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-02-03 : 17:10:37
|
| to update all the ROWs simple run an update:UPDATE <tableName>SET [Quarter] = 1 |
 |
|
|
|
|
|
Insert data into the entire table