The "L" key is your friend.
I have a table filled with numbers. It is a table with the name numbers and there is only one field named ‘num’ which is an integer (so max value is 2.147.483.647 as seen on MSDN) and the integer is an identity and unique. The table just contains numbers from 1 until 10.000. I use it to inner join, for instance: You can have a table with a row: productA is 10 times in stock. You can then inner join the numbers table if you need 10 rows of productA.select * from products inner join numbers on num
<= stock But I only had 10.000 rows in it and encountered a bug in my system because 10.000 was not enough. So I had to increase it. I have found several solutions to create a numbers table. But no snippet to update an existing number table.So here is my snippet to add additional numbers to your number table:begin transaction SET IDENTITY_INSERT [numbers] ON DECLARE @i INT; SELECT @i = 10001; SET NOCOUNT ON WHILE @i ><= 1000000 BEGIN INSERT INTO [numbers] (num) VALUES (@i); select @i= @i + 1; end; SET IDENTITY_INSERT [numbers] OFF commit Good luck!(Read whole news on source site)
ASP.NET MVC 5 Lifecycle Document Published - .NET Web Development and Tools Blog - Site Home - MSDN Blogs
ASP.NET application lifecycle
IIS 7.0 also supports Classic mode, which behaves like ASP.NET running in IIS 6.0. For more information, see ASP.NET Application Life Cycle Overview for IIS 5.0 and 6.0.
For more information about IIS 7.0 Integrated mode, see ASP.NET Integration with IIS7
Microsoft's board wasn't gung-ho on the Steve Ballmer-backed idea of Microsoft purchasing Nokia's handset business, according to a new report.
Async Programming - Asynchronous TCP Sockets as an Alternative to WCF
For situations where the client and server are on different networks,
making security a major consideration, I always use WCF. But for many
client-server systems where client and server are located on a single
secure enterprise network, I often prefer using TCP sockets.
New features in .NET 4.5 that make it much easier to work with an
effective alternative to Windows Communication Foundation called async
socket programming. James McCaffrey shows how async socket programming