Alex D

On this channel you will find many useful tricks for programming on MS T-SQL

T-SQL: CONDITIONS WITH MULTIPLE WILDCARDS IN MULTIPLE TABLE COLUMNS
T-SQL: CONDITIONS WITH MULTIPLE WILDCARDS IN MULTIPLE TABLE COLUMNS
How to get sample databases for MS SQL Server?
How to get sample databases for MS SQL Server?
T-SQL: Hiding SQL code in view, SP or functions (WITH ENCRYPTION)
T-SQL: Hiding SQL code in view, SP or functions (WITH ENCRYPTION)
T-SQL: column-level encryption
T-SQL: column-level encryption
T-SQL: data reading from SQL database using excel custom function. PART 2
T-SQL: data reading from SQL database using excel custom function. PART 2
T-SQL: data reading from SQL database using excel custom function PART 1
T-SQL: data reading from SQL database using excel custom function PART 1
T-SQL: How to calculate the total number of working days between two dates?
T-SQL: How to calculate the total number of working days between two dates?
T-SQL: PIVOT
T-SQL: PIVOT
T-SQL: List of integer numbers and dates in one query, without cursor and stored procedure
T-SQL: List of integer numbers and dates in one query, without cursor and stored procedure
T-SQL: Command OVER. Alternative for subquery. Running totals.Partitioning and ordering.
T-SQL: Command OVER. Alternative for subquery. Running totals.Partitioning and ordering.
T-SQL: Files import and export using T-SQL for SQL Server
T-SQL: Files import and export using T-SQL for SQL Server
T-SQL: How to get previous and next record from a selection?
T-SQL: How to get previous and next record from a selection?
T-SQL: command WITH for temporary results
T-SQL: command WITH for temporary results
T-SQL: Column values conversion into one string
T-SQL: Column values conversion into one string
T-SQL: Query result conversion to XML string
T-SQL: Query result conversion to XML string
T-SQL: comparison of tables with similar structure EXCEPT & INTERSECT
T-SQL: comparison of tables with similar structure EXCEPT & INTERSECT
T-SQL: Modification of XML
T-SQL: Modification of XML
T-SQL: Extracting values from XML with multiple nodes
T-SQL: Extracting values from XML with multiple nodes
T-SQL: Extracting values from XML
T-SQL: Extracting values from XML
T-SQL: Split a string in to multiple substrings
T-SQL: Split a string in to multiple substrings
Getting Started with SQL Server. Get the sample database.
Getting Started with SQL Server. Get the sample database.