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...
Microsoft is intent on proving that .NET's no dog when it comes to Web application development. Using C#, Microsoft. NET, and SQL Server 2000, Microsoft has implemented Sun's Java 2 Enterprise Edition (J2EE) best-practices blueprint application...
A simple technique for populating tables and creating queries
Learn the quirks of writing—and naming—T-SQL procedures