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 12»»

Creating Views - SQL School Video Expand / Collapse
Author
Message
Posted Wednesday, July 30, 2008 9:21 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
Comments posted to this topic are about the item Creating Views - SQL School Video

Brian Knight
Free SQL Server Training Webinars
Post #544039
Posted Thursday, July 31, 2008 1:38 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:30 AM
Points: 5,344, Visits: 1,388
Good one. Are we going to get more videos like this?


Post #544124
Posted Thursday, July 31, 2008 4:41 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
You'll see a few of these a week. I've already sent SSC a dozen and another 30 will be sent to them by week end. We also have loads more for free on JumpstartTV.com

Brian Knight
Free SQL Server Training Webinars
Post #544254
Posted Thursday, July 31, 2008 5:02 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, Visits: 711
Brian,
Awesome work! What tool did you use to create the video?
Post #544268
Posted Thursday, July 31, 2008 5:08 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
I use Camtasia (camtasia.com).

Brian Knight
Free SQL Server Training Webinars
Post #544274
Posted Thursday, July 31, 2008 8:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 6:07 AM
Points: 27, Visits: 73
What kind of data operation restrictions does a view have? Are they strictly for schema objects or can you create views using temp table or table memory variables?
Post #544401
Posted Thursday, July 31, 2008 10:29 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Sunday, June 29, 2014 11:44 PM
Points: 131, Visits: 801
Like it as well. As I'm just moving from SQL Server 2K to 2K5 it also helps me to see how others work with the Management Studio.
Post #544559
Posted Thursday, July 31, 2008 11:04 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:30 AM
Points: 5,344, Visits: 1,388
Brian Knight (7/31/2008)
You'll see a few of these a week. I've already sent SSC a dozen and another 30 will be sent to them by week end. We also have loads more for free on JumpstartTV.com


waooooo wonderful.....:)



Post #544582
Posted Thursday, July 31, 2008 2:20 PM


SSC Eights!

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

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 7:03 AM
Points: 913, Visits: 1,717
Thanks. Even thought I have created views before, I still learned some new tricks. I'm looking forward to other videos.

Julie
Post #544713
Posted Thursday, July 31, 2008 6:21 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 36,995, Visits: 31,516
What a great set of "mini-courses" you're in the process of having published! Nicely done!

My only question on this one would be... why would you ever teach anyone to do the Bozo-No-No of doing an ORDER BY in a view? ;)


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #544797
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse