Other News

Community

Using SQL Server Templates

(Deanna Dicken) SQL Server Management Studio has a not well known but very handy feature for using and creating template scripts. This article will provide an overview of the Template Explorer in SQL server Management Studio and dive into examples of using existing templates as well as creating your

Community

Drop Object If Exists

(Michael McLaughlin) Writing an anonymous block to conditionally drop tables and sequences got very old. I figured it was time to simply put a procedure that would simplify it. Avoiding repetition was important too, so it supports an invoker rights model. This mimics the IF EXISTS syntax available i

Community

Oracle PL/SQL collections

(sandip_bhadane) PL/SQL applications typically consist of SQL statements intermixed with procedural logic to process data retrieved from the database. If compiled as a stored procedure, your PL/SQL code will reside on the server, an ideal place for programs that require intensive database interactio