How to append data to datatable column directly
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?