Consuming and Manipulating Data
Access and manipulate data from a Microsoft SQL Server database by creating and using ad hoc queries and stored procedures
Transact-SQL is the Microsoft SQL Server dialect of the ANSI SQL-92 standard query language.
You can execute T-SQL statements from a variety of interfaces, including the Visual Studio .NET IDE, osql, SQL Query Analyzer, or custom applications.
SELECT statements retrieve data from tables in a database.
INSERT statements add new data to tables in a database.
UPDATE statements modify existing data in tables in a database.
DELETE statements remove data from tables in a database.
You can create new stored procedures via Server Explorer and design them directly in Visual Studio .NET.
To execute a query ...
Get MCAD/MCSD.NET Training Guide (Exam 70-316): Developing and Implementing Windows®-Based Applications with Microsoft® Visual C#™ .NET and Microsoft® Visual Studio® .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
