Views and changes

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

  • Thank you Steve, easy start for the week 🙂

    M&M

  • 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

  • Thanks for the QOTD Steve.

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

  • Read the question as "with schemabinding", grumble.

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

  • 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.

  • I always learn something new at SQLSeverCentral!!! 🙂

    Thanks guys!!!

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

  • 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.

  • 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

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



    Everything is awesome!

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

  • 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

  • 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]

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

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