Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Views and changes Expand / Collapse
Author
Message
Posted Sunday, July 1, 2012 9:30 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:58 PM
Points: 31,567, Visits: 16,005
Comments posted to this topic are about the item Views and changes






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1323556
Posted Sunday, July 1, 2012 9:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, January 7, 2015 6:35 PM
Points: 2,285, Visits: 3,810
Thank you Steve, easy start for the week

Mohammed Moinudheen
Post #1323557
Posted Monday, July 2, 2012 1:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:06 AM
Points: 13,901, Visits: 11,809
Easy one for a Monday, thanks Steve!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1323653
Posted Monday, July 2, 2012 1:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 14, 2015 8:57 AM
Points: 1,428, Visits: 811
Thanks for the QOTD Steve.
Post #1323658
Posted Monday, July 2, 2012 1:34 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, January 14, 2015 5:40 AM
Points: 3,352, Visits: 1,495
Good question - made me think for a bit (I never use SELECT * in views, of course )
Post #1323661
Posted Monday, July 2, 2012 2:30 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:54 AM
Points: 2,189, Visits: 3,882
Read the question as "with schemabinding", grumble.
Serves me right for not having a coffee yet!
Post #1323683
Posted Monday, July 2, 2012 3:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 6, 2015 1:41 AM
Points: 147, Visits: 98
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.
Post #1323701
Posted Monday, July 2, 2012 3:32 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 20, 2015 11:32 PM
Points: 60, Visits: 225
I always learn something new at SQLSeverCentral!!!

Thanks guys!!!
Post #1323702
Posted Monday, July 2, 2012 4:41 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:16 AM
Points: 942, Visits: 1,331
Learnt something this morning so thanks for a good start to the week.
Post #1323720
Posted Monday, July 2, 2012 6:13 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 23, 2015 8:41 PM
Points: 430, Visits: 999
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.
Post #1323750
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse