Tag: sql server


Installing SQL Server

By Michael D. Reilly – If you're a Windows 2000 or Windows NT 4.0 systems administrator who has been assigned the task of managing a Microsoft SQL Server system, you might be concerned about how you're going to carry out your new responsibilities. Fortunately, administering SQL Server 2000 a


Stored Procedures

The use of stored procedures is the one area where the Command object comes into its own. A stored procedure (or stored query as it’s sometimes called) is a predefined SQL query stored on the database. So why should we create and use a stored procedure instead of just creating a SQL string on the fl