Lesson 1:SQL Server Programming Tools

3 4

SQL Server 2000 provides a set of tools that enable you to use Transact-SQL to interact with SQL databases and their data. This set of tools includes SQL Query Analyzer and the isqlw, isql, and osql command-prompt utilities. In this lesson, you will be introduced to each of these tools and provided with an overview of how and when these tools are used. In the lessons that follow, you will learn how to work with Transact-SQL in order to manage SQL Server databases and their data.

NOTE


In our discussion of Transact-SQL, you will be exposed to various database objects and to the process of querying a database and modifying objects and data within the database. For example, you will be introduced to Transact-SQL statements that enable you to create tables, execute queries, and update data. The purpose of this chapter, however, is to introduce you to using Transact-SQL in a SQL Server database. More detailed information about the various components of a database and advanced querying techniques will be provided in subsequent chapters.


After this lesson, you will be able to:

  • Describe SQL Query Analyzer and the isqlw, isql, and osql command-prompt utilities.
  • Navigate SQL Query Analyzer, including the query window, the Transact-SQL Debugger window, and the Open Table window.
  • Run a simple query and view the result set of that query, as well as view the execution plan, trace information, statistical information, and messages that are specific to the executed query.

Estimated lesson time: 30 minutes


SQL Query Analyzer

SQL Query Analyzer is a graphical user interface (GUI) that enables you to design, test, and execute Transact-SQL statements, stored procedures, batches, and scripts interactively. You can run SQL Query Analyzer from inside SQL Enterprise Manager or run it directly from the Start menu. You can also launch SQL Query Analyzer from the command prompt by executing the isqlw utility. (The isqlw utility is discussed in more detail later in this lesson.)

NOTE


SQL Query Analyzer is the primary tool that you will use to run Transact-SQL statements in the exercises in this training kit, and it is one of the main tools available in SQL Server to manage database objects and the data within those objects. In addition to performing the exercise in this lesson, you should spend enough time navigating the SQL Query Analyzer interface and reviewing SQL Server Books Online to feel completely comfortable with using this tool.

figure 2.1-sql query analyzer displaying the query window on the right and the object browser window on the left.

Figure 2.1 SQL Query Analyzer displaying the Query window on the right and the Object Browser window on the left.

The functionality within SQL Query Analyzer can be described in terms of the interface layout. SQL Query Analyzer includes a number of windows, dialog boxes, and wizards that help you to perform the tasks necessary to manage SQL Server databases and the data stored within those databases. This section discusses many of these interface objects and the functions that can be performed when you access them. For more details about any of the objects that are discussed here or any objects within the interface, refer to SQL Server Books Online.

When you launch SQL Query Analyzer, the Connect To SQL Server dialog box appears. You must specify which instance of SQL Server that you want to access and which type of authentication to use when connecting to the database. Once you have entered the appropriate information in the Connect To SQL Server dialog box and then clicked OK, SQL Query Analyzer appears and displays the Query window and the Object Browser window, as shown in Figure 2.1.

NOTE


The Object Browser window is displayed by default the first time that you use SQL Query Analyzer. If the Object Browser window was not left open when SQL Query Analyzer was last shut down, the Object Browser window will not appear when you open SQL Query Analyzer.

Query Window

The Query window is divided into two panes: The Editor pane and the Results pane. When you first open SQL Query Analyzer, only the Editor pane appears, as shown in Figure 2.1. The Results pane appears automatically when you run a Transact-SQL query. You can also open and close the Results pane manually by clicking the Show Results Pane button on the toolbar.

You can customize the window and control the behavior of the Editor pane and the Results pane. The Options dialog box, which you can access from the Tools menu, enables you to control the look and behavior of the Query window. In addition, you can specify which fonts are used for text in the window and you can change the relative size of the Editor pane and the Results pane by dragging the split bar up and down. You can also scroll through the panes (up and down or left and right) as necessary.

Editor Pane

The Editor pane is a text-editing window used to enter and execute Transact-SQL statements. You can use one of the following methods to enter code in the Editor pane:

  • Type SQL statements directly in the Editor pane.
  • Open a saved SQL script. The contents are displayed in the Editor pane, where they can be edited.
  • Open a template file. The contents are displayed in the Editor pane, where they can be edited.
  • Use the scripting features of Object Browser to copy SQL statements for the selected database object into the Editor pane.

The Editor pane in SQL Query Analyzer provides various tools to help you create and edit Transact-SQL statements, including the standard editing commands Undo, Cut, Copy, Paste, and Select All. You can also find and replace text, move the input cursor to a particular line, insert and remove indentation, force case, and insert and remove comment marks.

In addition, you can view Transact-SQL reference topics at SQL Server Books Online and copy the syntax example from the reference into the Editor pane, in order to help create a Transact-SQL statement. You can also save query definitions and other SQL scripts for reuse, and you can create templates (which are boilerplate scripts for creating objects in a database).

Color Coding in Query Analyzer

The code entered in the Editor pane is colored by category. The following table lists the default colors and what they indicate:

Color Category
Red Character string
Dark red Stored procedure
Green System table
Dark green Comment
Magenta System function
Blue Keyword
Gray Operator

NOTE


You can change these default color settings by selecting the Fonts tab on the Options dialog box.

You should use the color coding as a guide to help eliminate errors in your Transact-SQL statements. For example, if you type a keyword and it is not displayed in blue (assuming that you retained the default settings), the keyword might be misspelled or incorrect. Or, if too much of your code is displayed in red, you might have omitted the closing quotation mark for a character string.

Executing Transact-SQL Statements

You can either execute a complete script or only selected SQL statements in SQL Query Analyzer:

  • Execute a complete script by creating or opening the script in the Editor pane and then pressing F5.
  • Execute only selected SQL statements by highlighting the lines of code in the Editor pane and then pressing F5.

When executing a stored procedure in the Editor pane, enter the statement to execute the stored procedure and then press F5. If the statement that executes the procedure is the first in the batch, you can omit the EXECUTE (or EXEC) statement; otherwise, EXECUTE is required.

Results Pane

When you execute a Transact-SQL statement, the query output (result set) is displayed in the Results pane. The Results pane can include a variety of tabs. The options that you select in the interface determine which tabs are displayed. By default, only the Grids tab, which is the active tab, and the Messages tab are displayed.

Grids Tab

The Grids tab displays the result set in a grid format, as shown in Figure 2.2. The grid format is displayed much like a table and enables you to select individual cells, columns, or rows from the result set.

figure 2.2-grids tab displaying the result set generated by the executing transact-sql statement.

Figure 2.2 Grids tab displaying the result set generated by the executing Transact-SQL statement.

The Grids tab is always accompanied by the Messages tab, which displays messages relative to the specific query.

Results Tab

The Results tab, like the Grids tab, displays the result set generated by executing a Transact-SQL statement. In the Results tab, however, the result set is displayed as text (refer to Figure 2.3), rather than in a grid format.

figure 2.3-results tab displaying the result set generated by executing a transact-sql statement.

Figure 2.3 Results tab displaying the result set generated by executing a Transact-SQL statement.

The Messages tab is not displayed when the Results tab is used. Any messages pertinent to the query that has been executed are displayed in the Results tab after the result set (unless the query generated an error, in which case the Results tab contains only the error message).

You can display either the Results tab or the Grids tab, but not both. Because the Grids tab is displayed by default, you must configure SQL Query Analyzer to display the Results tab. The Results tab is then used to return queries until the end of the session or until you reconfigure SQL Query Analyzer to display the result set in the Grids tab. After you close SQL Query Analyzer and then restart it, the Grids tab will again appear in the Results pane.

To set up SQL Query Analyzer to display the Results tab, select the Execute Mode button on the toolbar, then select Results In Text. The result set from the next query that you run will be displayed in the Results tab until you select the Results In Grid option or you restart SQL Query Analyzer.

NOTE


You can also have the result set sent to a file, rather than to the Grids tab or to the Results tab. To send a result set to a file, select the Execute Mode button on the toolbar and then select Results To File. You will be prompted for a filename and a folder in which to store the file.

Execution Plan Tab

An important feature of SQL Query Analyzer is its set of tools that help you analyze your queries in order to ensure optimal performance. One of these tools is the Execution Plan tab of the Results pane. The Execution Plan tab displays a graphical representation of the execution plan that is used to execute the current query. The display uses icons to represent the execution of specific statements and queries, rather than the tabular representation produced by the SET SHOWPLAN_ALL or SET SHOWPLAN_TXT statements. Figure 2.4 shows what this graphical representation looks like when you execute a simple SELECT statement.

figure 2.4-execution plan tab displaying a graphical representation of the executed transact-sql statement.

Figure 2.4  Execution Plan tab displaying a graphical representation of the executed Transact-SQL statement.

By default, the Execution Plan tab is not displayed in the Results pane. To display the Execution Plan tab, select the Execute Mode button on the toolbar, then select Show Execution Plan. The next time you execute a query, the Execution Plan tab will be available—and it will show the graphical representation of the execution plan for that query. The tab will be available until you deselect the Show Execution Plan option or until you close SQL Query Analyzer.

Trace Tab

The Trace tab, like the Execution Plan tab, can assist you with analyzing your queries. The Trace tab displays server trace information about the event class, subclass, integer data, text data, database ID, duration, start time, reads and writes, and Central Processing Unit (CPU) usage, as shown in Figure 2.5. The Trace tab provides information that you can use to determine the server-side impact of a query.

figure 2.5-trace tab displaying server trace information about the executed transact-sql statement.

Figure 2.5  Trace tab displaying server trace information about the executed Transact-SQL statement.

By default, the Trace tab is not displayed in the Results pane. To display the Trace tab, select the Execute Mode button on the toolbar, then select Show Server Trace. The next time you execute a query, the Trace tab will be available, and it will show the server trace information. The tab will be available until you deselect the Show Server Trace option or until you close SQL Query Analyzer.

Statistics Tab

The Statistics tab provides detailed information about client-side statistics for execution of the query. The output result set displays the name of the counter, the value of the counter, and a running average from the beginning of the connection or since the last manual reset. Figure 2.6 shows the statistics that are generated after running a simple SELECT statement.

figure 2.6-statistics tab displaying statistics information about the executed transact-sql statement.

Figure 2.6  Statistics tab displaying statistics information about the executed Transact-SQL statement.

The statistics include three groups of counters: Application Profile, Network, and Time. The statistics are displayed only when a query result is generated.

By default, the Statistics tab is not displayed in the Results pane. To display the Statistics tab, select the Execute Mode button on the toolbar, then select Show Client Statistics. The next time you execute a query, the Statistics tab will be available, and it will show the client statistics information. The tab will be available until you deselect the Show Client Statistics option or until you close SQL Query Analyzer.

Messages Tab

The Messages tab displays messages about the Transact-SQL statement that you executed (or that you tried to execute). If the query ran successfully, the message will include the number of rows returned, as shown in Figure 2.7, or it will state that the command has completed successfully. If the query did not run successfully, the Messages tab will contain an error message identifying why the query attempt was unsuccessful.

The Messages tab is available in the Results pane only if the Grids tab is displayed. If the Results tab is displayed, messages appear in that tab.

figure 2.7-the messages tab displaying a message about the executed transact-sql statement.

Figure 2.7  The Messages tab displaying a message about the executed Transact-SQL statement.

Estimated Execution Plan Tab

The Estimated Execution Plan tab displays information about the execution plan that would be used for a particular query if that query were executed. Like the Execution Plan tab, the display uses icons to represent the execution of specific statements and queries. Figure 2.8 shows the estimated execution plan for a simple SELECT query. If you were to scroll down the Results pane, you would see a graphical representation similar to what you would see on the Execution Plan tab if this query were executed.

figure 2.8-estimated execution plan tab displaying information about the execution plan for a transact-sql statement.

Figure 2.8  Estimated Execution Plan Tab displaying information about the execution plan for a Transact-SQL statement.

Object Browser Window

Object Browser is a tree-based tool used to navigate among the objects in a database. In addition to navigation, Object Browser offers object scripting, stored procedure execution, and access to table and view objects.

The Object Browser window contains two tabs:

  • Objects tab.  Lists objects within a database and lists common objects, such as built-in functions and base data types.
  • Templates tab.  Provides access to the Templates folder.

Transact-SQL Debugger Window

SQL Query Analyzer comes equipped with a Transact-SQL debugger that enables you to control and monitor the execution of stored procedures. The debugger supports traditional functions, such as setting breakpoints, defining watch expressions, and single-stepping through procedures.

The Transact-SQL debugger in SQL Query Analyzer supports debugging against SQL Server 2000, SQL Server 7.0, and SQL Server 6.5 Service Pack 2.

NOTE


It is not advisable to use the Transact-SQL debugger on a production server. While in step-execution mode, the debugger can lock certain system resources that are needed by other processes.

