|
|
Browse by Tags
All Tags » SQL » ADO.NET » Tips (RSS)
-
Yesterday in my class I was going over the new GetSchema API in Whidbey and I learned from one of my students about another technique that I wasn't aware of - SQL ANSI 92 Information Schema Views. They are also supported in Oracle.
There are almost too many ways of getting database schema information but I'll try to summarize here to see how they ...
-
In SQL Server 2005/Yukon you can create user defined types using managed code. User defined types can be used in declaring variable and table columns. It is generally considered to only make sense for scalar types - things that can be sorted, compared, etc. not unlike the native numeric types and datetime. This is not however a fixed requirement, ...
-
No need to have a TechEd commnet password. You can download ALL the pdf's for the plethora of topics. Some good stuff to see how the newly announced stuff (Team System, etc.) works.
Business Productivity Solutions (Office)
Data Management (SQL Server)
Developer Tools and Technologies
E-Business
Management
Messaging
Microsoft ...
-
Highlights in this exchange of newsgroup posts...
Paging is cut
Server cursors cut (SqlResultSet class)
Async Open is cut, but not excute
SqlDataTable class cut (Good - that was a bad design pattern to propogate)
Command sets are cut, but you can still do batch DataAdapter updates, ...
|
|
|