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...
  • XBox Live connection
    I am excited to connect XBox to internet and want to stream video directly in TV.  But configuring XBox to connect XBox Live had some hiccup...