<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-3380626904031146591</id><updated>2011-11-04T12:29:45.164-07:00</updated><category term='Java-Video-Tutorials'/><category term='Insertion-Sort-In-Java'/><category term='Multi-dimensional-arrays'/><category term='Java-Array-Usage'/><category term='23-Compound-Interest-Program'/><category term='Structure-of-Java-Arrays'/><category term='hashCode()'/><category term='FileWriter'/><category term='toUpperCase()'/><category term='Heap-Sort-in-Java'/><category term='How-to-use-this-keyword-in-java'/><category term='SCJP-Paper-Notes'/><category term='SCJP-Notes-Chapter-2'/><category term='Array to Collection'/><category term='SCJP-Notes-Chapter-8'/><category term='11-Logical-Operators'/><category term='Multiplication-of-two-Matrix'/><category term='Checking-whether-a-year-is-leap-or-not'/><category term='3-Arrays-and-Strings'/><category term='Trim()'/><category term='isEmpty()'/><category term='SCJP-Notes-Chapter-1'/><category term='Comparing-Two-Numbers'/><category term='indexOf()'/><category term='19-else-if-Statement'/><category term='Array()'/><category term='14-Using-Multiple-Classes'/><category term='concat()'/><category term='Selection-Sort-In-Java'/><category term='Palindrome-Number-Example-in-Java'/><category term='SCJP-Notes-Chapter-7'/><category term='contains()'/><category term='calculate-area-and-perimeter-of-a-circle'/><category term='valueOf()'/><category term='SCJP-Notes-Chapter-6-Part-1'/><category term='17-Constructors'/><category term='construct-a-triangle-with-the-?*?'/><category term='Java-Array-Initialization'/><category term='28-Creating-an-Array-Table'/><category term='Fibonacci-Series'/><category term='13-While-Loop-Statements'/><category term='24-do-while-Loops'/><category term='ArrayList()'/><category term='equals()'/><category term='Find-out-the-prime-number'/><category term='CopyingArrays-arraycopy()'/><category term='Two-dimensional-arrays'/><category term='Java-Array-Declaration'/><category term='substring()'/><category term='SQL-Program-Chapter-1'/><category term='matches()'/><category term='21-Simple-Averaging-Program'/><category term='SCJP-Notes-Chapter-6-Part-3'/><category term='lastIndexOf()'/><category term='Odd-Even-Transposition-Sort-In-Java'/><category term='length()'/><category term='SCJP-Notes-Chapter-5'/><category term='startsWith()'/><category term='20-Conditional-Operators'/><category term='FileReader'/><category term='Quick-Sort-In-Java'/><category term='Calendar-Example'/><category term='26-Random-Number-Generator'/><category term='Simple-java-program'/><category term='27-Introduction-to-Arrays'/><category term='30-Array-Elements-as-Counters'/><category term='06-Getting-User-Input'/><category term='calculating-area-and-perimeter-of-a-rectangle'/><category term='toLowerCase()'/><category term='07.Building-a-Basic-Calculator'/><category term='Write-a-program-to-list-all-even-numbers-between-two-numbers'/><category term='Extra-Storage-Merge-Sort-in-Java'/><category term='25-Math-Class-Methods'/><category term='Beginners-Java-Tutorials-Installing-JDK'/><category term='Sum-of-two-Matrix'/><category term='SCJP-Notes-Chapter-6-Part-2'/><category term='5-Classes-and-Methods'/><category term='SCJP-Notes-Chapter-4'/><category term='Bubble-Sorting-in-Java'/><category term='12-Switch-Statement'/><category term='16-Many-Methods-and-Instances'/><category term='08-Math-Operators'/><category term='What-is-instance-variable?'/><category term='01-Installing-the-JDK'/><category term='18-Nested-if-Statements'/><category term='Inheritance'/><category term='ByteArrayOutputStream'/><category term='4-Conditionals-and-Loops'/><category term='1-Introduction-to-Java'/><category term='04-Hello-YouTube'/><category term='Matrix-Example-in-Java'/><category term='10-If-Statement'/><category term='Triangle-Printing'/><category term='SQL-Program-Chapter-2-S'/><category term='toCharArray()'/><category term='Preparing-table-of-a-number-by-using-loop'/><category term='Accending-Order-using-Array'/><category term='03-Downloading-Eclipse'/><category term='Prime-Number-in-Java'/><category term='Listing-out-leap-years-between-certain-period'/><category term='2-Java-Variables'/><category term='charAt()'/><category term='22-for-Loops'/><category term='equalsIgnoreCase()'/><category term='09-Increment-Operators'/><category term='15-Use-Methods-with-Parameters'/><category term='02-Running-a-Java-Program'/><category term='Determining-the-largest-number'/><category term='Bidirectional-Bubble-Sort-in-Java'/><category term='SQL-Program-Chapter-1-Part-1'/><category term='05-Variables'/><category term='Odd-and-Even-Numbers-Logics'/><category term='Merge-Sort-In-Java'/><category term='SCJP-Notes-Chapter-3'/><category term='Math-class-in-Java-Functions'/><category term='calculate-factorial-of-any-given-number'/><category term='SQL-Tips-and-Techniques'/><category term='29-Summing-Elements-of-Arrays'/><category term='SCJP-Notes-Chapter-6-Part-4'/><title type='text'>Java &amp; SQL Tutorials</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default?start-index=101&amp;max-results=100'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>250</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-65585045014278558</id><published>2010-03-08T01:02:00.000-08:00</published><updated>2010-03-08T01:31:35.663-08:00</updated><title type='text'>Introduction to Threads</title><summary type='text'>Introduction to Threads Multithreading refers to two or more tasks executing concurrently within a single program. A thread is an independent path of execution within a program. Many threads can run concurrently within a program. Every thread in Java is created and controlled by the java.lang.Thread class. A Java program can have many threads, and these threads can run concurrently, either </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/65585045014278558/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/introduction-to-threads.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/65585045014278558'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/65585045014278558'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/introduction-to-threads.html' title='Introduction to Threads'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6262233902958277395</id><published>2010-03-04T04:46:00.001-08:00</published><updated>2010-03-04T04:46:45.227-08:00</updated><title type='text'>Advance Methods Program in Java</title><summary type='text'> Array()  charAt()  concat()  contains()  CopyingArrays-arraycopy()  equals()  equalsIgnoreCase()  hashCode()  indexOf()  isEmpty()  lastIndexOf()  length()  matches()  Math-class-in-Java-Functions  startsWith()  substring()  toCharArray()  toLowerCase()  toUpperCase()  Trim()  valueOf() </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6262233902958277395/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/advance-methods-program-in-java.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6262233902958277395'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6262233902958277395'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/advance-methods-program-in-java.html' title='Advance Methods Program in Java'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6829500882854445269</id><published>2010-03-04T04:45:00.001-08:00</published><updated>2010-03-04T04:45:54.190-08:00</updated><title type='text'>Java Theory Class</title><summary type='text'> 1-Introduction-to-Java  2-Java-Variables  3-Arrays-and-Strings  4-Conditionals-and-Loops  5-Classes-and-Methods  Beginners-Java-Tutorials-Installing-JDK  How-to-use-this-keyword-in-java  Java-Array-Declaration  Java-Array-Initialization  Java-Array-Usage  Matrix-Example-in-Java  Multi-dimensional-arrays  Structure-of-Java-Arrays  Two-dimensional-arrays  What-is-instance-variable? </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6829500882854445269/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/java-theory-class.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6829500882854445269'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6829500882854445269'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/java-theory-class.html' title='Java Theory Class'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8031281441330154134</id><published>2010-03-04T04:44:00.002-08:00</published><updated>2010-03-04T04:45:27.529-08:00</updated><title type='text'>Java Programming Video Tutorials</title><summary type='text'> 01-Installing-the-JDK  02-Running-a-Java-Program  03-Downloading-Eclipse  04-Hello-YouTube  05-Variables  06-Getting-User-Input  07.Building-a-Basic-Calculator  08-Math-Operators  09-Increment-Operators  10-If-Statement  11-Logical-Operators  12-Switch-Statement  13-While-Loop-Statements  14-Using-Multiple-Classes  15-Use-Methods-with-Parameters  16-Many-Methods-and-Instances  17-Constructors  </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8031281441330154134/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/java-programming-video-tutorials.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8031281441330154134'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8031281441330154134'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/java-programming-video-tutorials.html' title='Java Programming Video Tutorials'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-2644578394591885058</id><published>2010-03-04T04:44:00.001-08:00</published><updated>2010-03-04T04:44:47.340-08:00</updated><title type='text'>Java Practical Program</title><summary type='text'> Accending-Order-using-Array  Bidirectional-Bubble-Sort-in-Java  Bubble-Sorting-in-Java  calculate-area-and-perimeter-of-a-circle  calculate-factorial-of-any-given-number  calculating-area-and-perimeter-of-a-rectangle  Calendar-Example  Checking-whether-a-year-is-leap-or-not  Comparing-Two-Numbers  construct-a-triangle-with-the-?*?  Determining-the-largest-number  Extra-Storage-Merge-Sort-in-Java</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/2644578394591885058/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/java-practical-program.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2644578394591885058'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2644578394591885058'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/java-practical-program.html' title='Java Practical Program'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4026619412628496212</id><published>2010-03-04T04:39:00.000-08:00</published><updated>2010-03-04T04:40:45.130-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Paper-Notes'/><title type='text'>SCJP Paper Notes</title><summary type='text'>SCJP Notes Chapter 1SCJP Notes Chapter 2SCJP Notes Chapter 3SCJP Notes Chapter 4SCJP Notes Chapter 5SCJP Notes Chapter 6 - Part 1SCJP Notes Chapter 6 - Part 2SCJP Notes Chapter 6 - Part 3SCJP Notes Chapter 6 - Part 4SCJP Notes Chapter 7SCJP Notes - Chapter 8</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4026619412628496212/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-paper-notes.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4026619412628496212'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4026619412628496212'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-paper-notes.html' title='SCJP Paper Notes'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5822622416244531601</id><published>2010-03-04T04:38:00.000-08:00</published><updated>2010-03-04T04:39:09.913-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Notes-Chapter-1'/><title type='text'>SCJP Notes Chapter 1</title><summary type='text'>Chapter 1: Language FundamentalsThe Java programming language has includes five simple arithmetic operators like are + (addition), - (subtraction), * (multiplication), / (division), and % (modulo). The following table summarizes them:. Source file's elements (in order) Package declarationImport statementsClass definitions2. Importing packages doesn't recursively import sub-packages.3. </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5822622416244531601/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-1.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5822622416244531601'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5822622416244531601'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-1.html' title='SCJP Notes Chapter 1'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6278330718446877187</id><published>2010-03-04T04:35:00.000-08:00</published><updated>2010-03-04T04:37:57.157-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Notes-Chapter-2'/><title type='text'>SCJP Notes Chapter 2</title><summary type='text'>Chapter 2 Operators and assignmentsThe Java programming language has included five simple arithmetic operators like + (addition), - (subtraction), * (multiplication), / (division)1. Unary operators 1.1 Increment and Decrement operators ++ -- We have postfix and prefix notation. In post-fix notation value of the variable/expression is modified after the value is taken for the execution of </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6278330718446877187/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-2.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6278330718446877187'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6278330718446877187'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-2.html' title='SCJP Notes Chapter 2'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5402266570062083614</id><published>2010-03-04T04:34:00.000-08:00</published><updated>2010-03-04T04:35:29.376-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Notes-Chapter-3'/><title type='text'>SCJP Notes Chapter 3</title><summary type='text'>Chapter 3 -  Modifiers       1.              Modifiers are Java keywords that provide information to compiler       about the nature of the code, data and classes.       2.              Access modifiers - public, protected, private       ·               Only applied to class level variables. Method variables are       visible only inside the method.       ·               Can be applied to class </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5402266570062083614/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-3.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5402266570062083614'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5402266570062083614'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-3.html' title='SCJP Notes Chapter 3'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8376070479564566968</id><published>2010-03-04T04:33:00.002-08:00</published><updated>2010-03-04T04:34:32.954-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Notes-Chapter-4'/><title type='text'>SCJP Notes Chapter 4</title><summary type='text'>Chapter 4 Converting and Casting       Unary Numeric Promotion       Contexts:       ·               Operand of the unary arithmetic operators + and -       ·               Operand of the unary integer bit-wise complement operator ~       ·               During array creation, for example new int[x], where the       dimension expression x must evaluate to an int value.       ·               </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8376070479564566968/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-4.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8376070479564566968'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8376070479564566968'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-4.html' title='SCJP Notes Chapter 4'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4008775633838491419</id><published>2010-03-04T04:33:00.001-08:00</published><updated>2010-03-04T04:33:36.508-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Notes-Chapter-5'/><title type='text'>SCJP Notes Chapter 5</title><summary type='text'>Chapter 5 Flow Control and Exceptions          Unreachable statements produce a compile-time error.       while (false) { x = 3; } //       won't compile       for (;false;) { x =3; } //       won't compile       if (false) {x = 3; } // will       compile, to provide the ability to conditionally compile the code.       ·               Local variables already declared in an enclosing block, </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4008775633838491419/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-5.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4008775633838491419'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4008775633838491419'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-5.html' title='SCJP Notes Chapter 5'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6655137375047163917</id><published>2010-03-04T04:32:00.001-08:00</published><updated>2010-03-04T04:32:59.003-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Notes-Chapter-6-Part-1'/><title type='text'>SCJP Notes Chapter 6 - Part 1</title><summary type='text'>Chapter 6 - Objects and Classes  (Part 1)Implementing OO relationships ·               "is a" relationship is implemented by inheritance       (extends keyword)       ·               "has a" relationship is implemented by providing the       class with member variables.                     Overloading and Overriding       ·               Overloading is an example of polymorphism. (operational /</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6655137375047163917/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-6-part-1.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6655137375047163917'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6655137375047163917'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-6-part-1.html' title='SCJP Notes Chapter 6 - Part 1'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-2026203137330983521</id><published>2010-03-04T04:31:00.000-08:00</published><updated>2010-03-04T04:32:14.650-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Notes-Chapter-6-Part-2'/><title type='text'>SCJP Notes Chapter 6 - Part 2</title><summary type='text'>Chapter 6 - Objects and Classes  (Part 2)Constructors and Sub-classing·               Constructors are not inherited as normal methods, they have to be defined in the class itself. ·               If you define no constructors at all, then the compiler provides a default constructor with no arguments. Even       if, you define one constructor, this default is not provided.       ·               </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/2026203137330983521/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-6-part-2.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2026203137330983521'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2026203137330983521'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-6-part-2.html' title='SCJP Notes Chapter 6 - Part 2'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-379835135339702052</id><published>2010-03-04T04:30:00.000-08:00</published><updated>2010-03-04T04:31:16.434-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Notes-Chapter-6-Part-3'/><title type='text'>SCJP Notes Chapter 6 - Part 3</title><summary type='text'>Interfaces: ·               All methods in an       interface are implicitly public, abstract, and never static.       ·               All variables in an interface       are implicitly static, public, final. They cannot be transient or       volatile. A class can shadow the variables it inherits from an interface,       with its own variables.       ·               A top-level interface itself </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/379835135339702052/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-6-part-3.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/379835135339702052'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/379835135339702052'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-6-part-3.html' title='SCJP Notes Chapter 6 - Part 3'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4599720002314460753</id><published>2010-03-04T04:29:00.000-08:00</published><updated>2010-03-04T04:30:29.975-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Notes-Chapter-6-Part-4'/><title type='text'>SCJP Notes Chapter 6 - Part 4</title><summary type='text'>Chapter 6 - Objects and Classes  (Part 4)// Example 1                     public class InnerInnerTest {                       public static void main(String s[]) {                             new Outer().new Inner().new       InnerInner().new InnerInnerInner().doSomething();                             new Outer().new       InnerChild().doSomething();                             new Outer2().new</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4599720002314460753/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-6-part-4.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4599720002314460753'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4599720002314460753'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-6-part-4.html' title='SCJP Notes Chapter 6 - Part 4'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5415843628194842658</id><published>2010-03-04T04:28:00.000-08:00</published><updated>2010-03-04T04:29:10.931-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Notes-Chapter-7'/><title type='text'>SCJP Notes Chapter 7</title><summary type='text'>Chapter 7 Threads                 ·                         Java is fundamentally multi-threaded.                 ·                         Every thread corresponds to an instance of java.lang.Thread class or a sub-class.                 ·                         A thread becomes eligible to run, when its start() method is called. Thread scheduler                 co-ordinates between the threads </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5415843628194842658/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-7.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5415843628194842658'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5415843628194842658'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-7.html' title='SCJP Notes Chapter 7'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6773282020222794765</id><published>2010-03-04T04:20:00.000-08:00</published><updated>2010-03-04T04:27:39.494-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SCJP-Notes-Chapter-8'/><title type='text'>SCJP Notes - Chapter 8</title><summary type='text'>       Locks, Monitors and Synchronization                                                                                     ·                         Every object has a lock (for every synchronized code block). At any                 moment, this lock is controlled by at most one thread.                                                   ·                         A thread that wants to execute </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6773282020222794765/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-8.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6773282020222794765'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6773282020222794765'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/scjp-notes-chapter-8.html' title='SCJP Notes - Chapter 8'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6596651696206105707</id><published>2010-03-03T04:44:00.000-08:00</published><updated>2010-03-03T04:45:43.527-08:00</updated><title type='text'>Understanding the CASCADE and RESTRICT Clauses in a DROP VIEW Statement</title><summary type='text'>As mentioned in Tip 64, the DBMS will not erase any database data when you drop a view. However, you still have to be careful that the view you are dropping is not referenced by another view. Some DBMS products let you add the CASCADE or RESTRICT clause to a DROP VIEW statement to control the behavior of the DBMS when you tell the system to DROP a view that is referenced by another view.If you </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6596651696206105707/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/understanding-cascade-and-restrict.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6596651696206105707'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6596651696206105707'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/understanding-cascade-and-restrict.html' title='Understanding the CASCADE and RESTRICT Clauses in a DROP VIEW Statement'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5615983167051698361</id><published>2010-03-03T04:40:00.000-08:00</published><updated>2010-03-03T04:44:47.225-08:00</updated><title type='text'>Using the MS-SQL Server Enterprise Manager Create View Wizard to Create a View</title><summary type='text'>Views are virtual tables. Although they look and act like  regular relational database tables, views contain no data. Rather, a view is a  set of instructions for the DBMS that tells it what data stored in physical  (real) tables to display and how to display it. MS-SQL Server gives you two ways  to define a view. You can use the CREATE VIEW statement (which you will learn  about in Tip  206, "</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5615983167051698361/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-enterprise-manager_03.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5615983167051698361'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5615983167051698361'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-enterprise-manager_03.html' title='Using the MS-SQL Server Enterprise Manager Create View Wizard to Create a View'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://2.bp.blogspot.com/_y2Rv-tjfx8M/S45ZYdugpQI/AAAAAAAAASc/F80yLAiBpr4/s72-c/untitled.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8777334158945959212</id><published>2010-03-03T04:38:00.000-08:00</published><updated>2010-03-03T04:39:41.902-08:00</updated><title type='text'>Using the DROP VIEW Statement to Remove a View</title><summary type='text'>To remove a database view that you no longer need, execute the DROP VIEW statement. Unlike the DROP TABLE statement, the DROP VIEW command does not erase any database tables or data. When you DROP a view, the DBMS simply removes its definition (the name and the SELECT statement that defines the view) from the system tables. If you later decide you need the view again, simply use the CREATE VIEW </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8777334158945959212/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-drop-view-statement-to-remove.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8777334158945959212'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8777334158945959212'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-drop-view-statement-to-remove.html' title='Using the DROP VIEW Statement to Remove a View'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8574010347957725488</id><published>2010-03-03T04:37:00.000-08:00</published><updated>2010-03-03T04:38:39.812-08:00</updated><title type='text'>Using the DROP TABLE Statement to Remove a Table from the Database</title><summary type='text'>When you no longer need a table, use the DROP TABLE statement to remove it from the database. Before dropping a table, however, make sure that you no longer need it! When the DBMS executes the DROP TABLE statement, it erases the table data and index(es) from the database and removes the definition of the table and its constraints from the system tables. Thus, the only way to recover a dropped </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8574010347957725488/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-drop-table-statement-to-remove.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8574010347957725488'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8574010347957725488'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-drop-table-statement-to-remove.html' title='Using the DROP TABLE Statement to Remove a Table from the Database'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5232391474700742267</id><published>2010-03-03T04:36:00.002-08:00</published><updated>2010-03-03T04:37:23.049-08:00</updated><title type='text'>Using the CREATE TABLE Statement to Assign Foreign Key Constraints</title><summary type='text'>As was previously discussed, a database key uniquely identifies a row in a table. In Tip 61, "Using the CREATE TABLE Statement to Assign the Primary Key," you learned that each row in a PRIMARY KEY uniquely identifies single row within the table in which the PRIMARY KEY is declared. A FOREIGN KEY, on the other hand, references the PRIMARY KEY in a table other than the one in which the FOREIGN KEY</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5232391474700742267/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-create-table-statement-to-assign_03.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5232391474700742267'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5232391474700742267'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-create-table-statement-to-assign_03.html' title='Using the CREATE TABLE Statement to Assign Foreign Key Constraints'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5315534546760418419</id><published>2010-03-03T04:36:00.001-08:00</published><updated>2010-03-03T04:36:48.152-08:00</updated><title type='text'>Using the CREATE TABLE Statement to Assign the Primary Key</title><summary type='text'>A key is a column or combination of columns that uniquely identifies a row in a table. As such, a key gives you way to distinguish one particular row in a table from all of the others. Because a key must be unique, you should not include NULL values in any of the columns that make up a key. Remember, the DBMS cannot make any assumptions about the actual value of NULL in a column. Thus, a row with</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5315534546760418419/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-create-table-statement-to-assign.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5315534546760418419'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5315534546760418419'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-create-table-statement-to-assign.html' title='Using the CREATE TABLE Statement to Assign the Primary Key'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4042640097839520206</id><published>2010-03-03T04:35:00.000-08:00</published><updated>2010-03-03T04:36:03.465-08:00</updated><title type='text'>Using the ALTER TABLE Statement to Change Primary and Foreign Keys</title><summary type='text'>In addition to changing the width and data type of a column, you can use the ALTER TABLE statement to add table constraints such as a PRIMARY KEY and FOREIGN KEY. Tip 61, "Using the CREATE TABLE Statement to Assign the Primary Key," and Tip 62, "Using the CREATE TABLE Statement to Assign Foreign Key Constraints," will show you how to define keys as part of the CREATE TABLE statement when creating</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4042640097839520206/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-alter-table-statement-to-change_03.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4042640097839520206'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4042640097839520206'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-alter-table-statement-to-change_03.html' title='Using the ALTER TABLE Statement to Change Primary and Foreign Keys'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5053895750867984882</id><published>2010-03-03T04:34:00.000-08:00</published><updated>2010-03-03T04:35:22.147-08:00</updated><title type='text'>Using the ALTER TABLE Statement to Change to Width or Data Type of a Column</title><summary type='text'>Unlike many DBMS products, MS-SQL Server allows you to change not only the width of a column but also its data type. There are, however, a few restrictions on data type changes. You cannot change the data type of a column if the column:Is of type TEXT, IMAGE, NTEXT, or TIMESTAMPIs part of an index, unless the original data type is VARCHAR or VARBINARY and you are not changing the original data </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5053895750867984882/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-alter-table-statement-to-change.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5053895750867984882'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5053895750867984882'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-alter-table-statement-to-change.html' title='Using the ALTER TABLE Statement to Change to Width or Data Type of a Column'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6010462580693980079</id><published>2010-03-03T04:32:00.000-08:00</published><updated>2010-03-03T04:34:40.285-08:00</updated><title type='text'>Using the MS-SQL Server ALTER TABLE DROP COLUMN Clause to Remove a Table Column</title><summary type='text'>The SQL-92 standard does not specify a DROP COLUMN clause as part of the ALTER TABLE statement. As a result, some DBMS products require that you unload data from the table, use the DROP TABLE statement to erase the table, execute the CREATE TABLE statement to re-create the table without the column you want to drop, and then reload the data you unloaded before dropping the table. (Given the steps </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6010462580693980079/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-alter-table-drop.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6010462580693980079'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6010462580693980079'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-alter-table-drop.html' title='Using the MS-SQL Server ALTER TABLE DROP COLUMN Clause to Remove a Table Column'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-2525942926921605671</id><published>2010-03-01T02:46:00.000-08:00</published><updated>2010-03-01T02:47:14.326-08:00</updated><title type='text'>Using the ALTER TABLE Statement to Add a Column to a Table</title><summary type='text'>Adding a column to a table is perhaps the most common use of  the ALTER TABLE statement. The syntax of the ALTER TABLE statement to add a  column is:  ALTER TABLE  ADD   [DEFAULT ]  [NOT NULL] [IDENTITY][UNIQUE][CHECK ()]For example, to add a BADGE_NUMBER column to an EMPLOYEE table  defined by  CREATE TABLE employee (employee_id            INTEGER,  first_name             VARCHAR(20),  last_name</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/2525942926921605671/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-alter-table-statement-to-add.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2525942926921605671'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2525942926921605671'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-alter-table-statement-to-add.html' title='Using the ALTER TABLE Statement to Add a Column to a Table'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4161871816855639060</id><published>2010-03-01T02:45:00.002-08:00</published><updated>2010-03-01T02:46:39.789-08:00</updated><title type='text'>Understanding the ALTER TABLE Statement</title><summary type='text'>No amount of prior planning completely eliminates the need  for changing the structure of tables over the course of time. This is not to say  that you should spend little time designing tables because they are going to change anyway. Quite the  opposite—the more time you spend on design and deciding exactly what data goes  in what tables, the less time you will spend later changing your tables </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4161871816855639060/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/understanding-alter-table-statement.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4161871816855639060'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4161871816855639060'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/understanding-alter-table-statement.html' title='Understanding the ALTER TABLE Statement'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5570401071995690273</id><published>2010-03-01T02:45:00.001-08:00</published><updated>2010-03-01T02:45:42.732-08:00</updated><title type='text'>Using the Transact-SQL DROP DEFAULT Statement to Remove a Default from a Database</title><summary type='text'>When you no longer need a default you've created, you can  use the Transact-SQL DROP DEFAULT statement to permanently remove the default  from the database in which you created it. The syntax of the DROP DEFAULT  statement is DROP DEFAULT  {, , ... ,] where the  is the name you gave the default  when you defined it. As you can see from the syntax of the statement, you can  drop multiple defaults </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5570401071995690273/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-transact-sql-drop-default.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5570401071995690273'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5570401071995690273'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-transact-sql-drop-default.html' title='Using the Transact-SQL DROP DEFAULT Statement to Remove a Default from a Database'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5980579403520613968</id><published>2010-03-01T02:32:00.000-08:00</published><updated>2010-03-01T02:44:58.353-08:00</updated><title type='text'>Using the MS-SQL Server Enterprise Manager to Bind a Default to a Data Type or Table Column</title><summary type='text'>Before MS-SQL Server will use a default value you've  created, you must bind the default to a table column or a user-defined data  type. In Tip 50,  "Using the MS-SQL Server Stored Procedure sp_bindefault to Bind a User-Created  Default to a Table Column," you learned how to use the stored procedure  sp_bindefault to bind a default to a table column. In this tip, you will learn  how to use the </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5980579403520613968/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-enterprise-manager_135.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5980579403520613968'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5980579403520613968'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-enterprise-manager_135.html' title='Using the MS-SQL Server Enterprise Manager to Bind a Default to a Data Type or Table Column'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://3.bp.blogspot.com/_y2Rv-tjfx8M/S4uaCXZcRoI/AAAAAAAAAQ8/MDaKAccojqc/s72-c/untitled1.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4538211959346212357</id><published>2010-03-01T02:26:00.000-08:00</published><updated>2010-03-01T02:32:07.531-08:00</updated><title type='text'>Using the MS-SQL Server Enterprise Manager to Create a User-Defined Data Type</title><summary type='text'>You learned about SQL data types in Tips 21–26, and you used  them when you learned to create a table in Tip 46, "Using the CREATE TABLE  Statement to Create Tables." As you now know, each table column must have a data  type that defines the type of data you can put into the column. For example, if  a column is of type INTEGER, you can store only whole numbers—characters and  numbers with a </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4538211959346212357/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-enterprise-manager_4706.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4538211959346212357'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4538211959346212357'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-enterprise-manager_4706.html' title='Using the MS-SQL Server Enterprise Manager to Create a User-Defined Data Type'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://1.bp.blogspot.com/_y2Rv-tjfx8M/S4uXiJ8Hu1I/AAAAAAAAAQ0/7zGCWleLbdM/s72-c/untitled1.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8891863799686654335</id><published>2010-03-01T02:23:00.000-08:00</published><updated>2010-03-01T02:25:58.537-08:00</updated><title type='text'>Using the MS-SQL Server Enterprise Manager to Create a Default for a User-Defined Data Type or Table Column</title><summary type='text'>As usual, MS-SQL Server has both a command-line Transact-SQL  statement way to create a default (which you learned about in Tip 49, "Using the  Transact-SQL CREATE DEFAULT Statement to Set a Column Default") and a GUI method  using the MS-SQL Server Enterprise Manager. The advantages of creating a default  outside the CREATE TABLE statement are that you can give the default a  meaningful name, </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8891863799686654335/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-enterprise-manager_01.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8891863799686654335'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8891863799686654335'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-enterprise-manager_01.html' title='Using the MS-SQL Server Enterprise Manager to Create a Default for a User-Defined Data Type or Table Column'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://1.bp.blogspot.com/_y2Rv-tjfx8M/S4uWCX9GJeI/AAAAAAAAAQs/llkoiu-ikWk/s72-c/untitled.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-1991597431107705964</id><published>2010-03-01T02:22:00.002-08:00</published><updated>2010-03-01T02:23:19.287-08:00</updated><title type='text'>Using the DEFAULT Clause in a CREATE TABLE Statement to Set Default Column Values</title><summary type='text'>A default column value is the character string or number  that you want the DBMS to enter into a column when you don't provide a value for  the column. You learned how to create default column values in Tip 49, "Using the  Transact-SQL CREATE DEFAULT Statement to Set a Column Default," and how to bind  them to multiple columns in one or more tables in Tip 50, "Using the MS-SQL Server  Stored </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/1991597431107705964/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-default-clause-in-create-table.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1991597431107705964'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1991597431107705964'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-default-clause-in-create-table.html' title='Using the DEFAULT Clause in a CREATE TABLE Statement to Set Default Column Values'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6527274688261193334</id><published>2010-03-01T02:22:00.001-08:00</published><updated>2010-03-01T02:22:52.360-08:00</updated><title type='text'>Using the MS-SQL Server Stored Procedure sp_bindefault to Bind a User-Created Default to a Table Column</title><summary type='text'>As mentioned in Tip 49, "Using the Transact-SQL CREATE DEFAULT Statement to  Set a Column Default," you must bind defaults to table  columns so the DBMS knows which columns it is supposed to set to which default  values. The syntax to use when executing the stored procedure sp_bindefault to  bind a default value to a table column is  EXEC sp_bindefault @DEFNAME=, @OBJNAME=.where  is the name you </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6527274688261193334/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-stored-procedure.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6527274688261193334'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6527274688261193334'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-stored-procedure.html' title='Using the MS-SQL Server Stored Procedure sp_bindefault to Bind a User-Created Default to a Table Column'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-3481692734359544241</id><published>2010-03-01T02:21:00.001-08:00</published><updated>2010-03-01T02:21:59.533-08:00</updated><title type='text'>Using the Transact-SQL CREATE DEFAULT Statement to Set a Column Default</title><summary type='text'>MS-SQL Server lets you create named, default values you can bind to columns and user-defined data types. Once you bind a  default to a table column, the DBMS will supply the default value for the column  (instead of NULL) if you insert a row that includes the column without  specifying its value. The advantages of creating a default outside the CREATE  TABLE statement are that you can use a </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/3481692734359544241/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-transact-sql-create-default.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3481692734359544241'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3481692734359544241'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-transact-sql-create-default.html' title='Using the Transact-SQL CREATE DEFAULT Statement to Set a Column Default'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-2831206261548297755</id><published>2010-03-01T02:17:00.000-08:00</published><updated>2010-03-01T02:21:22.806-08:00</updated><title type='text'>Creating MS-SQL Server Temporary Tables</title><summary type='text'>MS-SQL Server lets you create two types of temporary tables:  global and local. Local temporary tables are available only to the session in  which they are created, and the DBMS automatically erases local temporary tables  when the session ends. Global temporary tables are available to multiple  database sessions. The DBMS drops a global temporary table after the last user  using the table </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/2831206261548297755/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/creating-ms-sql-server-temporary-tables.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2831206261548297755'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2831206261548297755'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/creating-ms-sql-server-temporary-tables.html' title='Creating MS-SQL Server Temporary Tables'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4472690816458402308</id><published>2010-03-01T01:59:00.000-08:00</published><updated>2010-03-03T05:10:49.744-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Tips-and-Techniques'/><title type='text'>SQL Tips and Techniques</title><summary type='text'>SQL Tips and Techniques  - Chapter 1Understanding the MS-SQL Server TempDB DatabaseUnderstanding How to Size MS-SQL Server Databases and Transaction LogsUsing DROP DATABASE to Erase an MS-SQL Server Database and Transaction LogUsing the MS-SQL Server Enterprise Manager to Create a Database and Transaction LogUsing the CREATE DATABASE Statement to Create an MS-SQL Server Database and Transaction </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4472690816458402308/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/sql-tips-and-techniques.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4472690816458402308'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4472690816458402308'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/sql-tips-and-techniques.html' title='SQL Tips and Techniques'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4199788286420543641</id><published>2010-03-01T01:51:00.000-08:00</published><updated>2010-03-01T02:18:41.850-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-2-S'/><title type='text'>Using the MS-SQL Server Enterprise Manager to Create Tables</title><summary type='text'>In addition to typing CREATE TABLE statements into the  MS-SQL Server Query Analyzer's Query pane or at the ISQL (or OSQL) Ready  prompts, MS-SQL Server gives you a GUI tool you can use. To create a table using  the Enterprise Manager, perform the following steps:  To start the Enterprise Manager, click on the Start button,  move your mouse pointer to Programs on the Start menu, select Microsoft </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4199788286420543641/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-enterprise-manager.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4199788286420543641'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4199788286420543641'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/03/using-ms-sql-server-enterprise-manager.html' title='Using the MS-SQL Server Enterprise Manager to Create Tables'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://2.bp.blogspot.com/_y2Rv-tjfx8M/S4uPb3RJarI/AAAAAAAAAQc/qyv3eIqP4AQ/s72-c/untitled.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-1941438952867901847</id><published>2010-02-27T00:33:00.001-08:00</published><updated>2010-02-27T00:33:18.978-08:00</updated><title type='text'>Understanding the MS-SQL Server TempDB Database</title><summary type='text'>Each time you start MS-SQL Server, the DBMS creates a special  database named TempDB. The server uses the TempDB database for such things as  temporary tables, cursor data, and temporary, user-created global variables. In  short, the TempDB database is the system's scratchpad. However, you can use it  as well. The advantage of using TempDB is that activities you perform to  TempDB objects (tables</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/1941438952867901847/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-ms-sql-server-tempdb.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1941438952867901847'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1941438952867901847'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-ms-sql-server-tempdb.html' title='Understanding the MS-SQL Server TempDB Database'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-1911386138058220878</id><published>2010-02-27T00:32:00.001-08:00</published><updated>2010-02-27T00:32:51.827-08:00</updated><title type='text'>Understanding How to Size MS-SQL Server Databases and Transaction Logs</title><summary type='text'>MS-SQL Server puts all database objects (tables, views,  procedures, triggers, indexes, and so on) into a single large file. Whenever you  make a change to the database (add an object, alter an object, delete a row,  update a column value, insert a row, and so on), the DBMS makes an entry in a  second file, the transaction log. Thus, every database has two files: the  database file, which </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/1911386138058220878/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-how-to-size-ms-sql-server.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1911386138058220878'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1911386138058220878'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-how-to-size-ms-sql-server.html' title='Understanding How to Size MS-SQL Server Databases and Transaction Logs'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8157468940412102314</id><published>2010-02-27T00:31:00.000-08:00</published><updated>2010-02-27T00:32:19.117-08:00</updated><title type='text'>Using DROP DATABASE to Erase an MS-SQL Server Database and Transaction Log</title><summary type='text'>Dropping (deleting) databases you no longer need frees up disk  space. The primary rule to follow: Be careful! You cannot  easily undo an executed DROP DATABASE statement. As such, always back up the  database before dropping (erasing) it. Having a full backup will save you a lot  of headaches if the user decides he or she needs "one more thing" from the  database-right after you erase it, of </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8157468940412102314/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-drop-database-to-erase-ms-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8157468940412102314'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8157468940412102314'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-drop-database-to-erase-ms-sql.html' title='Using DROP DATABASE to Erase an MS-SQL Server Database and Transaction Log'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-7100898660778007752</id><published>2010-02-27T00:25:00.000-08:00</published><updated>2010-02-27T00:31:56.661-08:00</updated><title type='text'>Using the MS-SQL Server Enterprise Manager to Create a Database and Transaction Log</title><summary type='text'>In Tip 41, "Using the CREATE DATABASE Statement to Create an  MS-SQL Server Database and Transaction Log," you learned that MS-SQL Server lets  you create multiple databases on a single server, and you also learned how to  use the CREATE DATABASE statement. Like most database management tools, MS-SQL  Server gives you not only a command line (SQL or Transact-SQL) statement, but  also a graphical </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/7100898660778007752/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-ms-sql-server-enterprise-manager.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7100898660778007752'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7100898660778007752'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-ms-sql-server-enterprise-manager.html' title='Using the MS-SQL Server Enterprise Manager to Create a Database and Transaction Log'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://2.bp.blogspot.com/_y2Rv-tjfx8M/S4jYDFr_yiI/AAAAAAAAAP0/T-9i3LiVCxM/s72-c/untitled.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-7261701028855811125</id><published>2010-02-27T00:23:00.001-08:00</published><updated>2010-02-27T00:25:16.674-08:00</updated><title type='text'>Using the CREATE DATABASE Statement to Create an MS-SQL Server Database and Transaction Log</title><summary type='text'>Unlike many other DBMS products, MS-SQL Server lets you  create multiple databases for each MS-SQL Server. Most commercial DBMS products  do not even have a CREATE DATABASE command. Instead, the installation program  creates the one database file the SQL Server will use. The database  administrator (dba) and privileged users then create all of the database objects  in the one database. As a </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/7261701028855811125/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-create-database-statement-to.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7261701028855811125'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7261701028855811125'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-create-database-statement-to.html' title='Using the CREATE DATABASE Statement to Create an MS-SQL Server Database and Transaction Log'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://1.bp.blogspot.com/_y2Rv-tjfx8M/S4jWo4AfHbI/AAAAAAAAAPs/_2Ef22hDVyk/s72-c/untitled.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4559157852980814</id><published>2010-02-27T00:22:00.001-08:00</published><updated>2010-02-27T00:22:48.337-08:00</updated><title type='text'>Using the ED Command Within ISQL to Edit SQL Statements</title><summary type='text'>Before sending SQL statements to the DBMS when you enter the GO  command, ISQL acts as a line editor. As you learned in Tip 39, "Using the MS-SQL Server ISQL  to Execute SQL Statements from the Command Line or Statements Stored in an ASCII  File," the format of the command to start ISQL at the MS-DOS command line  is: ISQL -S -U -P     Note   Substitute the name of your SQL Server for NVBizNet2, </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4559157852980814/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-ed-command-within-isql-to-edit.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4559157852980814'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4559157852980814'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-ed-command-within-isql-to-edit.html' title='Using the ED Command Within ISQL to Edit SQL Statements'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-7593239151994769568</id><published>2010-02-27T00:19:00.000-08:00</published><updated>2010-02-27T00:22:12.041-08:00</updated><title type='text'>Using the MS-SQL Server ISQL to Execute SQL Statements from the Command Line or Statements Stored in an ASCII File</title><summary type='text'>In Tip 38, "Using the MS-SQL Server Query Analyzer to Execute  SQL Statements," you learned how to use the MS-SQL Query Analyzer GUI query  tool. MS-SQL Server also includes two command-line query tools: ISQL.EXE and  OSQL.EXE. You'll find both of these tools in  MS-SQL Server's BINN subdirectory. (If you installed MS-SQL Server to the  default C:\MSSQL7 folder, you will find ISQL and OSQL in the</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/7593239151994769568/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-ms-sql-server-isql-to-execute-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7593239151994769568'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7593239151994769568'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-ms-sql-server-isql-to-execute-sql.html' title='Using the MS-SQL Server ISQL to Execute SQL Statements from the Command Line or Statements Stored in an ASCII File'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://1.bp.blogspot.com/_y2Rv-tjfx8M/S4jV_RYlPiI/AAAAAAAAAPk/Kggr6JWEw7k/s72-c/untitled.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-7082746877501902880</id><published>2010-02-27T00:11:00.004-08:00</published><updated>2010-02-27T00:19:44.809-08:00</updated><title type='text'>Using the MS-SQL Server Query Analyzer to Execute SQL Statements</title><summary type='text'>You can use the MS-SQL Server Query Analyzer (QA) to execute  any SQL statement supported by MS-SQL Server. (As mentioned in previous tips, no  commercially available database supports everything in the SQL-92 standard.) QA  has a graphical user interface (GUI) you can use to pose ad hoc (interactive)  queries and to send SQL commands to an MS-SQL Server. (MS-SQL Server also  provides a </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/7082746877501902880/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-ms-sql-server-query-analyzer-to.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7082746877501902880'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7082746877501902880'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/using-ms-sql-server-query-analyzer-to.html' title='Using the MS-SQL Server Query Analyzer to Execute SQL Statements'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://4.bp.blogspot.com/_y2Rv-tjfx8M/S4jUFwHODeI/AAAAAAAAAPU/zH5oQA3W3rA/s72-c/untitled.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-2298679018396508134</id><published>2010-02-27T00:11:00.003-08:00</published><updated>2010-02-27T00:11:41.997-08:00</updated><title type='text'>Understanding SQL Keywords</title><summary type='text'>SQL keywords are words that have a special significance in  SQL and should not be used as user-defined names for database objects such as  tables, columns, domains, constraints, procedures, variables, and so on. There  are two types of keywords, reserved and nonreserved. The difference between  reserved and nonreserved keywords is that some database products let you  (although you should not) use</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/2298679018396508134/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-keywords.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2298679018396508134'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2298679018396508134'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-keywords.html' title='Understanding SQL Keywords'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4967967955234154704</id><published>2010-02-27T00:11:00.001-08:00</published><updated>2010-02-27T00:11:20.114-08:00</updated><title type='text'>Understanding How the DBMS Executes SQL Statements</title><summary type='text'>When processing an SQL statement, the DBMS goes through five  steps:  Parse. The DBMS goes through the SQL statement word by word  and clause by clause to make sure that all of the keywords are valid and all of  the clauses are well-formed. The DBMS will catch any syntax errors (badly formed  SQL expressions) or typographical errors (misspelled keywords) during the  parsing stage.  Validate. The </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4967967955234154704/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-how-dbms-executes-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4967967955234154704'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4967967955234154704'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-how-dbms-executes-sql.html' title='Understanding How the DBMS Executes SQL Statements'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-7671045448407413475</id><published>2010-02-27T00:08:00.000-08:00</published><updated>2010-02-27T00:10:59.604-08:00</updated><title type='text'>Understanding the Structure of SQL Statements</title><summary type='text'>When using SQL to send commands to the DBMS, you first tell the  DBMS what you want to do and then describe the data (or structure) on which you  want the DBMS to take the action. SQL is similar to the German language in that  you put the action word (the verb) at the beginning of the sentence (the SQL  statement) and then follow the verb with one or more clauses that describe the  subject (the </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/7671045448407413475/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-structure-of-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7671045448407413475'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7671045448407413475'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-structure-of-sql.html' title='Understanding the Structure of SQL Statements'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://2.bp.blogspot.com/_y2Rv-tjfx8M/S4jTDad-sEI/AAAAAAAAAPM/dXCu5FVPmmo/s72-c/untitled.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-1821980058425255675</id><published>2010-02-27T00:02:00.000-08:00</published><updated>2010-02-27T00:06:36.309-08:00</updated><title type='text'>Understanding the SQL DBMS Client/Server Model</title><summary type='text'>Client/Server computing (often called n-tier computing when you  use the Internet to connect the client to the server), involves distributed data  processing, or multiple computers working together to perform a set of  operations. In the client/server model, the client (workstations) and server  (DBMS) work together to perform operations that create objects and manipulate  the data in a database.</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/1821980058425255675/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-dbms-clientserver.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1821980058425255675'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1821980058425255675'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-dbms-clientserver.html' title='Understanding the SQL DBMS Client/Server Model'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-361501522103087662</id><published>2010-02-26T23:59:00.000-08:00</published><updated>2010-02-27T00:00:26.575-08:00</updated><title type='text'>Understanding Assertions</title><summary type='text'>As you learned in Tip 15, "Understanding Constraints," a  constraint is a database object that restricts the data a user or application  program can enter into the columns of a table. An assertion is a database object  that uses a check constraint to limit data values you can enter into the  database as a whole. Both assertions and constraints are specified as check conditions  that the DBMS can </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/361501522103087662/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-assertions.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/361501522103087662'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/361501522103087662'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-assertions.html' title='Understanding Assertions'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8498345894404158079</id><published>2010-02-26T23:58:00.005-08:00</published><updated>2010-02-26T23:59:52.053-08:00</updated><title type='text'>Understanding the MS-SQL Server IDENTITY Property</title><summary type='text'>You can apply the IDENTITY property to one (and only one) of  the columns in a table to have MS-SQL Server supply an incrementing, non-NULL  value for the column whenever a row is added that does not specify the column's  value. Suppose, for example, that you wanted to create an EMPLOYEE table that  included an EMPLOYEE_ID column, but you did not want to supply the EMPLOYEE_ID  each time you </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8498345894404158079/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-ms-sql-server-identity_26.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8498345894404158079'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8498345894404158079'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-ms-sql-server-identity_26.html' title='Understanding the MS-SQL Server IDENTITY Property'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-1041474219736558379</id><published>2010-02-26T23:58:00.004-08:00</published><updated>2010-02-26T23:59:21.116-08:00</updated><title type='text'>Understanding the MS-SQL Server IDENTITY Property</title><summary type='text'>You can apply the IDENTITY property to one (and only one) of  the columns in a table to have MS-SQL Server supply an incrementing, non-NULL  value for the column whenever a row is added that does not specify the column's  value. Suppose, for example, that you wanted to create an EMPLOYEE table that  included an EMPLOYEE_ID column, but you did not want to supply the EMPLOYEE_ID  each time you </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/1041474219736558379/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-ms-sql-server-identity.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1041474219736558379'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1041474219736558379'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-ms-sql-server-identity.html' title='Understanding the MS-SQL Server IDENTITY Property'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-325934619609195426</id><published>2010-02-26T23:58:00.003-08:00</published><updated>2010-02-26T23:58:43.809-08:00</updated><title type='text'>Understanding the MS-SQL Server ISNULL() Function</title><summary type='text'>You can use the MS-SQL Server ISNULL() built-in function to  return a value other than NULL for columns that are NULL. Suppose, for example,  that your EMPLOYEE table has data in columns as shown in Figure 31.1.       EMPLOYEE table   ID   NAME   DATE_HIRED   QUOTA     1  Sally Smith  04/27/00  NULL   2  Wally Wells  04/13/99  5   3  Greg Jones  05/12/97  7   4  Bruce Williams  04/15/00  NULL   5</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/325934619609195426/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-ms-sql-server-isnull.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/325934619609195426'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/325934619609195426'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-ms-sql-server-isnull.html' title='Understanding the MS-SQL Server ISNULL() Function'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-3927366634548774000</id><published>2010-02-26T23:58:00.001-08:00</published><updated>2010-02-26T23:58:21.802-08:00</updated><title type='text'>Understanding the Value of NULL</title><summary type='text'>When a DBMS finds a NULL value in a column, it interprets it  as undefined or unavailable. The SQL-92 standard specifies that a DBMS cannot  assign or assume an explicit or implicit value to a NULL column. A NULL is not the same as a space (in a character column), a zero  (in a numeric column), or a NULL ASCII character (which is all zeroes) (in a  character column). In fact, if you execute the </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/3927366634548774000/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-value-of-null.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3927366634548774000'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3927366634548774000'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-value-of-null.html' title='Understanding the Value of NULL'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-2524715152498245000</id><published>2010-02-26T23:57:00.000-08:00</published><updated>2010-02-26T23:58:00.535-08:00</updated><title type='text'>Understanding Constants</title><summary type='text'>SQL does not have a CONSTANT data type, like that found in  programming languages such as Pascal, Visual Basic, and C++. However, you do not  have to put data values into columns in order to use those values in SQL  statements. Valid SQL statements can and often do include literal string,  numeric, and date and time constants, and symbolic constants (also referred to  as system maintained </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/2524715152498245000/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-constants.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2524715152498245000'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2524715152498245000'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-constants.html' title='Understanding Constants'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-429817521672965410</id><published>2010-02-26T23:54:00.002-08:00</published><updated>2010-02-26T23:55:01.288-08:00</updated><title type='text'>Understanding the SQL BIT Data Type</title><summary type='text'>When you are working with data that can take on only one of  two values, use the BIT data type. For example, you can use BIT fields to store  the answers to yes/no or true/false survey questions such as: these "Are you a  homeowner?" "Are you married?" "Did you complete high school?" "Do you love  SQL?" You can store answers to yes/no and true/false questions in  CHARACTER columns using the </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/429817521672965410/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-bit-data-type.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/429817521672965410'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/429817521672965410'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-bit-data-type.html' title='Understanding the SQL BIT Data Type'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6397749185569474424</id><published>2010-02-26T23:54:00.001-08:00</published><updated>2010-02-26T23:54:36.363-08:00</updated><title type='text'>Understanding Standard SQL Datetime Data Types and the DATETIME Data Type</title><summary type='text'>Although you can store dates and times in columns of type  CHAR or VARCHAR, you will find it more convenient to use datetime columns  instead. If you put dates and times into date-time columns, the DBMS will format  the dates and times in a standard way when you display the contents of the  columns as part of SELECT statements. More importantly, by using datetime  columns, you will be able to use</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6397749185569474424/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-standard-sql-datetime.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6397749185569474424'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6397749185569474424'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-standard-sql-datetime.html' title='Understanding Standard SQL Datetime Data Types and the DATETIME Data Type'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4551137223081927869</id><published>2010-02-26T23:53:00.000-08:00</published><updated>2010-02-26T23:54:02.086-08:00</updated><title type='text'>Understanding the MS-SQL Server IMAGE Data Type</title><summary type='text'>The MS-SQL Server IMAGE data type is similar to the TEXT  data type in that it you can store 2,147,483,647 bytes of data in a column  declared as data type IMAGE. You would use an image type, for example, if you  wanted to create a table of graphics images such as: CREATE TABLE graphic_images (id          INTEGER,  description VARCHAR(250),  picture     IMAGE) Typically, you won't use an INSERT </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4551137223081927869/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-ms-sql-server-image-data.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4551137223081927869'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4551137223081927869'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-ms-sql-server-image-data.html' title='Understanding the MS-SQL Server IMAGE Data Type'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5920992987837593796</id><published>2010-02-26T23:51:00.000-08:00</published><updated>2010-02-26T23:53:19.382-08:00</updated><title type='text'>Understanding the LONG (Oracle) or TEXT (MS-SQL Server) Data Type</title><summary type='text'>If you need to store a large amount of text data in a table,  you may run into the problem of needing to store a character string larger than  the maximum number or characters allowed for the CHARACTER (or VARCHAR) data  type. Suppose, for example, that you had a HUMAN_RESOURCES table and one of the  columns was RESUME. If you are using MS-SQL Server as your DBMS, you could store  only the first </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5920992987837593796/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-long-oracle-or-text-ms.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5920992987837593796'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5920992987837593796'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-long-oracle-or-text-ms.html' title='Understanding the LONG (Oracle) or TEXT (MS-SQL Server) Data Type'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5585056349778897524</id><published>2010-02-26T23:28:00.000-08:00</published><updated>2010-03-01T02:14:45.396-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Tips-and-Techniques'/><title type='text'>Chapter 1 - SQL Tips and Techniques</title><summary type='text'>Chapter 1 - SQL Tips and TechniquesChapter 1: Understanding SQL Basics and Creating Database FilesUnderstanding Flat Files - SQL Tips and TechniquesUnderstanding the Hierarchical Database Model - SQL Tips and TechniquesUnderstanding the Network Database ModelUnderstanding the Relational Database ModelUnderstanding Codd's 12-Rule Relational Database DefinitionUnderstanding Terms Used to Define an </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5585056349778897524/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/chapter-1-sql-tips-and-techniques.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5585056349778897524'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5585056349778897524'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/chapter-1-sql-tips-and-techniques.html' title='Chapter 1 - SQL Tips and Techniques'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-1852266367630004195</id><published>2010-02-25T02:10:00.000-08:00</published><updated>2010-02-25T02:10:33.751-08:00</updated><title type='text'>Understanding the Advantages of Using the VARCHAR Data Type</title><summary type='text'>If you have a text column where the number of characters you  want to store varies from to row, use a variable-length character string to save  disk space. Suppose, for example, that you define an order table as follows:CREATE TABLE order_table
   (customer_number      INTEGER,
    delivery_date        DATE,
    item_number          SMALLINT,
    quantity             SMALLINT,
    </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/1852266367630004195/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-advantages-of-using.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1852266367630004195'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1852266367630004195'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-advantages-of-using.html' title='Understanding the Advantages of Using the VARCHAR Data Type'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-134463745649636292</id><published>2010-02-24T03:43:00.002-08:00</published><updated>2010-02-24T03:44:45.628-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1-Part-1'/><title type='text'>Understanding SQL Character Data Types</title><summary type='text'>Table columns defined as being of one of the character data types  can hold letters, numbers, and special characters (such as !,@,#,$,%,^, and so  on). There are four character data types, each with one or two synonyms. The SQL  character data types are:  Table 23.1: SQL Character Data Types      Character Type    Description      CHAR(length) CHARACTER(length)  Fixed-length character string   </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/134463745649636292/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-character-data-types.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/134463745649636292'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/134463745649636292'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-character-data-types.html' title='Understanding SQL Character Data Types'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4980315317995433894</id><published>2010-02-24T03:43:00.001-08:00</published><updated>2010-02-24T03:43:49.991-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding SQL Numeric Floating-Point Data Types</title><summary type='text'>You can use floating-point columns to store both whole  numbers and numbers with a fractional part—numbers with nonzero digits to the  right of the decimal point. Unlike the INTEGER data types (INTEGER, SMALLINT,  TINYINT), which have precision set by the implementation, you control the  precision of the columns you define as NUMERIC or DECIMAL. (The precision of the  other floating-point data </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4980315317995433894/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-numeric-floating.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4980315317995433894'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4980315317995433894'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-numeric-floating.html' title='Understanding SQL Numeric Floating-Point Data Types'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-7805336151170222809</id><published>2010-02-24T03:42:00.002-08:00</published><updated>2010-02-24T03:43:14.986-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding SQL Numeric Integer Data Types</title><summary type='text'>Columns of type INTEGER can hold whole numbers-numbers  without a fractional part (nonzero digits to the right of the decimal point).  The maximum number of digits, or precision, of an INTEGER column is  implementation-dependant. As such, you cannot control the maximum positive and  negative value you can assign to an INTEGER column (check your SQL manual for  the precision of integers on your </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/7805336151170222809/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-numeric-integer-data.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7805336151170222809'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7805336151170222809'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-numeric-integer-data.html' title='Understanding SQL Numeric Integer Data Types'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-7247451357575399269</id><published>2010-02-24T03:42:00.001-08:00</published><updated>2010-02-24T03:42:41.004-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding Data Control Language (DCL)</title><summary type='text'>While DML lets you make changes to the data in your  database, data control language (DCL) protects your data from harm. If you  correctly use the tools that DCL provides, you can keep unauthorized users from viewing or changing your data,  and prevent many of the problems that can corrupt your database. There are four  DCL commands:  COMMIT. Tells the DBMS to make permanent changes made to  </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/7247451357575399269/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-data-control-language-dcl.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7247451357575399269'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7247451357575399269'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-data-control-language-dcl.html' title='Understanding Data Control Language (DCL)'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8763148503478768013</id><published>2010-02-24T03:41:00.000-08:00</published><updated>2010-02-24T03:42:10.370-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding Data Manipulation Language (DML)</title><summary type='text'>Data manipulation language (DML) lets you do five things to  an SQL database: add data to tables, retrieve and display data in table columns,  change data in tables, and delete data from tables. As such, basic DML consists  of five statements:  INSERT INTO. Lets you add one or more rows (or columns)  into a table.  SELECT. Lets you query one or more tables and will display  columns in rows that </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8763148503478768013/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-data-manipulation.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8763148503478768013'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8763148503478768013'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-data-manipulation.html' title='Understanding Data Manipulation Language (DML)'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8689770479094110358</id><published>2010-02-24T03:39:00.001-08:00</published><updated>2010-02-24T03:41:33.680-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding Data Definition Language (DDL)</title><summary type='text'>Data definition language (DDL) is the set of SQL statements  (ALTER, CREATE, DROP, GRANT) that let you create, alter, or destroy (drop) the  objects that make up a relational database. To put it another way, you use DDL  to define the structure and security of a database. SQL-89 (the first ANSI/ISO  standard written for SQL) defines data manipulation language (DML) and DDL as  two distinct and </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8689770479094110358/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-data-definition-language.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8689770479094110358'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8689770479094110358'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-data-definition-language.html' title='Understanding Data Definition Language (DDL)'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://4.bp.blogspot.com/_y2Rv-tjfx8M/S4UQISLPK9I/AAAAAAAAAOg/E3fTyDSdPWc/s72-c/1.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-649896881399478841</id><published>2010-02-24T03:38:00.001-08:00</published><updated>2010-02-24T03:38:25.499-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding the Difference Between SQL and a Programming Language</title><summary type='text'>To solve problems in a procedural programming language (such  as Basic, C, COBOL, FORTRAN, and so on), you write lines of code that perform  one operation after another until the program completes its tasks. The program  may execute its lines of code in a linear sequence or loop to repeat some steps  or branch to skip others. In any case, when writing a program in a procedural  language, the </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/649896881399478841/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-difference-between-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/649896881399478841'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/649896881399478841'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-difference-between-sql.html' title='Understanding the Difference Between SQL and a Programming Language'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-2836371653312225746</id><published>2010-02-24T03:37:00.001-08:00</published><updated>2010-02-24T03:37:53.485-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding the History of SQL</title><summary type='text'>Both SQL and relational database theory originated in IBM's  research laboratories. In June 1970, Dr. Edgar F. Codd, an IBM engineer, wrote a  paper outlining the mathematical theory of how data could be stored in tables  and manipulated using a data sublanguage. The article, entitled "A Relational  Model of Data for Large Shared Data Banks," was published in the  Communications of the </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/2836371653312225746/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-history-of-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2836371653312225746'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2836371653312225746'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-history-of-sql.html' title='Understanding the History of SQL'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6490019948773889125</id><published>2010-02-24T03:36:00.000-08:00</published><updated>2010-02-24T03:37:21.161-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding Constraints</title><summary type='text'>Constraints are database objects that restrict the data that a  user or application program can enter into the columns of a table. There are  seven types of constraints: assertions, domains, check constraints, foreign key  constraints, primary key constraints, required data, and uniqueness constraints.  Each type of constraint plays a different roll in maintaining database  integrity:  Assertions</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6490019948773889125/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-constraints.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6490019948773889125'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6490019948773889125'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-constraints.html' title='Understanding Constraints'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8576278894176301817</id><published>2010-02-24T03:35:00.000-08:00</published><updated>2010-02-24T03:36:34.013-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding Domains</title><summary type='text'>A domain is the set of all values that are legal for a particular  column in a table. Suppose, for example, that your EMPLOYEE table had a  DEPENDANT field that your company policy states must be an INTEGER between 0 and  14. The domain of DEPENDANT would then be 0,1,2,3,4,5,6,7,8,9,10,12,13,14. Or,  suppose you were maintaining a table for a tablecloth inventory that has a COLOR  column, and all</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8576278894176301817/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-domains.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8576278894176301817'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8576278894176301817'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-domains.html' title='Understanding Domains'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8295591298286124012</id><published>2010-02-24T03:33:00.000-08:00</published><updated>2010-02-24T03:35:40.187-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding the SQL System Catalog</title><summary type='text'>The system catalog is a collection of tables that the DBMS  itself owns, creates, and maintains in order to manage the user-defined objects  (tables, domains, constraints, schemas, other catalogs, security, and so on) in  the database. As a collection, the tables in the system catalog are often  referred to as the system tables because they contain data  that describes the structure of the </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8295591298286124012/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-system-catalog.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8295591298286124012'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8295591298286124012'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-sql-system-catalog.html' title='Understanding the SQL System Catalog'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6348995719739076468</id><published>2010-02-23T04:40:00.000-08:00</published><updated>2010-02-23T04:40:44.236-08:00</updated><title type='text'>Understanding Schemas</title><summary type='text'>A table consists of rows and columns of data that deal with  a specific type of entity such as marketing calls, sales statistics, customers,  orders, payroll, and so on. A schema is the collection of related tables. Thus,  a schema is to tables what tables are to individual data items. While a table  brings together related data items so that they describe an entity when  considered a row at a </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6348995719739076468/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-schemas.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6348995719739076468'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6348995719739076468'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-schemas.html' title='Understanding Schemas'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://3.bp.blogspot.com/_WimV4C7T5Ak/S4PIGGzdm9I/AAAAAAAAACI/KoehRoM4uRo/s72-c/4.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8815262255756507341</id><published>2010-02-23T04:12:00.000-08:00</published><updated>2010-02-23T04:12:25.989-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding Views</title><summary type='text'>As you learned in Tip 7, "Understanding Terms Used to  Define an SQL Database," views are virtual tables. A view looks like a table  because it appears to have all of the essential components of a table-it has a  name, it has rows of data arranged in named columns, and its definition is  stored in the database catalog right along with all of the other "real" tables.  Moreover, you can use the </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8815262255756507341/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-views.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8815262255756507341'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8815262255756507341'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-views.html' title='Understanding Views'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://3.bp.blogspot.com/_WimV4C7T5Ak/S4PF2DXdTiI/AAAAAAAAACA/Ggb_DWzj1MI/s72-c/3.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8072692458815216641</id><published>2010-02-23T04:04:00.001-08:00</published><updated>2010-02-23T04:04:33.710-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding Column Names</title><summary type='text'>The SQL DBMS stores the names of the columns along with the  table names in its system catalog. Column names must be unique within a table  but can appear in multiple tables. For example, you can have a STUDENT_ID column  in both a STUDENT table and a CLASS_SCHEDULE table. However, you cannot have  more than one STUDENT_ID column in either table. When selecting a column name,  use a short, unique</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8072692458815216641/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-column-names.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8072692458815216641'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8072692458815216641'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-column-names.html' title='Understanding Column Names'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-2429659680929216513</id><published>2010-02-23T04:03:00.001-08:00</published><updated>2010-02-23T04:03:47.557-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding Table Names</title><summary type='text'>When selecting the name for a table, make it something short  but descriptive of the data the table will contain. You will want to keep the  name short since you will be typing it in SQL statements that work with the  table's data. Keeping the name descriptive will make it easy to remember which  table has what data, especially in a database system with many (perhaps  hundreds) of tables. If you </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/2429659680929216513/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-table-names.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2429659680929216513'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2429659680929216513'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-table-names.html' title='Understanding Table Names'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4329448697299596298</id><published>2010-02-23T04:02:00.001-08:00</published><updated>2010-02-23T04:02:34.458-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding the Components of a Table</title><summary type='text'>An SQL table consists of scalar (single-value) data arranged  in columns and rows. Relational database tables have the following  components: A unique table name
 Unique names for each of the columns in the table
 At least one column
 Data types, domains, and constraints that specify the type  of data and its range of values for each column in the table
 A structure in which data in one column of</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4329448697299596298/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-components-of-table.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4329448697299596298'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4329448697299596298'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-components-of-table.html' title='Understanding the Components of a Table'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-1980398634540825967</id><published>2010-02-23T03:58:00.000-08:00</published><updated>2010-02-23T03:58:02.168-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding Terms Used to Define an SQL Database</title><summary type='text'>Every SQL database is based on the relational database model. As such, the individual data items in an SQL database are organized into tables. An SQL table (sometimes called a relation), consists of a two-dimensional array of rows and columns. As you learned in Codd's first two rules in Tip 6, "Understanding Codd's 12-Rule Relational Database Definition," each cell in a table contains a single </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/1980398634540825967/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-terms-used-to-define-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1980398634540825967'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1980398634540825967'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-terms-used-to-define-sql.html' title='Understanding Terms Used to Define an SQL Database'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://2.bp.blogspot.com/_WimV4C7T5Ak/S4PBRwNtp5I/AAAAAAAAABw/y3MPOcLfXo8/s72-c/1.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-7652159889158953092</id><published>2010-02-23T03:26:00.001-08:00</published><updated>2010-02-23T03:26:05.781-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding Codd's 12-Rule Relational Database Definition</title><summary type='text'>Dr. Edgar F. Codd published the first theoretical model of a  relational database in an article entitled "A Relational Model of Data for Large  Shared Data Banks" in the Communications of the ACM in 1970. The  relational model was theoretical at the time because all commercially available  database management systems were based on either the hierarchical or the network  database models. Although </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/7652159889158953092/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-codds-12-rule-relational.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7652159889158953092'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/7652159889158953092'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-codds-12-rule-relational.html' title='Understanding Codd&apos;s 12-Rule Relational Database Definition'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4660348315067027134</id><published>2010-02-23T03:24:00.000-08:00</published><updated>2010-02-23T03:24:16.901-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding the Relational Database Model</title><summary type='text'>While the relational database model did not appear in  commercial products until the 1980s, Dr. Edgar F. Codd of IBM defined the  relational database in 1970. The relational model simplifies database structures  by eliminating the explicit parent/child relationship pointers. In a relational  database, all data is organized into tables. The hierarchical and network  database records are </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4660348315067027134/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-relational-database-model.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4660348315067027134'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4660348315067027134'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-relational-database-model.html' title='Understanding the Relational Database Model'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6061245283968318409</id><published>2010-02-23T03:21:00.000-08:00</published><updated>2010-02-23T03:21:03.692-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Understanding the Network Database Model</title><summary type='text'>The network database model extends the hierarchiear model by allowing a record  to participate in multiple parent/child relationships. In order to be helpful, a  database model must be able to represent data relationships in a database to  mirror those we see in the real world. One of the shortcomings of the  hierarchical database model was that a child record could have one and only one  parent.</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6061245283968318409/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-network-database-model.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6061245283968318409'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6061245283968318409'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/understanding-network-database-model.html' title='Understanding the Network Database Model'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-2365139568320027600</id><published>2010-02-23T03:10:00.000-08:00</published><updated>2010-02-23T03:13:29.061-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>3 Understanding the Hierarchical Database Model - SQL Tips and Techniques</title><summary type='text'> hierarchical database model consists of data arranged into  a structure that looks a lot like a family tree or company organizational chart.  If you need to manage data that lends itself to being represented as  parent/child relationships, you can make use of the hierarchical database model.  Suppose, for example, that you have a home food delivery service and need to  know how much of each </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/2365139568320027600/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/3-understanding-hierarchical-database.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2365139568320027600'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2365139568320027600'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/3-understanding-hierarchical-database.html' title='3 Understanding the Hierarchical Database Model - SQL Tips and Techniques'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-6263492738556043069</id><published>2010-02-23T03:09:00.000-08:00</published><updated>2010-02-23T03:12:23.939-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>2 Understanding Flat Files - SQL Tips and Techniques</title><summary type='text'>Flat files are collections of data records. When looking at the  contents of a flat file, you will not find any information (metadata) that  describes the data in the file. Instead, you will see row after row of data such  as the following:010000BREAKFAST JUICES                F00.000000
        010200TREE TOP APPLE JUICE        120ZF01.100422
        010400WELCHES GRAPE JUICE         </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/6263492738556043069/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/2-understanding-flat-files-sql-tips-and.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6263492738556043069'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/6263492738556043069'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/2-understanding-flat-files-sql-tips-and.html' title='2 Understanding Flat Files - SQL Tips and Techniques'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-28524995280230587</id><published>2010-02-23T03:08:00.000-08:00</published><updated>2010-02-23T03:08:07.742-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL-Program-Chapter-1'/><title type='text'>Chapter 1: Understanding SQL Basics and Creating Database Files</title><summary type='text'> 1 Understanding the Definition of a  DatabaseMany people use the term database to  mean any collection of data items. Working as a consultant, I've been called  onsite to repair a database, only to find that the client was referring to a  customer list in a Corel WordPerfect document that appeared "corrupted" because  someone had changed the document's margins. Microsoft and Lotus have also  </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/28524995280230587/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/chapter-1-understanding-sql-basics-and.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/28524995280230587'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/28524995280230587'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/chapter-1-understanding-sql-basics-and.html' title='Chapter 1: Understanding SQL Basics and Creating Database Files'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-3852604578710066272</id><published>2010-02-10T21:57:00.000-08:00</published><updated>2010-02-10T21:59:43.261-08:00</updated><title type='text'>How to initialize an Array and how to copy the array</title><summary type='text'>In this tutorial we are going to see how to initialize an Array and how to copy the array. Java has several types to initialize an array now we are going to see some types to initializing.//Array initializationpublic class Init1{public static void main(String[] args){Integer[] value1 = { new Integer(1), new Integer(2), new Integer(3), };Integer[] value2 = new Integer[] { new Integer(1), new </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/3852604578710066272/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/how-to-initialize-array-and-how-to-copy.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3852604578710066272'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3852604578710066272'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/how-to-initialize-array-and-how-to-copy.html' title='How to initialize an Array and how to copy the array'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8761681865692156041</id><published>2010-02-10T21:56:00.000-08:00</published><updated>2010-02-10T21:57:31.419-08:00</updated><title type='text'>Type Casting in Java</title><summary type='text'>In this tutorial we are going to see how to typecast in java. Now we are going to see the syntax and sample code to convert each and every data type into other type.//Integer code1public class CastExample{public static void main(String arg[]){String s=”27”;int i=Integer.parseInt(s);System.out.println(i);Float f=99.7f;int i1=Integer.parseInt(f);}}//Integer code2public class CastExample{public </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8761681865692156041/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/type-casting-in-java.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8761681865692156041'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8761681865692156041'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/type-casting-in-java.html' title='Type Casting in Java'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-1846190722119355282</id><published>2010-02-10T21:53:00.000-08:00</published><updated>2010-02-10T21:55:10.587-08:00</updated><title type='text'>inheritance in Java</title><summary type='text'>In this tutorial we are going to see how to inherit a class. For that we simply incorporate the definition of one class into another class by using extends keyword. Now we create a superclass named parent and a subclass named child. This program displays the parent class contents, child class contents and sum of the contents.class parent{int pi,pj;void showpipj(){ System.out.println("pi and pj:"+</summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/1846190722119355282/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/inheritance-in-java.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1846190722119355282'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1846190722119355282'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/inheritance-in-java.html' title='inheritance in Java'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-8529069714514462895</id><published>2010-02-10T21:51:00.000-08:00</published><updated>2010-02-10T21:52:56.329-08:00</updated><title type='text'>cloneable in Java</title><summary type='text'>In this tutorial we are going to see use of cloneable interface and how to use it. The cloneable interface defines no members. It is used to indicate that a class allows a bitwise copy of an object to be made. If you try to call clone() on a class that does not implement Cloneable, a CloneNotSupportedException is thrown. When a clone is made the constructor for the object being cloned is not </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/8529069714514462895/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/cloneable-in-java.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8529069714514462895'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/8529069714514462895'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/cloneable-in-java.html' title='cloneable in Java'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-4767432536078414219</id><published>2010-02-10T21:49:00.000-08:00</published><updated>2010-02-10T21:50:56.364-08:00</updated><title type='text'>Java program for Associate keys with values</title><summary type='text'>In this tutorial we are going to see how to associate keys with values. Here we are going to see how to create own methods for mapping the keys with values and how to get the value using Key.public class AssociateExample{private Object[][] o;private int in;public AssociateExample(int length){o = new Object[length][2];}public void put(Object key, Object value){if (in &gt;= o.length)throw new </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/4767432536078414219/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/java-program-for-associate-keys-with.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4767432536078414219'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/4767432536078414219'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/java-program-for-associate-keys-with.html' title='Java program for Associate keys with values'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5974024484758148020</id><published>2010-02-10T21:36:00.000-08:00</published><updated>2010-02-10T21:43:28.527-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='FileWriter'/><title type='text'>FileWriter in Java</title><summary type='text'>  FileWriter creates a Writer that you can use to write to a file. Its most commonly used constructors are shown here: FileWriter(String filePath) FileWriter(String filePath, boolean append) FileWriter(File fileObj) They can throw an IOException or a SecurityException. Here, filePath is the full path name of a file, and fileObj is a File object that describes the file. If append is true, then </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5974024484758148020/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/filewriter-in-java.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5974024484758148020'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5974024484758148020'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/filewriter-in-java.html' title='FileWriter in Java'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5958788279742722758</id><published>2010-02-10T21:33:00.000-08:00</published><updated>2010-02-10T21:35:59.963-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='FileReader'/><title type='text'>FileReader in Java</title><summary type='text'>The FileReader class creates a Reader that you can use to read the contents of a file. Its two most commonly used constructors are shown here: FileReader(String filePath)FileReader(File fileObj) Either can throw a FileNotFoundException. Here, filePath is the full path name of a file, and fileObj is a File object that describes the file. The following example shows how to read lines from a file </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5958788279742722758/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/filereader-in-java.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5958788279742722758'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5958788279742722758'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/filereader-in-java.html' title='FileReader in Java'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-3660740378053578706</id><published>2010-02-10T21:23:00.000-08:00</published><updated>2010-02-10T21:30:48.503-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='ByteArrayOutputStream'/><title type='text'>Byte Array Output Stream in Java - ByteArrayOutputStream</title><summary type='text'>ByteArrayOutputStream is an implementation of an output stream that uses a byte array as the destination. ByteArrayOutputStream has two constructors, shown here: ByteArrayOutputStream( )ByteArrayOutputStream(int numBytes) In the first form, a buffer of 32 bytes is created. In the second, a buffer is created with a size equal to that specified by numBytes. The buffer is held in the protected buf </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/3660740378053578706/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/byte-array-output-stream-in-java.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3660740378053578706'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3660740378053578706'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/byte-array-output-stream-in-java.html' title='Byte Array Output Stream in Java - ByteArrayOutputStream'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-2738610469400889094</id><published>2010-02-10T21:22:00.001-08:00</published><updated>2010-02-10T21:22:53.602-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='ByteArrayOutputStream'/><title type='text'>ByteArrayOutputStream</title><summary type='text'></summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/2738610469400889094/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/bytearrayoutputstream.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2738610469400889094'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/2738610469400889094'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/bytearrayoutputstream.html' title='ByteArrayOutputStream'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-3420249997055369972</id><published>2010-02-10T21:02:00.000-08:00</published><updated>2010-02-10T21:18:49.526-08:00</updated><title type='text'>ByteArrayInputStream</title><summary type='text'>ByteArrayInputStream is an implementation of an input stream that uses a byte array as the source. This class has two constructors, each of which requires a byte array to provide the data source: ByteArrayInputStream(byte array[ ])ByteArrayInputStream(byte array[ ], int start, int numBytes) Here, array is the input source. The second constructor creates an InputStream from a subset of your byte </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/3420249997055369972/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/bytearrayinputstream.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3420249997055369972'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3420249997055369972'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/bytearrayinputstream.html' title='ByteArrayInputStream'/><author><name>Parthiban</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-3969178124884216722</id><published>2010-02-06T00:40:00.001-08:00</published><updated>2010-02-06T00:40:48.198-08:00</updated><title type='text'>What is Java I/O?</title><summary type='text'>Introduction       
The Java Input/Output (I/O) is a part of  java.io   package. The java.io package contains a relatively large number of classes that support  input and output       operations. The classes in the package are       primarily abstract classes and stream-oriented that define methods and       subclasses which allow bytes to be read from and written to files or other       input </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/3969178124884216722/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/what-is-java-io.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3969178124884216722'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3969178124884216722'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/what-is-java-io.html' title='What is Java I/O?'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-1480861657215537879</id><published>2010-02-06T00:39:00.000-08:00</published><updated>2010-02-06T00:39:50.295-08:00</updated><title type='text'>Reading Text from the Standard Input</title><summary type='text'>Standard Streams:
Standard Streams are a feature provided by many operating systems. By       default, they read input from the keyboard and write output to the       display. They also support I/O operations on files.
 Java also supports three Standard Streams:

           Standard Input: Accessed through System.in which                 is used to read input from the keyboard.
Standard Output: </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/1480861657215537879/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/reading-text-from-standard-input.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1480861657215537879'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/1480861657215537879'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/reading-text-from-standard-input.html' title='Reading Text from the Standard Input'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-5359993190772093126</id><published>2010-02-06T00:35:00.000-08:00</published><updated>2010-02-06T00:35:59.358-08:00</updated><title type='text'>Classes and Interfaces of the I/O Streams</title><summary type='text'>Classes:
  The following listing of classes are provided by the  java.io   package shown in the table:

      Class      Description   
      BufferedInputStream     It used for creating an internal buffer array. It supports       the mark and reset methods.   
      BufferedOutputStream     This class used for writes byte to output stream. It       implements a buffered output stream.   
      </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/5359993190772093126/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/classes-and-interfaces-of-io-streams.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5359993190772093126'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/5359993190772093126'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/classes-and-interfaces-of-io-streams.html' title='Classes and Interfaces of the I/O Streams'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-935817264662959278</id><published>2010-02-06T00:27:00.000-08:00</published><updated>2010-02-06T00:27:12.860-08:00</updated><title type='text'>Filter Files in Java</title><summary type='text'>Introduction The Filter File Java example code provides the following functionalities:
Filtering the files depending on the file extension provided by the user
  
User provides the file extension and then program lists all the matching     files found
Program accepts directory name and file extension from user and displays the files present in the directory.
Program begins with import statement  </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/935817264662959278/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/filter-files-in-java.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/935817264662959278'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/935817264662959278'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/filter-files-in-java.html' title='Filter Files in Java'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3380626904031146591.post-3338071438617296488</id><published>2010-02-06T00:25:00.000-08:00</published><updated>2010-02-06T00:25:58.462-08:00</updated><title type='text'>Read the File</title><summary type='text'>As we have read about  the BufferedInputStream class that lets you read characters from a stream and stores it in an internal buffer. Lets see an example that reads the contains of the existed file.
The given example uses the BufferedInputstream       class that reads the bytes from the input stream. The input stream is a       file "Filterfile.txt" from which the data is read in form       of a </summary><link rel='replies' type='application/atom+xml' href='http://javasefx.blogspot.com/feeds/3338071438617296488/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://javasefx.blogspot.com/2010/02/read-file_06.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3338071438617296488'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3380626904031146591/posts/default/3338071438617296488'/><link rel='alternate' type='text/html' href='http://javasefx.blogspot.com/2010/02/read-file_06.html' title='Read the File'/><author><name>Mayuri Multimedia</name><uri>http://www.blogger.com/profile/08558885521070571106</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>
