sarin s

sarin s

  • NA
  • 18
  • 17.4k

How to append data to datatable column directly

Sep 11 2012 6:49 AM
My MS SQL database Info table contains 2 columns

Id       Info
1        Raj,30
2        Mac,28
3        John,32

Now i want to update my Info table as

Id       Info
1        Raj,30,Black
2        Mac,28,Yellow
3        John,32,Green

So the question is,
Is there any direct method (sql queries / statements) by which i can append black , yellow etc to Info column?

Answers (1)