Articles
follow
articles/index.aspx
SQL Server 2012
follow
sql-server-2012/index.aspx
SQL Server 2014
follow
sql-server-2014/index.aspx
SQL Server 2016
follow
sql-server-2016/index.aspx
FAQ
follow
faq/index.aspx
Practice Test
follow
free-test/default.aspx
SQL Server 2012 Management Studio Keyboard Shortcuts - Microsoft IntelliSense
follow
tips/tip-of-the-day.aspx?tkey=5d68d40d-fa1c-4a0b-ad3e-51e1ac902074&tkw=sql-server-2012-management-studio-keyboard-shortcuts---microsoft-intellisense
More Tips
follow
tips/tip-of-the-day.aspx?tkey=5d68d40d-fa1c-4a0b-ad3e-51e1ac902074&tkw=sql-server-2012-management-studio-keyboard-shortcuts---microsoft-intellisense
SQL Server 2012
follow
sql-server-2012/index.aspx
What"s New in SQL Server 2012
follow
sql-server-2012/index.aspx#WhatsNew
What"s New in SQL Server 2012
follow
sql-server-2012/whats-new-in-sql-server-2012.aspx
SQL Server 2012 Editions and Licensing - Frequently Asked Questions
follow
sql-server-2012/faq-editions-and-licensing.aspx
SQL Server 2012 Programmability Datasheet
follow
sql-server-2012/sql-server-2012-programmability-datasheet.aspx
SQL Server 2012 Analysis Services Datasheet
follow
sql-server-2012/sql-server-2012-analysis-services-datasheet.aspx
SQL Server 2012 Master Data Services Datasheet
follow
sql-server-2012/sql-server-2012-master-data-services-datasheet.aspx
SQL Server 2012 Data Mining Datasheet
follow
sql-server-2012/sql-server-2012-data-mining-datasheet.aspx
SQL Server 2012 High Availability Datasheet
follow
sql-server-2012/sql-server-2012-high-availability.aspx
SQL Server 2012 Maximum Capacity Specifications
follow
sql-server-2012/sql-server-2012-maximum-capacity-specifications.aspx
SQL Server 2012 Server Configuration Options
follow
sql-server-2012/sql-server-2012-server-configuration-options.aspx
SQL Server 2012 Articles
follow
sql-server-2012/index.aspx#SQLServer2012Articles
SQL Server 2012 New Date Functions
follow
sql-server-2012/sql-server-2012-new-date-functions.aspx
SQL Server 2012 New String Functions
follow
sql-server-2012/sql-server-2012-new-string-functions.aspx
SQL Server 2012 New Logical Functions (CHOOSE and IIF)
follow
sql-server-2012/sql-server-2012-new-iif-choose-logical-functions.aspx
SQL Server 2012 FORMAT String Function Culture
follow
sql-server-2012/format-string-function-culture.aspx
SQL Server 2012 Date Formats Using the FORMAT Function and CONVERT Function
follow
sql-server-2012/format-function-vs-convert-function.aspx
SQL Server 2008
follow
sql-server-2008/index.aspx
What"s New in SQL Server 2008
follow
sql-server-2008/index.aspx#WhatsNew
Compound Operators
follow
sql-server-2008/compound-operators.aspx
Multiple Value Inserts Within a Single INSERT Statement
follow
sql-server-2008/multiple-value-inserts.aspx
Row Constructor (or Table-Valued Constructor) as Derived Table
follow
sql-server-2008/row-value-constructor-as-derived-table.aspx
MERGE Statement
follow
sql-server-2008/merge-statement.aspx
Table-Valued Parameters
follow
sql-server-2008/table-valued-parameters.aspx
SQL Server 2008 Articles
follow
sql-server-2008/index.aspx#SQLServer2008Articles
Error in Importing/Exporting Geography/Geometry Columns in SQL Server 2008 Management Studio
follow
sql-server-2008/import-export-unknown-column-type-geography-geometry.aspx
SQL Server 2008 to Windows Server 2008 Connection Error 1326
follow
sql-server-2008/connection-error-1326.aspx
Store Locator Using Geography Data Type
follow
sql-server-2008/store-locator-using-geography-data-type.aspx
Convert Latitude/Longitude (Lat/Long) to Geography Point
follow
sql-server-2008/convert-latitude-longitude-to-geography-point.aspx
MERGE Statement With Table-Valued Parameters
follow
sql-server-2008/merge-statement-with-table-valued-parameters.aspx
SqlConnection Connection String
follow
sql-server-2008/sqlconnection-connection-string.aspx
SQL Server 2008 Date Formats
follow
sql-server-2008/sql-server-2008-date-format.aspx
User-Defined Functions
follow
functions/index.aspx
Date Functions
follow
functions/index.aspx#DateFunctions
Determine the age of a person as of today given the birthdate.
follow
functions/get-age.aspx
Determine if it is a leap year.
follow
functions/is-leap-year.aspx
first day of the week
follow
functions/get-first-day-of-week.aspx
first day of the month
follow
functions/get-first-day-of-month.aspx
first day of the quarter
follow
functions/get-first-day-of-quarter.aspx
Get the last day of the month.
follow
functions/get-last-day-of-month.aspx
number of days in a month
follow
functions/get-days-in-month.aspx
the number of days in a year.
follow
functions/get-days-in-year.aspx
String Functions
follow
functions/index.aspx#StringFunctions
Count the number of times a given character occur in a given string.
follow
functions/count-character.aspx
Count the number of times a given search string exists in a given input string.
follow
functions/count-string.aspx
Count the number of words in a given input string.
follow
functions/count-words.aspx
Emulate the behavior of Oracle"s InitCap string function, which changes the first letter of each word in uppercase and all others in lowercase.
follow
functions/initcap.aspx
Encrypt an input string using a simple encryption algorithm.
follow
functions/string-encryption.aspx
Trim the leading zeros from a given alphanumeric value.
follow
functions/trim-leading-zeros.aspx
Tree Functions
follow
functions/index.aspx#TreeFunctions
Get the path of a particular node from the parent within a hierarchy/tree-type table structure.
follow
functions/get-tree-path.aspx
Determine the level of a particular node within the hierarchy/tree-type table structure.
follow
functions/get-tree-node-level.aspx
Table-Valued Functions
follow
functions/index.aspx#TableValuedFunctions
Generate a table of integer values from 1 to the maximum input value.
follow
functions/integer-table.aspx
Generate a table containing the individual values in a comma-delimited/comma-separated value.
follow
functions/comma-delimited-to-table.aspx
SQL Server Built-in Functions
follow
functions/index.aspx#BuiltInFunctions
SQL Server Aggregate Functions
follow
functions/aggregate-functions/index.aspx
SQL Server Configuration Functions
follow
functions/configuration-functions/index.aspx
SQL Server Date and Time Functions
follow
functions/date-and-time-functions/index.aspx
SQL Server Mathematical Functions
follow
functions/math-functions/index.aspx
SQL Server String Functions
follow
functions/string-functions/index.aspx
Tips and Tricks
follow
tips/index.aspx
Returning a comma-delimited output without the use of cursors.
follow
tips/comma-delimited-output.aspx
Easily identify missing identity values.
follow
tips/determine-missing-identity-values.aspx
Generate random numbers without using the RAND function.
follow
tips/generate-random-numbers.aspx
Generate random records from any table.
follow
tips/generate-random-records.aspx
Sort IP addresses that are stored as VARCHAR by their numeric values.
follow
tips/sort-ip-address.aspx
Different ways of splitting a full name to get the first name and last name.
follow
tips/split-name.aspx
Query/read and import an Excel file without using DTS and without importing the data to a SQL table.
follow
tips/read-import-excel-file-p01.aspx
Execute a batch of .sql scripts located in a specific directory without manually opening and executing them through Query Analyzer.
follow
tips/execute-sql-scripts-batch.aspx
Convert datetime values into different date formats.
follow
tips/date-formats.aspx
Compare the SET command against the SELECT statement when assigning values to local variables.
follow
tips/set-vs-select-assigning-variables.aspx
SQL Server Error Messages
follow
error-messages/msg-1-500.aspx
SQL Server Error Message 1 to 500
follow
error-messages/msg-1-500.aspx
Spanish
follow
es/mensajes-de-error/mensaje-1-500.aspx
French
follow
fr/message-d-erreur/message-1-500.aspx
SQL Server Error Message 501 to 1000
follow
error-messages/msg-501-1000.aspx
SQL Server Error Message 1001 to 1500
follow
error-messages/msg-1001-1500.aspx
SQL Server Error Message 1501 to 2000
follow
error-messages/msg-1501-2000.aspx
SQL Server Error Message 2001 to 3000
follow
error-messages/msg-2001-3000.aspx
SQL Server Error Message 3001 to 4000
follow
error-messages/msg-3001-4000.aspx
SQL Server Error Message 4001 to 5000
follow
error-messages/msg-4001-5000.aspx
SQL Server Error Message 5001 to 6000
follow
error-messages/msg-5001-6000.aspx
SQL Server Error Message 6001 to 7000
follow
error-messages/msg-6001-7000.aspx
SQL Server Error Message 7001 to 7500
follow
error-messages/msg-7001-7500.aspx
SQL Server Error Message 7501 to 8000
follow
error-messages/msg-7501-8000.aspx
SQL Server Error Message 8001 to 8500
follow
error-messages/msg-8001-8500.aspx
SQL Server Error Message 8501 to 9000
follow
error-messages/msg-8501-9000.aspx
SQL Server Error Message 9001 to 9500
follow
error-messages/msg-9001-9500.aspx
SQL Server Error Message 9501 to 10000
follow
error-messages/msg-9501-10000.aspx
SQL Server Error Message 10001 to 10500
follow
error-messages/msg-10001-10500.aspx
SQL Server Error Message 10501 to 11000
follow
error-messages/msg-10501-11000.aspx
SQL Server Error Message 11001 to 11500
follow
error-messages/msg-11001-11500.aspx
SQL Server Error Message 11501 to 12000
follow
error-messages/msg-11501-12000.aspx
SQL Server Error Message 12001 to 13000
follow
error-messages/msg-12001-13000.aspx
SQL Server Error Message 13001 to 13500
follow
error-messages/msg-13001-13500.aspx
SQL Server Error Message 14001 to 14500
follow
error-messages/msg-14001-14500.aspx
Frequently Asked Questions
follow
faq/index.aspx
Frequently Asked Questions - SQL Server Tables
follow
faq/sql-server-tables-p01.aspx
Frequently Asked Questions - SQL Server Data Types
follow
faq/data-types-p01.aspx
Frequently Asked Questions - SQL Server Dates (DateTime / SmallDateTime)
follow
faq/dates-p01.aspx
Frequently Asked Questions - SQL Server Views
follow
faq/views-p01.aspx
Frequently Asked Questions - SELECT Statement
follow
faq/select-p01.aspx
Frequently Asked Questions - INSERT Statement
follow
faq/insert-p01.aspx
Frequently Asked Questions - SQL Server Error Messages
follow
faq/error-messages-p01.aspx
Frequently Asked Questions - SQL Server Equivalent of Oracle Functions
follow
faq/oracle-functions-p01.aspx
Frequently Asked Questions - SQL Server 2005 Express Edition
follow
faq/sql-server-2005-express-p01.aspx
Frequently Asked Questions - VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX)
follow
faq/sql-server-2005-varchar-max-p01.aspx