K
Kareninstructor
Guest
When learning to work with SQL-Server one challenge is to find a decent relational database which is populated with data along with sample SQL statements.
Microsoft has several were one of the popular is NorthWind which has several problems which is it's not fully relational and one table has a space in the name which is unwise as there is nothing to gain.
Here is a updated version which I updated from the original.
Full script to create and populate.
Start SQL SELECT
To create the database, use SSMS (SQL-Server Management Studio)
Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
NuGet BaseConnectionLibrary for database connections.
StackOverFlow
Continue reading...
Microsoft has several were one of the popular is NorthWind which has several problems which is it's not fully relational and one table has a space in the name which is unwise as there is nothing to gain.
Here is a updated version which I updated from the original.
Full script to create and populate.
Start SQL SELECT
To create the database, use SSMS (SQL-Server Management Studio)
Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
NuGet BaseConnectionLibrary for database connections.
StackOverFlow
Continue reading...