You can run Transact-SQL Debugger only from within SQL Query Analyzer. Once started, the debugging interface occupies a window within that application, as shown in Figure 2.9.

figure 2.9-transact-sql debugger window showing the result of debugging the custorderhist stored procedure in the northwind database.

Figure 2.9  Transact-SQL Debugger window showing the result of debugging the CustOrderHist stored procedure in the Northwind database.

When the Transact-SQL Debugger starts, a dialog box appears prompting you to set the values of input parameter variables. It is not mandatory for these values to be set at this time. You will have the opportunity to make modifications once the Transact-SQL Debugger window appears. In the dialog box, click Execute to continue with your session.

NOTE


SQL Query Analyzer does not support multiple instances of the debugger. If you attempt to debug a second stored procedure, SQL Query Analyzer will prompt you to cancel the currently active debugging session.

Due to connection constraints, it is not possible to create a new query while the debugger window is in the foreground. To create a new query, either bring an existing query window to the foreground or open a new connection to the database.

The Transact-SQL Debugger window consists of a toolbar, a status bar, and a series of window panes. Many of these components have dual purposes, serving as both control and monitoring mechanisms.

Only limited functionality might be available from some of these components after a procedure has been completed or aborted. For example, you cannot set breakpoints or scroll between entries in either of the variable windows when the procedure is not running.

Open Table Window

The Open Table window displays the columns and rows from a table in a grid. You can modify the data in the grid, and you can also insert and delete rows. Figure 2.10 shows the contents of the Customers table in the Northwind database.

figure 2.10-open table window displaying the contents of the customers table in the northwind database.

Figure 2.10  Open Table window displaying the contents of the Customers table in the Northwind database.

Object Search Window

The Object Search window helps you to find objects in the current database server. Object Search is accessible through a button on the toolbar and through the Object Search command on the Tools menu. Figure 2.11 shows the result of searching for all user table objects in the Northwind database.

figure 2.11-object search window displaying the result of an object search of the northwind database.

Figure 2.11  Object Search window displaying the result of an object search of the Northwind database.

isqlw Command-Prompt Utility

The isqlw utility (SQL Query Analyzer) enables you to enter Transact-SQL statements, system stored procedures, and script files. You can set up a shortcut or create a batch file to launch a pre-configured SQL Query Analyzer.

You can use the isqlw utility with or without a user interface. To run isqlw without a user interface, specify valid login information (an instance of SQL Server 2000 with a trusted connection or a valid login ID and password) and input and output files. The isqlw utility executes the contents of the input file and saves the result in the output file.

If input and output files are not specified, isqlw runs interactively (starting the SQL Query Analyzer). If valid login information is specified, isqlw connects directly to an instance of SQL Server 2000. If the information specified is insufficient for a connection, the Connect To SQL Server dialog box appears.

The isqlw utility and SQL Query Analyzer use the Open Database Connectivity (ODBC) application programming interface (API), which uses the SQL Server ODBC driver default settings for SQL-92.

isql Command Prompt Utility

The isql utility enables you to enter Transact-SQL statements, system procedures, and script files. The utility uses DB-Library to communicate with SQL Server 2000.

Like most DB-Library applications, the isql utility does not set any connection options by default. You must issue SET statements interactively or in scripts if you want to use specific connection option settings.

The isql utility is started directly from the operating system, along with case-sensitive switches. After starting, isql accepts Transact-SQL statements and sends them to SQL Server 2000 interactively. The results are formatted and printed on the standard output device (the screen). Use QUIT or EXIT to exit from isql.

If you do not specify a username when you start isql, SQL Server 2000 checks for the environment variables and uses those. For example, isqluser=(user) or isqlserver=(server) would apply. If no environment variables are set, the workstation username is used. If you do not specify a server, the name of the workstation is used.

If neither the -U nor -P options are used, SQL Server 2000 attempts to connect by using Windows Authentication mode. Authentication is based on the Windows account of the user who is running isql. The results are printed once at the end of execution. With isql, there is a limit of 1,000 characters per line. Large statements should be spread across multiple lines.

osql Command-Prompt Utility

The osql utility enables you to enter Transact-SQL statements, system procedures, and script files. This utility uses ODBC to communicate with the server.

The osql utility is started directly from the operating system with the case-sensitive options listed previously. After osql starts, it accepts SQL statements and sends them to SQL Server interactively. The results are formatted and displayed on the screen. Use QUIT or EXIT to exit from osql.

