-
SQL Server 2008 R2 – Cannot Connect to Server
I just post this article for someone who is facing following issue. it can be easily resolved with following steps. 1) Please go…
-
SQL Ordinal Number function
I wiold like to share with you about follwon Ordinal Number function script which include an integer input parameter. SET ANSI_NULLS ON…
-
Teach Yourself SQL in 24 Hours
Thorough explanation of database concepts, SQL and low level programming Complete code listings with output. We just share and index…
-
SQL SchemaDiff (Compare Database Schemas)
Use MSSQL Schema Diff to compare database schemas. It quickly and easily locates structural differences between two SQL Server databases.…
-
SQL Database Schema Comparison Tool for SQL Server 2005/2008
Open DBDiff is an open source database schema comparison tool for SQL Server 2005/2008. It reports differences between two database…
-
SQL Database Comparison tool
Just a share with you all for database comparer whcih is a powerful and easy to use database comparison tool.…
-
SQL Server Database Copy Tool
Today, we found the SQL Server Database Copy Tool project on codeplex when googling. It is a nice tool for…
-
SQL Update one table comparing info from two tables
Example #1 (Using sub query info & exists) UPDATE T1 A SET A.OLDNAME = A.NAME, A.NAME = ( SELECT B.NAME…
-
SQL – Rename a database
To rename a database. 1- Connect to the Database Engine. 2- From the Statndard bar, click New Query. 3- Copy…
-
Pro SQL Server 2012 Reporting Services, 3rd edition
Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost.…
