SQL Tips and Tricks Archives - Page 244 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – Technology and Online Learning – Personal Technology Tip

December 7, 2012

This is the fourth post in my series about Personal Technology Tips and Tricks, and I knew exactly what I wanted to write about. But at first I was conflicted. Is online learning really a personal tip? Is it really a trick that no one knows? However, I have decided…

SQL SERVER – Caption the Cartoon Contest – Last 2 Days

December 6, 2012

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Developer’s life is very interesting, we often want to start my day early at a job so we can go home early. However, the day never comes as the life of the developer is always about working late hours. If the developer goes to the office early – there are…

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

December 5, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see…

SQL SERVER – Fix: Error : 402 The data types ntext and varchar are incompatible in the equal to operator

December 4, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Some errors are very simple to understand but the solution of the same is not easy to figure out. Here is one of the similar errors where it clearly suggests where the problem is but does not tell what is the solution. Additionally, there are multiple solutions so developers often…

SQL SERVER – Fix Error: Microsoft OLE DB Provider for SQL Server error ‘80040e07’ or Microsoft SQL Native Client error ‘80040e07’

December 3, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Error Messages

I quite often receive questions where users are looking for solution to following error: Microsoft OLE DB Provider for SQL Server error ‘80040e07’ Syntax error converting datetime from character string. OR Microsoft SQL Native Client error ‘80040e07’ Syntax error converting datetime from character string. If you have ever faced above…

SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies

December 2, 2012

Pinal Dave

SQL Tips and Tricks

SQL DMV, SQL Scripts, SQL Server, SQL Utility

Let us learn in this blog about sys.sql_expression_dependencies.

A very common question which I often receive are:

How do I find all the tables used in a particular stored procedure?

How do I know which stored procedures are using a particular table?

SQL SERVER – Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL

November 30, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, sqlcmd

In one of the virtual environment while I was trying to add SQL Server Database (.mdf) file to asp.net project I encountered following error: Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: …