technese.com

Archive for 'Database' Category

SQL Coding Guidelines

http://www.unifiedasp.net/index.php/sql-coding-guidelines

SQL Server 2012 RC0 Download Link

http://download.microsoft.com/download/5/E/0/5E0F07D5-33E8-4B83-A3DA-10992D669AB6/ENU/SQLFULL_ENU.iso

Transact-SQL: select distinct columns

T-SQL Syntax: SELECT DISTINCT Column FROM TableName SELECT COUNT(DISTINCT ColumnName) FROM TableName

using awk to print columns from a file

1st column $ awk ‘{ print $1 }’ < file> newfile 2nd column $ awk ‘{ print $2 }’ < file> newfile nth column $ awk ‘{ print $n }’ < file> newfile