While playing with SQL Server 2008 I found new feature of “Row Constructors”, where I can load temp table from stored procedure directly.Look at the following SQL where I have to use OpenQuery from server to itself creating loopback server and execute stored procedure and insert into temp table.INSERT INTO #TempTableSELECT * FROM OPENQUERY(ServerName, ‘exec StoredProc’)Above mentioned same query can be now [...]...
Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
