SQL Server Posts

SQL

Import Microsoft Access .accdb File to MS SQL Server

Mark Holmes • February 5, 2014

These steps are for exporting an .accdb file if it cannot be viewed as a table. This may be needed if the data file was generated by a Microsoft Access form. If the desired file can…

Read More

SQL

SQL Server Error 3154

Tim Barsness • July 16, 2009

I ran accross the SQL Server error 3154. In SQL Server 2008, it says “Restore Failed for Server ‘ServerName\InstanceName’” Additional Information: “System.Data.SQLClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbname’…

Read More

SQL

Escaping Single Quotes in MS SQL Server (T-SQL)

Tim Barsness • June 2, 2009

Escaping single quotes (‘) in Transact-SQL is done by replacing the single quote with two single quotes. So: SELECT ‘I went to Kinko”s’ Returns “I went to Kinko’s” The only case where two consecutive single quotes…

Read More