Like the isql command-prompt utility, if you do not specify a username when you start osql, SQL Server 2000 checks for the environment variables and uses those. The osql utility uses the ODBC API, as well as the SQL Server ODBC driver default settings for the SQL Server 2000 SQL-92 connection options.

Exercise 1:  Navigating SQL Query Analyzer and Running a Query

In this exercise, you will navigate through SQL Query Analyzer, execute a Transact-SQL statement, and then view the result of that query. To perform this exercise, you should be logged into your Windows 2000 Server computer as Administrator.

NOTE


When you installed SQL Server 2000, the Northwind sample database was also installed. The Northwind database contains the sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world. You will use this database for many of the exercises in this training kit.

To open SQL Query Analyzer

  1. On the Start menu, point to Programs, then Microsoft SQL Server, and then click Query Analyzer.

As SQL Query Analyzer starts to open, the Connect To SQL Server dialog box appears.

  1. In the SQL Server drop-down list, select Local. If Local is not listed, click the ellipsis button to browse for the local computer (the computer on which you are working).
  2. Verify that the Windows Authentication radio button is selected.
  3. Click OK.

The SQL Query Analyzer interface appears and displays two windows: the Object Browser window and the Query Window.

NOTE


The Object Browser window is displayed by default the first time that you use SQL Query Analyzer. If you have opened SQL Query Analyzer previously and the Object Browser window was not left open when SQL Query Analyzer was last shut down, the Object Browser window will not appear when you open SQL Query Analyzer.

  1. If the Object Browser window did not appear, click the Object Browser button on the toolbar.

The Object Browser window appears.

To size SQL Query Analyzer Windows

  1. Size SQL Query Analyzer as well as the Object Browser window and the Query window so that you can easily view the features within the interface.
  2. Click the Show Results Pane button on the toolbar.

The Query window is now divided into two panes: the Editor pane and the Results pane.

  1. Position your mouse over the split bar between the two panes and resize them.

To configure the SQL Query Analyzer Results Pane

  1. Click the Show Results Pane button on the toolbar.

The Results pane disappears, and the Editor pane fills the Query window.

  1. On the toolbar, click the Execute Mode button and then click Show Execution Plan.
  2. On the toolbar, click the Execute Mode button and then view the listed options.

Notice that the Results In Grid option and the Show Execution Plan option are both checked. The Results In Grid option is checked by default. The options listed beneath the Execute Mode button affect how a query result is displayed and affect what information is displayed.

  1. Click the Show Server Trace option.
  2. On the toolbar, click the Execute Mode button and then click Show Client Statistics.

To search for an object in the database

  1. On the toolbar, click the Object Search button.

The Object Search window appears.

  1. From the Database drop-down list box, select Northwind.
  2. In the All Object Types section, verify that the User Table check box is selected, then select the System Table check box.
  3. Click Find Now.

The search result appears at the bottom of the Object Search window. Notice that all entries in the db name column are listed as Northwind and that all entries in the object type column are listed as either user table or system table.

  1. Close the Object Search window.

To view a table's contents

  1. In the Object Browser window, expand Northwind and then expand User Tables.
  2. Right-click dbo.Employees and then select Open.

The Open Table window appears, listing the contents of the Employees table in the Northwind database.

  1. Scroll through the Open Table window to view the contents.
  2. Close the Open Table window.

To debug a stored procedure

  1. In the Object Browser window, expand Northwind, and then expand Stored Procedures.
  2. Right-click dbo.CustOrderHist, then click Debug.

The Debug Procedure dialog box appears.

  1. Click Execute.

The Transact-SQL Debugger window appears as the debugging operation is executed against the CustOrderHist stored procedure in the Northwind database. An error message is displayed in the bottom pane indicating that the @CustomerID parameter needs to be supplied for this stored procedure to run.

  1. View the result of the debugging operation.
  2. Close the Transact-SQL Debugger window.
  3. Close the Object Browser window.

The Editor pane of the Query window should now be the only window displayed.

To execute a SELECT statement

  1. In the Editor pane of the Query window, enter the following Transact-SQL statement:
 USE northwind SELECT * FROM customers 

Notice that the USE, SELECT, and FROM all appear in blue on the screen to show that they are Transact-SQL keywords. The USE keyword changes the database context to the specified database.

  1. Click the Execute Query button on the toolbar to start the query.

