Congratulations to Tony Bain, senior DBA at Wellington, New Zealand-based SQL Services and Zivan Karaman, manager of the statistical department at Limagrain Genetics in Chappes, France. Tony won first prize of $100 for the best solution to the...
Are you a busy SQL Server professional who hasn't learned XML because you don't need it to fulfill your day-to-day job responsibilities? If so, you might want to rethink your reasons for not learning XML...
EDITOR'S NOTE: Send your T-SQL questions to SQL Server MVP Itzik Ben-Gan at questions@tsqlsolutions.com.
Using a UDF in a CHECK Constraint to Validate a Column
I want to validate a column in table S by allowing only primary key value...