podiluska questions

podiluska answers

• Int array and IN statement
• SQL Select Distinct but include separated values
• XQuery: Finding rows which contain specified xml data
• xp_fileexist with IF EXISTS
• VSS: Move file from one folder to another?
• TSQL for xml add schema attribute to root node
• Different transactions must guarantedly select different items; avoid contentions
• SQL Server Check if day does not fall on weekend and if so, iterate to a weekday
• How to select dynamic column value from a table?
• Select everything from two table based on the same ID