CSTrüter HomeArticlesDownloadsAbout meContact me
How to enable the filestream feature in SQL 2008 - Alternative way to store blobs(files) via SQL 2010-08-21 19:31:56
How to create a Singleton Pattern in C# 2010-08-10 22:52:52
How to prevent that threads access shared resources concurrently via Monitor. 2010-08-06 15:31:15
A quick review of the book PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide written by Larry Ullman 2010-08-04 21:48:58
How to prevent that threads access shared resources concurrently via Mutex. 2010-08-03 14:42:36
How to stop propagation of javascript events 2010-07-25 21:59:29
Post about how Pete the web developer fixed his sitemap 2010-07-17 15:12:02
How to setup an out of process session service 2010-07-08 17:51:46
How to display/add images from/to a SQL Database 2010-07-04 23:15:15
How to register a custom URL protocol handler 2010-06-28 20:34:01
Creating a WYSIWYG textbox for your website is actually quite simple. 2007-02-01 12:00:00
Move items between two listboxes in ASP.net(C#, VB.NET) and PHP 2008-06-12 17:07:43
Firefox word wrapping issues 2008-06-09 09:51:21
Populate a TreeView control in a windows application. 2009-08-27 16:01:03
2007-02-22 12:00:00
There are three categories joins fall into, inner, outer and cross. Outer joins consist of three types, left, right and full. Lets have a quick look at the various joins. (On the right we've got two datasets we'll be using in the examples.) Table a aID title 1 a1 2 a2 3 a3 4 a4 Table b bID title aID 1 b1 1 2 b2 2 3 b3 NULL 4 b4 NULL Inner Join Return rows that match in both tables. (Default join) SELECT * FROM a INNER JOIN b ON a.aid = b.aid title aID a1 1 a2 2 aID bID title 1 1 b1 2 2 b2 Left Outer Join Return rows from the table on the left of the expression even if they dont match with the table on the right. SELECT * FROM a LEFT OUTER JOIN b ON a.aid = b.aid title aID a1 1 a2 2 a3 3 a4 4 aID bID title 1 1 b1 2 2 b2 NULL NULL NULL NULL NULL NULL Right Outer Join Return rows from the table on the right of the expression even if they dont match with the table on the left. SELECT * FROM a RIGHT OUTER JOIN b ON a.aid = b.aid title aID a1 1 a2 2 NULL NULL NULL NULL aID bID title 1 1 b1 2 2 b2 3 3 b3 4 4 b4 Full Outer Join Return rows from both the left and right tables even if they don't match in either. (left + right join) SELECT * FROM a FULL OUTER JOIN b ON a.aid = b.aid title aID a1 1 a2 2 a3 3 a4 4 NULL NULL NULL NULL aID bID title 1 1 b1 2 2 b2 NULL NULL NULL NULL NULL NULL 3 3 b3 4 4 b4 Cross Join Join each row from the left with each row from the right. Known as a "carthesian product" SELECT * FROM a CROSS JOIN b or SELECT * FROM a, b title aID a1 1 a2 2 a3 3 a4 4 a1 1 a2 2 a3 3 a4 4 a1 1 a2 2 a3 3 a4 4 a1 1 a2 2 a3 3 a4 4 aID bID title 1 1 b1 1 1 b1 1 1 b1 1 1 b1 2 2 b2 2 2 b2 2 2 b2 2 2 b2 3 3 b3 3 3 b3 3 3 b3 3 3 b3 4 4 b4 4 4 b4 4 4 b4 4 4 b4
The company I am currently working for as software developer.
Collection of C# snippets 2010-05-22 01:06:19
Collection of MS SQL snippets 2010-05-22 00:55:15
Collection of JavaScript snippets 2010-05-22 00:37:57
Collection of ASP.net snippets 2010-05-22 00:29:56
Collection of PHP snippets 2010-05-22 00:06:45
a Parallel reference of programming languages 2009-09-10 12:48:23
a tutorial explaining how to develop a simple login using PHP and MySQL 2009-09-05 18:26:47
An article looking at adding some kind of event driven model to PHP 5 2008-07-28 12:48:09
It is very simple creating your own rss reader, the following article looks at a few methods of doing this. 2008-06-23 13:18:25
A quick reference about working with dropdown boxes (select element) in javascript. 2007-02-17 16:36:41
Collection of funny programming articles 2006-10-08 14:23:43