http://netvouz.com/kapluni/tag/sql?feed=rss kapluni's bookmarks tagged "sql" on Netvouz http://www.apexsql.com/sql_tools_diff.asp SQL Tools for Auditing, Comparison, Recovery and more kapluni Tue, 29 Aug 2006 22:15:12 GMT http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1161826,00.html kapluni Fri, 13 Apr 2007 14:14:38 GMT http://msdn2.microsoft.com/en-us/library/ms187928.aspx kapluni Thu, 12 Oct 2006 20:48:01 GMT http://www.adeptsql.com/ kapluni Tue, 29 Aug 2006 22:15:44 GMT http://www.microsoft.com/downloads/details.aspx?FamilyID=1d3a4a0d-7e0c-4730-8204-e419218c1efc&DisplayLang=en SQL Server 2005 Performance Dashboard Reports kapluni Tue, 23 Oct 2007 13:56:40 GMT http://www.informit.com/articles/article.asp?p=353737&seqNum=2&rl=1 kapluni Tue, 29 Aug 2006 22:17:46 GMT http://josql.sourceforge.net/ SQL for Java Objects kapluni Tue, 04 Dec 2007 18:25:46 GMT http://msdn2.microsoft.com/en-us/library/ms345522.aspx kapluni Thu, 28 Sep 2006 15:42:39 GMT http://www.sqleffects.com/ kapluni Tue, 29 Aug 2006 22:19:38 GMT http://www.free-cgi.com/freecgi/reference/sqlref.php SQL Quick Reference Guide Statements SELECT [ DISTINCT ] * | LIST OF COLUMNS, FUNCTIONS, CONSTANTS FROM LIST OF TABLES OR VIEWS [ WHERE CONDITION(S) ] [ ORDER BY ORDERING COLUMN(S) [ ASC | DESC ] ] [ GROUP BY GROUPING COLUMN(S) ] [ HAVING CONDITION(S) ] DELETE FROM TABLE NAME [ WHERE CONDITION(S) ] INSERT INTO TABLE NAME [ (COLUMN LIST) ] VALUES (VALUE LIST) UPDATE TABLE NAME SET COLUMN NAME = VALUE [ WHERE CONDITION ] Functions Function Purpose SUM Total of the values in a field. AVG Average of the values in a field. MIN Lowest value in a field. MAX Highest value in a field. COUNT Number of values in a field, not counting Null (blank) values. Predicates Predicate Description BETWEEN ... AND Compares a value to a range kapluni Thu, 04 Oct 2007 16:30:53 GMT