DatabaseJournal.com Staff

>>Script Language and Platform: SQL Server This script creates table fl_all in your database with all FK defined with reference table. Author: Anand Mahendra Download Script: Fk_Relationship.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole […]

>>Script Language and Platform: SQL Server 2000 For a given year and week, this function will return the date of the first day of that week. Usage: select dbo.udf_mondayofaweek(1,2001) –results 2001-01-01 00:00:00.000 select dbo.udf_mondayofaweek(22,2003) –results 2003-05-26 00:00:00.000 Author: MAK set datefirst 1 go Create function dbo.udf_Mondayofaweek( @week int, @year varchar(4)) returns datetime as begin declare […]

by Anthony Wilko Introduction When a host decides to offer Microsoft SQL Server databases as a feature, customers need a way to access their databases. Usually it is through one of the following ways: MS SQL Enterprise Manager – Many hosts choose to have their customers use the free built-in desktop Enterprise Manager, which has […]

>>Script Language and Platform: SQL Server 2000 This script will pad a given string on the left or right of the column or string value. –Parameter : Pass ‘L’ for Left padding and ‘R’ for right padding. –Usage select dbo.ALLPAD (‘012233′,’*’,10,’L’) –results ****012233 select dbo.ALLPAD (‘012233′,’2′,10,’R’) –results 0122332222 select dbo.ALLPAD (‘43434′,’-‘,30,’L’) –results ————————-43434 select dbo.ALLPAD […]

>>Script Language and Platform: SQL Server This script will display the day of the month as in Roman Julian calendar Usage: select dbo.udf_RomanDay (’02/28/2004′) –results pridie Kal.Mar. select dbo.udf_RomanDay (’12/01/2004′) –results Kalendae Decembres select dbo.udf_RomanDay (’11/13/2004′) –results Idus Novembres Author: MAK Create function dbo.udf_RomanDay (@date datetime) returns varchar(100) as begin –Objective: To display day of […]

[From LogiXML] July 12, 2004 McLean, VA–LogiXML now offers LGX Report, its popular web-based Business Intelligence reporting tool, for free at www.freereporting.com. Built on XML technology, LGX Report lets developers create full-featured web-based reports using a drag and drop user interface. It can connect with numerous databases and web services and can be deployed across […]

>>Script Language and Platform: Oracle This script finds the Schema or user Size. Author: ARANGAPERUMAL.G SELECT tablespace_name, Sum(bytes)/1024/1024 AS total_size_mb FROM dba_segments WHERE owner = Upper(&User_Name) GROUP BY owner, rollup(tablespace_name) Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is […]

>>Script Language and Platform: SQL This script finds the years, months, days, hours minutes and seconds between two dates. — Usage select dbo.age(”11/01/1974”, getdate()) — returns 28 year(s) 7 month(s) 10 day(s) 14:40:16 — This is more accurate than using datediff Author: DCR CREATE FUNCTION dbo.age(@start datetime, @end datetime) RETURNS varchar(42) — select len(‘999 year(s) […]

>>Script Language and Platform: Oracle Find a number that is even or odd. Author: dawood declare a number:=&a; begin if(mod(a,2))=0 then dbms_output.put_line(‘even’); else dbms_output.put_line(‘odd’); end if; end; Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole […]

>>Script Language and Platform: Oracle Look at the statistics of your Database. Author: Gattu N Sudhir Download Script: health_check.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is provided […]

[From Microsoft Corporation] REDMOND, Wash., July 11, 2004 — Database developers and administrators (DBAs) who are eagerly awaiting the release of Microsoft SQL Server 2005, Microsoft’s next generation data management and analysis platform, can take immediate action to prepare their enterprises for deployment. The SQL Server 2005 Ascend Program was created by Microsoft as a […]

>>Script Language and Platform: SQL Server 2000 Custom Mathematical LOG function to determine LOG of a given value for any base. LOGN function can be used in cases where you want exactly the opppsite of POWER function. POWER(X,Y) = Z Y=ZLOGX Unfortunately there is no custom function for finding the LOG of any base in […]