The following Stored Procedure example demonstrates how optional predicates can be used in one statement based upon the parameters that are passed to the Stored Procedure.
Monthly Archives: February 2006
The Februrary 2006 edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
I have recently been demonstrating SQL Sever Integration Services (SSIS) to a number of people and there seems to be some confusion on how the (SSIS) For Each Container can be used to to perform an operation on a collection.
A question I was recently asked is how the SQLDMO object can be used to register Servers and Server Groups in SQL Server Enterprise Manager.
In SQL Server 2000 Built-in nondeterministic functions were not allowed in the body of a user-defined functions (UDF).
Recently I was contacted by a client who migrated a new Stored Procedure to production and wondered why replication all of a sudden ‘broke’ when the new Stored Procedure was added to the publication.
In SQL Server 2005 all objects in a database are now located in schemas and are not owned by individual users. In order to move an object from one schema to another