Tag Archives: SQL

Quick reference for different SQL Joins

                  source: Visual Representation of SQL Joins from codeproject.com

Posted in SQL, SQL Server | Tagged , , | Leave a comment

How To Check For Full SubStrings In A Comma Separated String

22/07/2013 How to avoid detecting substrings, how to check for perfect substrings, avoid detecting substrings, avoid detecting substrings when checked for substrings. Today I needed to find if a string is contained within a string. So I used the most straight forward … Continue reading

Posted in Algorithms & Concepts, Software Engineering Concepts | Tagged , , | Leave a comment

ILT – How To Change SQL Server Default Database?

16-10-2012 I have been annoyed by having to change the database from the available databases drop-down whenever I want to write a query. This was because the default database which is always selected was the “Master” database which I never … Continue reading

Posted in Social Science, SQL Server | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

Is Order Of OleDbCommand.Parameters Important

01-08-2012 The order of the parameters collection of an OleDbCommand must match the order to which those parameters appear in the SQL statement. Otherwise the .net framework will try to fill the parameters in your SQL statement according to the … Continue reading

Posted in C#.Net, Microsoft Access | Tagged , , , , , , , , , , | Leave a comment

Where Vs Having In SQL

21-05-2012 The Having clause can only be used when you are using the group by phrase. When you are using the Group By phrase in a query, you can use the Having clause for pretty much everything you can do … Continue reading

Posted in Database-Concepts, Oracle, SQL Server | Tagged , , , | Leave a comment

How To Check For NULL Values Correctly In SQL

Posted in Database-Concepts, Oracle, SQL Server | Tagged , , , | Leave a comment

Using TimeStamp columns to keep track of database record versions

2011-10-07 Timestamp is a value that is incremented by the database whenever an insert or update operation is performed. Even though the name Timestamp could be a bit misleading, this value has no relevance to a clock related time. This … Continue reading

Posted in Database-Concepts, SQL Server | Tagged , , , , , , , , | Leave a comment

How to use (escape) single quotation mark in sql statements

06-10-2011 We all get that day when we get an exception complaining about the single quotation or apostrophe that was in our SQL statement. The best advisable thing to do is to use stored procedures so that all data are … Continue reading

Posted in SQL Server | Tagged , , , , | Leave a comment

How to auto save the data table in memory into database?

2010-04-01 We frequently get to fetch data from the database, update them and then write them back to the database. Most of the time we only have to write them back as individual records. How about updating a whole database table in the … Continue reading

Posted in C#.Net | Tagged , , , , , , , | Leave a comment

D LINQ : How to Map Columns Which Auto Generate Values At the Database

2009-05-11 I have being working on a software application made on .Net and recently my client asked me to use D LINQ instead of SQL. D LINQ has great benefits loaded! As I started working with DLINQ I started to … Continue reading

Posted in C#.Net | Tagged , , , , , , , , , , , , , , , | Leave a comment