DevX

SQL injection is probably the most common and easiest hacking technique out there. Now, don’t think I condone it, I’m

SQL injection is probably the most common and easiest hacking technique out there. Now, don’t think I condone it, I’m

Regional Settings, especially dates, are always a problem in code. For example, suppose your product is developed in the U.S.

The Hijri calendar system is somewhat different from the Gregorian calendar. This example does not discuss the complete Hijri calendar.

Avoid prefixing your Stored Procedure names with sp_. SQL Server first checks in the master database even when the Schema

Avoid using NOT IN whilst comparing nullable columns. Use NOT EXISTS instead. When NOT IN is used in a query,

It is best to avoid using the * operator in your queries, use explicit column names instead. SQL Server scans

In order to improve your queries’ performance, you should always include the owner or schema name of an object by