Oleg Dok questions

Oleg Dok answers

• Test ALL rows exists
• find the nearest location in ms-sql
• How to use sql function for a computed column to retrieve a value from XML
• How do you pass null values for dbtype decimal??
• Relationships between tables from different databases
• Open Symmetric Key With Password In Stored Procedure
• Update one column as sum of other two columns
• SQL Server ORDER BY clause in subquery
• What is the proper way to lock code areas
• How to delete the top 1000 rows from a table using Sql Server 2008?