By tag: beyondrelational
0
kicks
FOR XML Workshop – Understanding FOR XML AUTO
This post explains how to generate XML documents from the result of a SQL Server relational query using FOR XML AUTO.
0
kicks
Cannot resolve collation conflict for column 1 in SELECT statement
This post explains how to fix the SQL Server error message "Msg 468, Level 16, State 9, Line 1 Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in the equal to operation".
0
kicks
Creating a file using SSIS file system task
This post explains how to create a file using SSIS file system task.
0
kicks
A T-SQL Holiday Message
Have fun with this TSQL Holiday Message. Run the code given in the story and you will be surprised to see the output.
0
kicks
Are You Using Template Explorer?
This post explains the Template Explorer feature in SSMS which provides a number of TSQL templates to do common database tasks.
0
kicks
Michael DeFehr explains his winning solution to TSQL Challenge 14
Michael DeFehr has written an excellent explanation of his winning solution to TSQL Challenge 14.