Strict Standards: Non-static method category::categoryChildren() should not be called statically in /home/dreaminc/public_html/code/themes/tpl.category.php on line 2

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 129

Strict Standards: Non-static method category::categoryChildren() should not be called statically in /home/dreaminc/public_html/code/themes/tpl.category.php on line 5

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 129

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/code/themes/browse.cat.php on line 67

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method snippet::getCategorySnippets() should not be called statically in /home/dreaminc/public_html/code/themes/browse.cat.php on line 100

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 39

Strict Standards: Non-static method category::categoryChildren() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 50

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 129

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126

Strict Standards: Non-static method snippet::getSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 100

Strict Standards: Non-static method snippet::checkSnippet() should not be called statically in /home/dreaminc/public_html/home/include/include.snippet.php on line 126



Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Strict Standards: Non-static method category::getCategoryDetails() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 20

Strict Standards: Non-static method category::checkCategory() should not be called statically in /home/dreaminc/public_html/home/include/include.category.php on line 15

Copy stored procedures from one server to another with SQL 2005 in mySQL by PsychoCoder Submitted: June 10, 2008        Views: 9629 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 Here is a snippet (1 Stored Procedure, 1 User Defined Function) for copying stored procedures between databases

Select Last Insert in mySQL by supersssweety Submitted: September 21, 2007        Views: 8975 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 Get the last insert to the Database

MSSQL Stored procedure to find all blocked users/processes in mySQL by PsychoCoder Submitted: March 28, 2008        Views: 8942 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a stored procedure (for Microsoft SQL Server) that will retrieve all the blocked users/processes and who/what is blocking them

MSSQL Stored Procedure to Reindex database tables. in mySQL by dineeshd Submitted: July 16, 2008        Views: 8358 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This Stored Procedure will Reindex all tables of a database, which will leads to some performance increment.

MSSQL User Defined Function to split a strin in mySQL by PsychoCoder Submitted: March 21, 2008        Views: 7731 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a snippet to create a User Defined Function to split a comma delimited string

Character count in MSSQL in mySQL by PsychoCoder Submitted: September 29, 2008        Views: 7285 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a user defined function to search for a particular character in a string and count how many times it appears in the string

MSSQL Stored Procedure to copy a table from one database to another in mySQL by PsychoCoder Submitted: December 27, 2008        Views: 6884 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a snippet I've used quite often for copying a table from one database to another (generally from production to development so I'm working with fresh data)

MSSQL stored procedure for calculating a persons age in mySQL by PsychoCoder Submitted: July 10, 2008        Views: 6679 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a MSSQL stored procedure used for calculating a persons age

User defined function to format currency in MSSQL in mySQL by PsychoCoder Submitted: April 20, 2008        Views: 5951 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a snippet to format currency values. This function takes a decimal data type and returns a varchar formatted as currency

MSSQL Stored Procedure for Checking a particular file exists in Drive or not in mySQL by dineeshd Submitted: July 7, 2008        Views: 5289 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This MSSQL Stored Procedure will check the given file name is exists in the drive or not.

User defined function for formatting US phone numbers in MSSQL in mySQL by PsychoCoder Submitted: April 18, 2008        Views: 5027 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a user defined function for formatting US phone number in Microsoft SQL Server

Change Password of Any User IN ORACLE in mySQL by born2c0de Submitted: December 15, 2005        Views: 4964 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 THIS IS A ORACLE STATEMENT AND NOT MYSQL.

SQL 2005 stored procedure for record paging in mySQL by PsychoCoder Submitted: February 2, 2008        Views: 4831 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a stored procedure to help with record paging. With the advent of SQL 2005 a new function was added, ROW_NUMBER, that can help with paging records for you database applications. ROW_NUMBER returns a sequential number, starting at 1, for each row returned in a result set.

Proper case user defined function in MSSQL in mySQL by PsychoCoder Submitted: April 18, 2008        Views: 4643 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a user defined function for setting a string (or sentence) to it's proper case

MSSQL Stored Procedure to find a string in Database in mySQL by dineeshd Submitted: July 31, 2008        Views: 4642 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This stored procedure will help you to find a particular string in a table or whole database.

Random row in mySQL by snoj Submitted: January 17, 2006        Views: 4508 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 Get a random row from a table. Useful for just about anything where you need a random entry.

Determine is a date is a leap year in mySQL by PsychoCoder Submitted: September 28, 2008        Views: 3875 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a User Defined function to determine if a given year is a leap year

Simple encryption with MSSQL in mySQL by PsychoCoder Submitted: September 28, 2008        Views: 3752 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a User Defined Function to perform simple encryption on an input string. This is performed by transposing the ASCII value of each character in the string by the increment value (@increment in the parameter list)

MSSQL equivalent to describe in mySQL by no2pencil Submitted: July 2, 2008        Views: 3408 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 Since MSSQL does not offer the describe command, it can be frustrating digging through the columns. Maybe this can help! Found at http://www.crydust.be/blog/2006/12/26/mssql-lacks-describe-statement : and added constraint_type

Create A View Using TOP Keyword MS SQL Server in mySQL by Nykc Submitted: January 30, 2008        Views: 3385 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 The TOP keyword is specified in a SELECT clause to limit the number of records displayed

MSSQL user defined function to find first weekday of any given month in mySQL by PsychoCoder Submitted: December 27, 2008        Views: 3324 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a snippet to find the first weekday of any given month

MSSQL user defined proper case function in mySQL by PsychoCoder Submitted: May 3, 2008        Views: 2978 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a MSSQL user defined function for converting words to proper case

MSSQL Snippet to Shrink Database files in mySQL by dineeshd Submitted: July 16, 2008        Views: 2953 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This piece of code will shrink the database physical files, so that some disk space can be freed up.

MSSQL snippet for removing duplicate records in mySQL by PsychoCoder Submitted: May 20, 2008        Views: 2934 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 This is a snippet I use for "de-duping" a table (removing all duplicate entries". This process doesn't use temporary tables or cursors, adding to it's efficiency

Find & Replace Data in mySQL in mySQL by Nykc Submitted: January 25, 2008        Views: 2910 Strict Standards: Non-static method bbcode::parse() should not be called statically in /home/dreaminc/public_html/home/include/include.tpl.func.php on line 57 Strict Standards: Non-static method bbcode::add() should not be called statically in /home/dreaminc/public_html/code/bbcode.conf.php on line 16 To find a string in a certain field and replace it with another string: