This tutorial deeply covers the SELECT statement of the T-SQL/SQL language. Starts from the basics – how to retrieve the values inside a column to ordering data, selecting multiple columns and then tables, joining them…
What is the Connection String for Connecting to a SQL Server 2005 Database?
The connection string needed for connecting to a SQL Server 2005 database (code name Yukon) is as follows: Where LOCALHOST\LOCAL is your SQL server address and LOCAL is the instance of the SQL Server (which can be named anything, but by default it is LOCAL).This normally works if you have the application that connects to […]
How to Convert Cursor into While Loop In SqlServer
This article is about how we can change the cursor in the while loop in SQL Server. It’s very useful in improving the performance of stored procedures.
Connecting to a SQL database from ASP.NET I
This is part I of the tutorial that teaches you how to connect to a SQL database from ASP .NET using SQL Authentication. This part shows you how to set up MSDE for Mixed Mode and how to use Web Data Administrator to create databases and users.
Getting data on a table in SQL
How to retrieve some information using SQL on any table in a database on SQL-Server 2K.
How to Upgrade from MySQL v 3.x to MySQL 4.x
This tutorial will walk you through step by step to upgrade your MySQL database to version 4.x on a Windows Machine. I am going to assume to that you already have MySQL version 3.x or earlier installed on your Windows machine.
Setting up MS SQL Server 2000
This guide will show you how to install the Microsoft SQL Server Desktop Engine 2000A for your localhost server.