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.
Stored procedures provide a way to keep compiled SQL statements on the database server.
The ADO.NET SqlCommand object enables ...
Get MCAD/MCSD Training Guide (70-320): Developing XML Web Services and Server Components with Visual C#™ .NET and the Microsoft .NET Framework 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.
