C H A P T E R 3 INTRODUCING SQL SERVER EXPRESS in VB.NET

Creator PDF-417 2d barcode in VB.NET C H A P T E R 3 INTRODUCING SQL SERVER EXPRESS

C H A P T E R 3 INTRODUCING SQL SERVER EXPRESS
Encoding PDF-417 2d Barcode In Visual Basic .NET
Using Barcode printer for .NET Control to generate, create PDF 417 image in Visual Studio .NET applications.
www.OnBarcode.com
Reading PDF-417 2d Barcode In Visual Basic .NET
Using Barcode decoder for .NET Control to read, scan read, scan image in VS .NET applications.
www.OnBarcode.com
After downloading the installation from the link provided earlier, launch the .msi file that contains EM. You will be presented with a screen similar to that in Figure 3-1.
Barcode Creation In VB.NET
Using Barcode creator for .NET Control to generate, create Barcode image in VS .NET applications.
www.OnBarcode.com
Drawing EAN-13 In Visual Basic .NET
Using Barcode creation for Visual Studio .NET Control to generate, create EAN13 image in .NET applications.
www.OnBarcode.com
Figure 3-1. Installing SQL Express Manager Click the Next button to begin navigating through the installation wizard. The next screen shows the standard End User License Agreement; read and accept it. Then you will be prompted with the component selection dialog as shown in Figure 3-2. For this installation, the default is to install everything, and as the dialog shows, there is not too much to choose from.
PDF-417 2d Barcode Creator In Visual Basic .NET
Using Barcode creation for .NET framework Control to generate, create PDF-417 2d barcode image in VS .NET applications.
www.OnBarcode.com
Code 128 Encoder In VB.NET
Using Barcode printer for Visual Studio .NET Control to generate, create USS Code 128 image in .NET applications.
www.OnBarcode.com
Figure 3-2. Component selection for Express Manager installation
Create GTIN - 128 In VB.NET
Using Barcode generation for .NET framework Control to generate, create EAN 128 image in VS .NET applications.
www.OnBarcode.com
Postnet 3 Of 5 Drawer In VB.NET
Using Barcode creation for Visual Studio .NET Control to generate, create Delivery Point Barcode (DPBC) image in .NET framework applications.
www.OnBarcode.com
C H A P T E R 3 INTRODUCING SQL SERVER EXPRESS
PDF417 Creation In None
Using Barcode encoder for Office Excel Control to generate, create PDF-417 2d barcode image in Excel applications.
www.OnBarcode.com
PDF 417 Scanner In None
Using Barcode recognizer for Software Control to read, scan read, scan image in Software applications.
www.OnBarcode.com
After you click the Next button on the component selection screen, you will be at the last step of the wizard, and you can click the Install button to begin the installation. Once the installation is complete, there will be another shortcut in your SQL Server Express program group available from Start Programs. Go there now and launch EM, and we will now get into the cool features it provides.
QR Code JIS X 0510 Encoder In Java
Using Barcode maker for BIRT Control to generate, create QR-Code image in BIRT applications.
www.OnBarcode.com
UPC-A Supplement 5 Recognizer In None
Using Barcode reader for Software Control to read, scan read, scan image in Software applications.
www.OnBarcode.com
Note The first time you launch Express Manager, there will be a delay as some last-minute configuration
PDF-417 2d Barcode Creation In Java
Using Barcode generation for Android Control to generate, create PDF-417 2d barcode image in Android applications.
www.OnBarcode.com
Encoding Barcode In None
Using Barcode drawer for Microsoft Word Control to generate, create Barcode image in Word applications.
www.OnBarcode.com
is undertaken.
Barcode Scanner In .NET
Using Barcode Control SDK for ASP.NET Control to generate, create, read, scan barcode image in ASP.NET applications.
www.OnBarcode.com
PDF-417 2d Barcode Creation In None
Using Barcode printer for Microsoft Word Control to generate, create PDF-417 2d barcode image in Word applications.
www.OnBarcode.com
Once EM is configured and opens, you are shown the connection dialog in Figure 3-3. Enter the name of the local SQLEXPRESS instance as shown in the figure.
Code 39 Extended Encoder In Objective-C
Using Barcode maker for iPhone Control to generate, create Code 39 image in iPhone applications.
www.OnBarcode.com
Universal Product Code Version A Reader In .NET
Using Barcode scanner for .NET Control to read, scan read, scan image in VS .NET applications.
www.OnBarcode.com
Note As we mentioned earlier in the chapter, SQL Server runs as a windows service. By default, after installing SQL Server Express, the SQL Server service is not running. You need to start the service to be able to connect to it. Go to Start Run, and type this line: net start MSSQL$SQLEXPRESS.
Code128 Drawer In None
Using Barcode generation for Online Control to generate, create Code 128 image in Online applications.
www.OnBarcode.com
Barcode Printer In None
Using Barcode drawer for Office Excel Control to generate, create Barcode image in Office Excel applications.
www.OnBarcode.com
Figure 3-3. Express Manager connection dialog Once EM establishes a connection with the SQL Server SQLEXPRESS instance, it opens up and looks like Figure 3-4 (we have expanded the treeview so we can discuss everything you see there).
C H A P T E R 3 INTRODUCING SQL SERVER EXPRESS
Figure 3-4. SQL Server Express Manager When EM first opens, you see a treeview on the left-hand side that is somewhat similar to the Database Explorer pane you saw in the IDE in 2. This treeview lists all the objects that it knows about for the instance of SQL Server to which it is connected. At the root of the tree, you can see the actual instance name to which you have connected. Below that, you see two main tree nodes: one to group together all the system databases that it found (in order to distinguish them from user databases you will see in a short while), and the other to manage all the user accounts that have access to connect and manipulate objects on the SQL Server instance. Across the top of EM, you have a toolbar with some buttons available to perform the more common operations. Table 3-1 lists the buttons with their functional descriptions. Table 3-1. Express Manager Toolbar Buttons and Their Functionality
Button
Functionality
This button gives you the ability to open a new query in a new tabbed document. This button allows you to open a query from a file, just as the toolbar button with the floppy disk enables you to save a query to a file. This button allows you to execute the query in the active tab. A shortcut for this is to press the F5 key. This button allows you to verify the syntax of your query before executing it. It is a nice quick way to see if you have any errors in you SQL before putting the load against the server.
C H A P T E R 3 INTRODUCING SQL SERVER EXPRESS
As always, all the toolbar button commands are also available from the main menu. Another important item to note in EM is the drop-down list provided within each Query tab. This drop-down list contains a list of all the databases for the instance of SQL Server express to which it is connected. The significance of this drop-down list is that the database selected is the one that the current query will be executed against. By default, it is showing the master database. If you wanted to execute a query against the master database, you could do so by entering the following text into the query window and then pressing the F5 key, or clicking the Execute button on the toolbar. SELECT * FROM sysdatabases If you leave the drop-down list with the master database selected and try to execute a query against one of the other databases, you will get an error indicating that the object does not exist. In this case, you would have to use the full three-part naming of the object or switch the drop-down list to the database you want to work against in order for the objects to be found and the query execute successfully. Now that you have already executed your first query in EM, let s take a look at creating a database. (Later we create this same database using the command line to provide a clear comparison between using this tool and the SQLcmd.exe utility.) To create a database, follow these steps: 1. Right-click the Databases folder in the treeview and select New Database. You then get a tabbed document created, such as the one in Figure 3-5, where you can ll in the name and location of your database.
Figure 3-5. Creating a database in Express Manager 2. Type in the name StoreEM (as shown in Figure 3-5), and leave the default le location.
Copyright © OnBarcode.com . All rights reserved.