SQL Explained

A short explanation and infographic of what SQL is. For the non-SQL people in your life.

10 SQL Snippets For Faster, More Effective Code

How many hours per week do you spend writing the same SQL again and again?

Size of nvarchar(max)??

Converting to data-driven code

How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs

Data Mining Part 24: SQL Profiler and Data Mining

In this chapter we will detect the Data Mining activity using SQL Server Profiler.

Data Mining Part 24: SQL Profiler and Data Mining

In this chapter we will detect the Data Mining activity using SQL Server Profiler.

RE: Using parameter for different databases

Check this out for a better way out : Dynamic database

RE: MSAccess delete query

Thank you so much. Now it's work.

RE: SQL Error. Help!!

I need SQL pdf books///Please let me know... 

RE: Problem Trapping Alter Database Stmt

The formatting's all off so your post is one long line... however, if you want to check if your code is successful then @@ERROR should return 0. If you have several statements in your proc, it's always good practice to capture this in a local variable.