Tuesday, March 17, 2009

Auxiliary numbers table - MSSQL Technique

Auxiliary numbers table is a T-SQL technique. It uses a simple table (say num) with one column with a sequence of numbers. Using the num table we can avoid loop structres

http://sqlserver2000.databases.aspfaq.com
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Teams PowerShell

 The PowerShell helps to get quick meta data around Teams. Install-Module -Name MicrosoftTeams Connect-MicrosoftTeams Get-TeamAllChannel...

  • Windows Restart
    I was trying to install SharePoint 2013, the setup was complaining about a pending system restart.  Even after multiple restart / Shutdown. ...
  • C# Virtual & Abstract Properties
    Recently a new learner of C# asked me a question on C# Virtual & Abstract properties.  It turned out to a deep dive.  Detail follows. D...
  • .Net Interview Questions
    source 1. Microsoft .NET Framework interview questions .NET 2. What is .NET Framework? 3. Is .NET a runtime service or a developm...