Kevin S. Goff
What's new in ADO.NET 2.0/T-SQL 2005Kevin started with a joke that he told exceptionally well.
"Give him another chance!"New DataView.ToTable() with overload to filter distinct rows.
Load into a DataTable directly from a reader - DtTable.Load(reader, LoadOption...)
New SqlBulkCopy class
T-SQL Changes:
New pivot function
SQL TOP clause as a variable
- Select (@TOP) ....
- Select Top(select * from table) from....
Common table expressions - recursively querying up or down a tree to search hierarchical data
Set @cEventData = EventData() on DDL Triggers. Report on database activity. Audit trails.
On Update statement, can now output [deleted.amount, inserted.amount]
[tags: Kevin Goff, ADO.NET, SQL, Code Camp 5]