Views and changes

Question

Post reply

Views and changes

Steve Jones - SSC Editor

SSC Guru

Points: 736255
More actions
July 1, 2012 at 9:30 am

#74322

Comments posted to this topic are about the item Views and changes

Viewing 15 posts - 1 through 15 (of 26 total)

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

M&M SSC-Insane Points: 21700 More actions · Answer 1

Thank you Steve, easy start for the week 🙂

M&M

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

Easy one for a Monday, thanks Steve!

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

paul s-306273 SSChampion Points: 10730 More actions · Answer 3

paul s-306273

SSChampion

Points: 10730

July 2, 2012 at 1:27 am

#1507623

Thanks for the QOTD Steve.

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 4

Good question - made me think for a bit (I never use SELECT * in views, of course 😉 )

Gazareth One Orange Chip Points: 27737 More actions · Answer 5

Read the question as "with schemabinding", grumble.

Serves me right for not having a coffee yet! :doze:

steve.casey Old Hand Points: 311 More actions · Answer 6

Some of us have to work with versions older than SS 2005, you know! DROP...CREATE is the only one that will work with ALL versions.

Mr Quillz Old Hand Points: 301 More actions · Answer 7

I always learn something new at SQLSeverCentral!!! 🙂

Thanks guys!!!

Skanker Hall of Fame Points: 3059 More actions · Answer 8

Learnt something this morning so thanks for a good start to the week.:-D

Bob Razumich SSCrazy Points: 2143 More actions · Answer 9

For a moment, I thought the correct answer was a trick answer. "sp_refreshview"? It just seemed too cute for a Monday, but I looked it up first, anyway. Plus, I'd be strung up if I created a view as Select * from anything. Glad I researched it.

But I have to say that the command would seem to enable poor coding practice in creating a view, IMHO.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 10

Bob Razumich (7/2/2012)
For a moment, I thought the correct answer was a trick answer. "sp_refreshview"? It just seemed too cute for a Monday, but I looked it up first, anyway. Plus, I'd be strung up if I created a view as Select * from anything. Glad I researched it.
But I have to say that the command would seem to enable poor coding practice in creating a view, IMHO.

It's like Bob was reading my mind! (Except for the fact that he wrote this BEFORE I saw the question. How DO you do that Bob?)

So, +1, and thanks for a great question for a Monday Steve.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Dana Medley SSCertifiable Points: 6764 More actions · Answer 11

Great easy question this morning Steve. Thanks for that pick me up on Monday. 🙂

Everything is awesome!

Ken SSCoach Points: 17191 More actions · Answer 12

Thanks for the easy one Steve! I think I have used this command maybe once before.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

EZ PZ

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

mtassin SSC-Insane Points: 23099 More actions · Answer 14

steve.casey (7/2/2012)
Some of us have to work with versions older than SS 2005, you know! DROP...CREATE is the only one that will work with ALL versions.

That's what I thought too... of course I don't write many views.... tables yes... stored procs yes...... views.... rarely.

That said, I had to find out what the heck sp_refreshview was if it existed... and it changed my answer. 🙂

Yay +1

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]