SQL Server Saving Changes not Permitted
In SQL Server you may get the message “Saving changes is not permitted. The change you have made […]
Database
SQL Server Logical Query
As a SQL Server practitioner, it is important to understand logical query processing. The following list is found […]
SQL Server Exists Predicate
The term “predicate” is used to refer to an expression that determines whether something is true or false. […]
SQL Server Searching for Words
This post discusses the query you will need to be able to search inside a column in a […]
Sample Relational Databases
You can use existing databases for testing purposes. If you are testing queries or just wanting a sample […]
SQL Server Functions
This post describes how you can create a user-defined function in SQL Server. We will start off with […]
SQL Server SELECT TOP into variable
You need to select the TOP 1 into a variable in SQL Server. In other words you need […]
SQL Joins using Geographic Data
In this post we illustrate SQL joins using a common example of geographic data in a Microsoft Access […]
SQL Server Insert Into Select Part 2
This post shows you how to insert data into an existing empty table from two other tables using […]
SQL Server Changing Table Structure
The table structure refers to the columns in the table. We can use T-SQL to add a new […]
SQL Server Union Sorted
This post discusses how you can take a table with a single column of data and add a […]
SQL Server GUID
In SQL Server we can use GUIDs. A GUID is a 128 bit number to identify objects. It […]