Views and changes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Views and changes

27 posts, Page 1 of 3

1 2 3 »»»

Views and changes

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Sunday, July 01, 2012 9:30 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

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

mohammed moinudheen

Posted Sunday, July 01, 2012 9:31 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582

Thank you Steve, easy start for the week Smile

Mohammed Moinudheen

Post #1323557

Koen Verbeeck

Posted Monday, July 02, 2012 1:12 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:52 AM
Points: 9,372, Visits: 6,469

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

paul s-306273

Posted Monday, July 02, 2012 1:27 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:24 AM
Points: 1,158, Visits: 642

Thanks for the QOTD Steve.

Post #1323658

Duncan Pryde

Posted Monday, July 02, 2012 1:34 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:35 AM
Points: 3,046, Visits: 1,303

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

)

Post #1323661

Gazareth

Posted Monday, July 02, 2012 2:30 AM

UDP Broadcaster

Group: General Forum Members
Last Login: 2 days ago @ 1:53 AM
Points: 1,474, Visits: 2,342

Read the question as "with schemabinding", grumble.
Serves me right for not having a coffee yet! Doze

Post #1323683

steve.casey

Posted Monday, July 02, 2012 3:32 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:26 AM
Points: 85, Visits: 80

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

Mr Quillz

Posted Monday, July 02, 2012 3:32 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 4:09 AM
Points: 60, Visits: 175

I always learn something new at SQLSeverCentral!!! Smile

Thanks guys!!!

Post #1323702

skanker

Posted Monday, July 02, 2012 4:41 AM

Say Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 1:57 AM
Points: 693, Visits: 1,022

Learnt something this morning so thanks for a good start to the week. BigGrin

Post #1323720

Bob Razumich

Posted Monday, July 02, 2012 6:13 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 7:33 PM
Points: 376, Visits: 884

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 »

27 posts, Page 1 of 3

1 2 3 »»»

Permissions