Sams Teach Yourself SQL Server 2005 Express in 24 HoursWritten with clarity and a down-to-earth approach, Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level in 24 one-hour lessons. You will learn all of the basic tasks necessary for the administration of SQL Server 2005. You will also learn how to write and fully utilize:
|
Common terms and phrases
ADO.NET appears see Figure breakpoint check constraints clause Click OK column Command object CompanyName conn.Open connection string ContactTitle CREATE PROCEDURE Customers table database diagram database roles DataReader DataSet Debug DepartmentID departmentName designate dialog appears dialog box dialog enables disk error handling execute the stored Executing a Stored field FirstName follow these steps foreign key Freight function groupName Here’s an example Immediate window Inner Join input parameters insert data instantiates LastName Listing login Management Studio Express Microsoft Microsoft SQL Server modify node Null options Orders table output parameters permissions primary key ProductID query referential integrity returns Right-click SalesOrderID SELECT CustomerID SELECT statement Server 2005 Express Server Management Studio Server Roles SQL Server 2005 SQL Server Express SQL Server Management SQL statement SqlCommand object SqlConnection SqlDataReader stored procedure strConn T-SQL temporary table theWay toolbar transaction triggers true/false UnitPrice user-defined variable Visual Basic NET
Popular passages
Page xx - As the reader of this book, you are our most important critic and commentator. We value your opinion and want to know what we're doing right, what we could do better, what areas you'd like to see us publish in, and any other words of wisdom you're willing to pass our way. As an Associate Publisher for Sams Publishing, I welcome your comments.
Page 2 - Access 2003 shine in the everyday world! Conventions Used In This Book The people at Sams Publishing have spent many years developing and publishing computer books designed for ease of use and containing the most up-to-date information available. With that experience, we've learned what features help you the most. Look for these features throughout the book to help enhance your learning experience and get the most out of HTML. • Screen messages, code listings, and command samples appear in monospace...