Knowledge Hub

 

SQL Server - Linked Server Between SQL Server 2012 and SQL Server 2000

SQL Server - Linked Server Between SQL Server 2012 and SQL Server 2000

One of the biggest benefits of Linked Servers is the fact that you can jump SQL version, allowing your system to access data from a legacy system using an older version of SQL Server. Unfortunately though, since the launch of SQL Server 2012, SQL Server now uses a new and improved native client that no longer supports anything further back than SQL Server 2005. For some this may stop companies upgrading to the later versions of SQL Server, but hold on, not all is lost. There is a work around, and the best of it is, is that it’s an ‘easy fix’... Read on to find out more...

SQL Server Tips: SQL CRUD

SQL Server Tips: SQL CRUD

CRUD? Create Read Update Delete – CRUD. This term refers to the four general actions that can be taken when it comes to data. This is a global term and does not just apply to databases (although it will be databases where you hear it the most). In SQL we use the INSERT command for creating data, SELECT to read, UPDATE to update and DELETE to delete.

SQL Server Tips: Primary Keys, Foreign Keys and Indexes

SQL Server Tips: Primary Keys, Foreign Keys and Indexes

When it comes to retrieving data from your tables, indexes play a fundamental role in finding that data you require and finding it fast. Pretty much every table you create will have an index of one type or another; whether it is a regular index, a primary key or a foreign key.

Previous

Navigation

Social Media