MS SQL Data types
This article provides a summary of the different data types available in SQL Server.
TAGI: sql, t-sql, data types, ms sql
CAST and CONVERT MS SQL
Reference for the CAST and CONVERT Transact-SQL functions. These functions convert expressions from one data type to another.
TAGI: sql, t-sql, ms sql
SQL Server Tutorial
The SQL Server Tutorial website provides practical tutorials with many hands-on examples to help you learn SQL Server quickly and effectively.
TAGI: tutorial, sql, ms sql
Azure SQL Server Stretch Database docume
Learn how to use SQL Server Stretch Database to migrate cold data transparently and securely to the Azure cloud. You can set up cost-effective availability for databases with infrequently used data without requiring changes to existing queries or applications.
TAGI: sql, ms sql, azure
Microsoft SQL documentation
Learn how to use SQL Server and Azure SQL to manage your database needs, both on-premises and in the cloud.
TAGI: sql, ms sql
SQL Typy złączeń (Join)
SQL/Typy złączeń - Wikibooks, biblioteka wolnych podręczników
TAGI: sql, join
SQL Joins (w3schools)
Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, Python, PHP, Bootstrap, Java, XML and more.
TAGI: sql, join
Joins (SQL Server)
Learn about the types of join operations that SQL Server employs. SQL Server supports vertical table partitioning, or columnar storage, using join operations.
TAGI: sql, ms sql, join
SQL Server OFFSET FETCH
2012-04-22 W SQL Server aż do najnowszej wersji brakowało mechanizmu pozwalającego na stronicowanie wyników zapytań. Programiści radzili sobie z tym problemem wykorzystując dostępne konstrukcje (klauzula TOP, funkcja RowNumber(), tabela tymczasowa lub CTE) ale nie było gotowego rozwiązania. W najnowszej wersji języka T-SQL pojawiły się polecenia OFFSET i FETCH, które umożliwiają wygodne stronicowanie danych zwracanych przez…
TAGI: ms sql
Date and Time Data Types and Functions
Links to Date and Time data types and functions articles.
TAGI: ms sql
COALESCE (T-SQL)
Transact-SQL reference for COALESCE, which returns the value of the first expression that does not evaluate to NULL.
TAGI: ms sql
SQL Join Drawing
It took me quite some time before I could reason efficiently about SQL JOINs. And I must admit, the set theory diagrams never helped me really understand JOINs in SQL. So today, I want to help you understand JOINs in a different way, hoping to make the concept click at once for you too!
TAGI: sql, join