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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Insert data into column

Author  Topic 

rugby_fan
Starting Member

21 Posts

Posted - 2008-07-23 : 10:24:16
Hi guys,

I successfull created a new column in my database called 'Example'.

I want to populate that column with the letter 'A'.

I already have a 1000 rows in the database and now i want every row to have the letter 'A' in the Example Column.

How do I do this?

Thanks for any help.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-23 : 10:29:18
UPDATE YourTable
SET Example='A'
Go to Top of Page

rugby_fan
Starting Member

21 Posts

Posted - 2008-07-23 : 10:32:30
Thanks very much visakh16
Go to Top of Page
   

- Advertisement -