Updating the View or the table?

Question

Post reply

Updating the View or the table?

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
August 5, 2016 at 12:16 am

#74452

Comments posted to this topic are about the item Updating the View or the table?
August 5, 2016 at 4:50 am

This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

BillLudlow SSCertifiable Points: 6553 More actions · Answer 1

Easy one for the end of the week. I was looking for the gotcha but there wasn't one

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

I also appreciate an easy one to end the week. Since this was the first week after vacation, it was a long one.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

Almost missed the fact that firstname wasn't part of the view. It's a good thing I double checked.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Kaye Cahs SSCarpal Tunnel Points: 4135 More actions · Answer 4

Luis Cazares (8/5/2016)
Almost missed the fact that firstname wasn't part of the view. It's a good thing I double checked.

Same here. It's a good thing I test, especially before my second cup of coffee.

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Revenant

SSC-Forever

Points: 42467

August 5, 2016 at 1:03 pm

#1894149

Thanks, Steve, and have a great weekend!

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

H Laforest SSC Rookie Points: 33 More actions · Answer 7

But there is no data in the table. There is at that point to EmpID = 2 or 1 for that matter

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 8

H Laforest (9/20/2016)
But there is no data in the table. There is at that point to EmpID = 2 or 1 for that matter

Why would you assume no data? That is not mentioned.

Sean Lange SSC Guru Points: 286590 More actions · Answer 9

H Laforest (9/20/2016)
But there is no data in the table. There is at that point to EmpID = 2 or 1 for that matter

The presence of data makes no difference here whatsoever. With a completely empty table you will get the same error. It can't update because the column doesn't exist in the view.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/