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
Read More...
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,
Read More...
Posted:
Wednesday, May 26, 2004 9:38 PM
by
Barry Gervin |
Filed under: PDC, VS2005, ADO.NET, SQL, VS2003, C#, VB.NET, Tips, WinForms, WebForms, Services, Security, Events, Testing, TechEd
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)
Read More...
Posted:
Saturday, May 22, 2004 9:34 PM
by
Barry Gervin |
Filed under: VS2005, Vista, ADO.NET, SQL, VS2003, C#, VB.NET, Tips, Events, TechEd
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
Read More...