<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Steve Jones
»
Updating Views
34 posts, Page 3 of 4
««
«
1
2
3
4
»»
Updating Views
Rate Topic
Display Mode
Topic Options
Author
Message
sestell1
sestell1
Posted Thursday, February 07, 2013 7:26 AM
SSC Eights!
Group: General Forum Members
Last Login: Yesterday @ 9:30 AM
Points: 830,
Visits: 1,197
Good question!
I wondered about an ALTER VIEW statement being there as well since altering the view inherently refreshes it, but then recalled that *'s aren't allowed in schema-bound objects. Nice!
Post #1417064
jagpatel9
jagpatel9
Posted Thursday, February 07, 2013 7:52 AM
Say Hey Kid
Group: General Forum Members
Last Login: Friday, March 15, 2013 3:24 PM
Points: 662,
Visits: 68
Nice 1 Steve. However, I don't recommend anyone to use SELECT * FROM in view.
Post #1417083
SQLRNNR
SQLRNNR
Posted Thursday, February 07, 2013 8:58 AM
SSCoach
Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732,
Visits: 12,329
Thanks Steve
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1417141
KWymore
KWymore
Posted Thursday, February 07, 2013 10:00 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 9:58 AM
Points: 2,570,
Visits: 1,530
Good question, thanks Steve. Definitely highlights an important point when using views.
Post #1417210
Miles Neale
Miles Neale
Posted Thursday, February 07, 2013 10:03 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 5:47 PM
Points: 1,889,
Visits: 935
Hugo Kornelis (2/7/2013)
paul s-306273 (2/7/2013)
Steve - 0 points to you for creating a view using 'select *'...
So how should Steve have made a QotD about the dangers of select * in a view without using select * ???
Good question, great discussion, and learned from both. Hugo has a point you cannot illustrate the problems and pitfalls without illustrating the problem or pitfall. Our teachers use to say "Don't ever say lookin, say looking! " And then some smarty would say "But you just said lookin, why can't we?"
Not all gray hairs are Dinosaurs!
Post #1417212
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, February 07, 2013 10:22 AM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406,
Visits: 13,722
alex.d.garland (2/7/2013)
Hugo Kornelis (2/7/2013)
paul s-306273 (2/7/2013)
Steve - 0 points to you for creating a view using 'select *'...
So how should Steve have made a QotD about the dangers of select * in a view without using select * ???
+1 - but I note that if a warning about using "SELECT *..." had been added to the explanation, this would have been even more helpful.
Fair point and added.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1417226
EL Jerry
EL Jerry
Posted Thursday, February 07, 2013 10:43 AM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, May 02, 2013 3:45 PM
Points: 3,748,
Visits: 928
Nice question, Steve. I knew the answer right away from previous posts in the forums.
By the way, I remember RBarry Young posted some code that he used to run overnight in order to rebuild all views. The code looked interesting and it made sure when a table was altered its views would be accurate next day. However, I'm unable to find the post. I will do some further search and post the link to it when I find it.
Saludos,
"El" Jerry.
"A watt of Ottawa" - Gerardo Galvan
Post #1417242
EL Jerry
EL Jerry
Posted Thursday, February 07, 2013 10:51 AM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, May 02, 2013 3:45 PM
Points: 3,748,
Visits: 928
Got it. Here it is:
http://www.sqlservercentral.com/Forums/FindPost1349883.aspx
Saludos,
"El" Jerry.
"A watt of Ottawa" - Gerardo Galvan
Post #1417249
L' Eomot Inversé
L' Eomot Inversé
Posted Thursday, February 07, 2013 1:00 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 11:59 AM
Points: 7,076,
Visits: 7,115
EL Jerry (2/7/2013)
Got it. Here it is:
http://www.sqlservercentral.com/Forums/FindPost1349883.aspx
Saludos,
That is a version with some problems (misplaced '[' and ']', misplaced 'with scheamabinding' clause, using [] on identifiers in drop but not on create) which are easily fixed. I don't know whether Barry posted a corrected version later.
It was an amazing thread - I pity the OP having to put up with a lead who bases his decisions on a vivid imagination with a strong inclination towards fiction.
Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1417325
KWymore
KWymore
Posted Thursday, February 07, 2013 1:25 PM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 9:58 AM
Points: 2,570,
Visits: 1,530
L' Eomot Inversé (2/7/2013)
[quote]
EL Jerry (2/7/2013)
Got it. Here it is:
http://www.sqlservercentral.com/Forums/FindPost1349883.aspx
Saludos,
Wow, that is a humorous thread! I am glad I don't work with that lead. Talk about misdirection...
Post #1417336
« Prev Topic
|
Next Topic »
34 posts, Page 3 of 4
««
«
1
2
3
4
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
