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 @ 8:45 PM
Points: 31,992, Visits: 16,428
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, May 13, 2015 2:56 PM
Points: 2,287, Visits: 3,829
Thank you Steve, easy start for the week

M&M
Post #1323557
Posted Monday, July 2, 2012 1:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:42 AM
Points: 14,371, Visits: 12,347
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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 8:41 AM
Points: 1,435, Visits: 820
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: Thursday, May 21, 2015 8:48 AM
Points: 3,352, Visits: 1,502
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: Today @ 8:04 AM
Points: 2,307, Visits: 4,220
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: Wednesday, April 22, 2015 4:10 AM
Points: 158, Visits: 101
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: Friday, May 22, 2015 5:22 AM
Points: 60, Visits: 234
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: Tuesday, May 26, 2015 6:40 AM
Points: 967, Visits: 1,382
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: Wednesday, May 13, 2015 6:07 AM
Points: 433, Visits: 1,009
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