DatabaseJournal.com Staff

>>Script Language and Platform: MS SQL 2000 This sproc was created as an excercise in tSql date calculations and the new table variable feature or MSSQL2K. This sproc expects a month number and year, and returns two recordsets. RS1 = [month name], [year] RS2 = A calendar representation of the days in the month number […]

by Roman B. Melnyk and Paul C. Zikopoulos This article outlines result set retrieval from SQL data-change operations support in the IBM DB2 Universal Database (DB2 UDB) products as of Version 8.1.4. Result set retrieval from data-change operations (INSERT, UPDATE, and DELETE) is supported in DB2 UDB V8.1.4 with the new data-change-table-reference clause, which has […]

>>Script Language and Platform: SQL Server 2000 Change the date to first day of current month then subtract 1 from the date. –Todays date = April 20, 2004 select dbo.LastDayofPreviousMonth(getdate()) –returns 2004-03-31 00:00:00.000 select dbo.LastDayofPreviousMonth(’01/12/2004′) –returns 2003-12-31 00:00:00.000 select dbo.LastDayofPreviousMonth(’03/04/2004′) –returns 2004-02-29 00:00:00.000 Author: MAK create function dbo.LastDayofPreviousMonth (@date datetime) returns datetime as –Author:MAK –Objective: […]

[From CNET News.com] A new variant of the Phatbot worm may be on the loose and attempting to attack SQL Server ports, according to a warning the SANS Institute issued Monday. Last month, Phatbot made the rounds, attacking Windows systems by acting as a Trojan horse. Phatbot would then link infected computers into an underground […]

>>Script Language and Platform: SQL Server 2000 This script will return you to the first day of previous quarter of a given date. –today’s date Apr 19, 2004 select dbo.previousquarter (getdate()) –returns 2004-01-01 00:00:00.000 select dbo.previousquarter (’03/31/2004′) –returns 2003-10-01 00:00:00.000 select dbo.previousquarter (’04/01/2004′) –returns 2004-01-01 00:00:00.000 select dbo.previousquarter (’07/11/2004′) –returns 2004-04-01 00:00:00.000 select dbo.previousquarter (’09/09/1974′) […]

[From Birdstep Technology] SEATTLE/OSLO April 14, 2004 – Today, Birdstep Technology (OSE: BIRD) announced the release of Birdstep RDM Mobile 3.0, a full featured, small footprint database ideally suited for mobile computing systems. With its data integrity, multi-user support, zero-administration, and broad platform support, RDM Mobile 3.0 offers the functionality and flexibility needed to meet […]

by Paul C. Zikopoulos and Roman B. Melnyk The maintenance of any database involves the routine invoking of utilities that perform backup operations, data rebalancing, updating the database statistics, reorganizing a table, and so on. In IBM DB2 Universal Database for Linux, UNIX and Windows (DB2 UDB), utilities are parallelized and extremely fast. Usually, speed […]

>>Script Language and Platform: Sybase Transact SQL This stored procedure displays used vdevno & shows the first free vdevno. Author: jflebon use sybsystemprocs go if exists (select name from sybsystemprocs..sysobjects where name=”sp_dba_vdevno” and type=”P”) begin drop procedure sp_dba_vdevno end go create procedure sp_dba_vdevno as /* *@(#) Author : JF LEBON *@(#) Version : 1.1 *@(#) […]

>>Script Language and Platform: SQL Server 2000 This script displays a range of dates. select count(*) from dbo.calendar (‘1974-09-09′,’2004-01-10’) –results 10716 select * from dbo.calendar (‘2001-01-01′,’2001-01-05’) –results id,date,month,day id,date,month,day 1,2001-01-01 00:00:00.000,January,Monday 2,2001-01-02 00:00:00.000,January,Tuesday 3,2001-01-03 00:00:00.000,January,Wednesday 4,2001-01-04 00:00:00.000,January,Thursday 5,2001-01-05 00:00:00.000,January,Friday select * from dbo.calendar (‘1974-09-07′,’1974-09-10’) –results id,date,month,day 1,1974-09-07 00:00:00.000,September,Saturday 2,1974-09-08 00:00:00.000,September,Sunday 3,1974-09-09 00:00:00.000,September,Monday 4,1974-09-10 00:00:00.000,September,Tuesday Author: […]

[From Oracle Corp.] Apr. 8, 2004 – (http://www.oracle.com/tellmemore/?3053606) Oracle Corp. today announced a world record TPC-C performance benchmark result for Oracle(r) Database 10g running with Linux-based SMPs. Using NEC’s Express5800/1320Xd with 32 Intel(r) Itanium(r) 2 processors at 1.5 GHz with 6 MB L3 cache running on Novell’s SUSE LINUX Enterprise Server 9, Oracle Database 10g […]

stevenswarren@gmail.com Steven S. Warren is a popular author residing in Winter Haven, Florida with his wife Danna and 2 children: Catie-Charlotte and Dain. As a columnist on such well-known IT web sites as Techrepublic.com, CNET, and ZDNET, Steven has published numerous articles. Additionally, Steven holds the following certifications: MCDBA, MCSE, MCSA, CCA, CIW-SA, CIW-MA, Network+, […]

>>Script Language and Platform: Oracle Returns a new datetime value based on adding an interval to the specified date. Syntax DATEADD ( datepart , number, date ) examples 1)Subtract 10 days from ’05/APR/2004′ Select DateADD(‘dd’ , -10, to_date(’05/APR/2004′)) from dual ———— 03/26/2004 2)ADD 30 days to MAR return Select DateADD(‘dd’ , 30, to_date(’31-MAR-2003′)) from dual […]