Search - Joel Lipman .Com

41. JDatabase: using the Joomla database with examples: / Joomla /; ... on line 344 INSERT using JDatabaseQuery Note: for Joomla v3.x, use db->execute() instead of db->query() $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->insert($db->quoteName('#__my_users')) ...; Created on 27 January 2013
42. DataTumble - Randomize Data Rows: / Transact-SQL /; ... + ',NULL FROM ' + @TableName + ' WHERE ' + @WhereClause INSERT INTO #Scramble EXECUTE (@SqlStatement) -- To dynamically create a cursor SET @UpdateSqlStatement ...; Created on 07 December 2012
43. Search a database for a value and count matching rows: / Databases /; ... -- Declare some variables to use DECLARE @SqlToExecute varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid ...; Created on 05 November 2012
44. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... DECLARE @ColToProcess varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT ...; Created on 26 October 2012
45. Search a database with SOUNDEX: / Databases /; ... -- Declare some variables to use DECLARE @SqlToExecute nvarchar(max); DECLARE @FullSqlToExecute VARCHAR(max); DECLARE @myCounter int; DECLARE @minStrLen int; DECLARE @maxStrLen int; -- Set ...; Created on 11 October 2012
46. Search a database for a string (MySQL, T-SQL): / Databases /; ... You can put a distinct on it (not forgetting the collate). This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE @SqlToExecute nvarchar(max); DECLARE ...; Created on 08 October 2012
47. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... -- Variables used DECLARE @ColName varchar(50); DECLARE @TableName varchar(50); DECLARE @TableDeclaration nvarchar(4000); DECLARE @SqlToExecute nvarchar(4000); -- Set variable default ...; Created on 03 August 2012
48. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... you need permission to create this function. Don't forget to GRANT permission to execute this function for whatever user/system account that will run it. -- Drop the function if it already exists IF ...; Created on 01 August 2012
49. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... grant execute for your SSRS user) Add a data source to your SSRS report Add an SSRS input parameter Add a dataset Query type: Stored Procedure Refresh fields button Parameter name (oracle input ...; Created on 19 January 2012
50. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; ... sac180786.txt Permissions CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR base_table_owner.sp_get_studentdetails_from_ad; GRANT EXECUTE ON sp_get_studentdetails_from_ad ...; Created on 16 January 2012