SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...

SELECT * FROM table1 WHERE fieldStatus IN (@Status) AND (CASE WHEN @Status = 'Open' AND COUNT(@Status) = 1 THEN fieldDate >= GETDATE() END) I hope that makes sense. Anyone know how to test for a multi ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

Microsoft on Wednesday announced the availability of the first new service pack for SQL Server 2012, along with other improvements to come, at the annual PASS summit event. The news was delivered in a ...