I have a table and it has a two column. I want to add those two columns and put it in to third column Total. This is can we do this by using "CREATE VIEW" Method instead spf or normal update?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
yes. You can create a view for this.
create view NewView
select col1, col2, Total = col1 + col2
This sounds like a bad idea in progress.
Have you considered just adding a calculated column to the underlying table?
if you want to update the total column of the same table,
set total = col1 + col2
if total is always a sum of col1 and col2, you should seriously consider John's suggestion of using a computed column
No one has followed this question yet.
Compare rows inside the same results of the table data.
I need the workflow process for staging, development and Production database
difference between sql server 2008 r2 standard edition and enterprise edition
best methodology for error handling in sql server2008
Insert operation pause while fetch data.