The Results pane appears and displays the query result set on the Grids tab. Notice that there are four other tabs: Execution Plan, Trace, Statistics, and Messages. The Messages tab is available by default when the Grids tab is displayed. The other tabs are optional and appear now because you configured the Execute Mode options previously in this exercise.

To view query results

  1. Review the result set on the Grids tab. Select different columns and rows. Select individual cells. Scroll through the Results pane to view all of the contents on the Grids tab.
  2. Click the Execution Plan tab.

A graphical representation of the execution plan is displayed.

  1. Point to each of the icons on the Execution Plan tab.

For each icon, a pop-up menu appears, showing the result of a clustered index scan.

  1. Click the Trace tab.

Server trace information about the executed Transact-SQL statement is displayed.

  1. Review the information on the Trace tab.
  2. Click the Statistics tab.

Client-side statistics for the executed query are displayed.

  1. Review the statistical information.
  2. Click the Messages tab.

A message about the executed query appears.

  1. Review the message.

To correct a Transact-SQL statement

  1. In the Editor pane, change customer to custom.
  2. Click the Execute Query button on the toolbar.

Notice that the Messages tab in the Results pane is active. An error message is displayed, saying that custom is an invalid object name.

  1. Correct the Transact-SQL statement, then re-execute the query.

The result set is displayed in the Grids tab.

To display the Estimated Execution Plan

  1. On the toolbar, click the Display Estimated Execution Plan button.

The Estimated Execution Plan tab and the Messages tab appear in the Results pane. The Estimated Execution Plan tab displays the estimated execution plan for the query in the Editor window.

  1. Review the information on the Estimated Execution Plan tab.

To modify how the result set is displayed

  1. On the toolbar, click the Execute Mode button and then select Results In Text.
  2. Execute the query.

The result set is displayed in text form on the Results tab of the Results pane. Notice that the Messages tab is no longer present.

  1. Scroll to the bottom of the result set on the Results tab.

The message related to the execution of this query appears beneath the result set. If the query attempt had generated an error, the error would have appeared on the Results tab.

  1. On the toolbar, click the Execute Mode button and then click Show Execution Plan.
  2. Repeat the previous step for the Show Server Tracer option and the Show Client Statistics option.
  3. On the toolbar, click the Execute Mode button and then view the listed options.

Notice that the only option now checked is Results In Text.

  1. Click the Results In Grid option.
  2. Re-execute the query.

The result set is displayed in the Grids tab.

  1. Close SQL Query Analyzer. When prompted to save changes, click No.

NOTE


As an added exercise, try running the isql and osql command-prompt utilities. Once each utility is running, execute a SELECT statement against the Customers table in the Northwind database. Be sure to exit the utility after you run your query. Carefully review the information about isql and osql in SQL Server Books Online before running either of the utilities.

Lesson Summary

SQL Server 2000 provides a set of tools that enable you to use Transact-SQL to interact with SQL databases and their data. These tools include SQL Query Analyzer and the isqlw, isql, and osql command-prompt utilities. SQL Query Analyzer is a GUI that enables you to design, test, and execute Transact-SQL statements, stored procedures, batches, and scripts interactively. The functionality within SQL Query Analyzer can be described in terms of the interface layout. SQL Query Analyzer includes a number of windows, dialog boxes, and wizards that help you to perform the tasks necessary to manage SQL Server databases and the data stored within those databases. The main window that you use to execute Transact-SQL statements and to view a query result is the Query window. The Query window is divided into two panes: the Editor pane and the Results pane. SQL Query Analyzer also includes the Object Browser window, which enables you to navigate the objects in the database, and the Transact-SQL Debugger window, which enables you to control and monitor the execution of stored procedures. In addition to SQL Query Analyzer, SQL Server includes the isqlw, isql, and osql command-prompt utilities. Each of these utilities enables you to enter Transact-SQL statements, system procedures, and script files at a command prompt. You can also use the isqlw utility to launch SQL Query Analyzer.



Microsoft Press Staff - MCSE. Microsoft SQL Server 2000 Database Design and Implementation Training Kit
MCSE Training Kit (Exam 70-229): Microsoft SQL Server(TM) 2000 Database Design and Implementation (Pro Certification)
ISBN: 073561248X
EAN: 2147483647
Year: 2001
Pages: 97

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net