====== MSSQL, T-SQL ======
===== Functions =====
  * [[programming:mssql:lpad|LPAD]]
  * [[programming:mssql:split|Split]]
  * [[programming:mssql:getdateonly|GetDateonly]]
  * [[programming:mssql:runningprocesses|Running processes and kill]]
  * [[programming:mssql:importfromexcel|Import data from excel]]
  * [[programming:mssql:explodedates|ExplodeDates - returns days in the given range as a table]]
  * [[programming:mssql:columntocsv|Column to CSV]]

===== Features and techniques =====
  * [[programming:mssql:t-sql|Techniky T-SQL]]
  * [[programming:mssql:novinkymssql2008|Novinky MSSQL 2008]]

  * [[programming:mssql:testConnection|Test connection]]
  * [[programming:mssql:closeconnections|Close connections]]
  * [[programming:mssql:commontableexpression|Common Table Expression]]
  * [[programming:mssql:shrinkdatabase|Shrink DB]]
  * [[programming:mssql:synchonizetables|Synchronize tables]]
  * [[programming:mssql:setidentity|SET IDENTITY]]
  * [[programming:mssql:resetidentity|Reset identity]]
  * [[programming:mssql:setnocount|Disable printing number of affected rows]]
  * [[programming:mssql:fastcount|Fast COUNT]]
  * [[programming:mssql:readingcsv|Reading CSV files]]
  * 
  * [[programming:mssql:sendmailclr|Send mail using CLR Stored Procedure]]
  * [[programming:mssql:restartservisce|Restart MSSQL service]]
  * [[programming:mssql:backup|Backup]]

  * [[programming:mssql:miscellaneous|Miscellaneous]]