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 @ 7:43 PM
Points: 33,046, Visits: 15,152
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: Yesterday @ 9:02 PM
Points: 2,268, Visits: 3,776
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: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
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: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
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, July 17, 2014 4:47 AM
Points: 3,352, Visits: 1,480
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:38 AM
Points: 1,853, Visits: 2,961
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, May 6, 2014 4:06 AM
Points: 142, Visits: 95
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, July 15, 2014 7:54 AM
Points: 60, Visits: 201
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 @ 3:08 AM
Points: 878, Visits: 1,218
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: Yesterday @ 5:54 AM
Points: 419, Visits: 976
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