Search - Joel Lipman .Com

41. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... file :: File(s) to copy (names/wildcards: default is "*.*"). :: :: Copy options : :: /S :: copy Subdirectories, but not empty ones. /E :: copy subdirectories, ...; Created on 23 February 2014
42. Client Services: Website Development Agreement: / Static Items /; ... suggest and query against this. Here is an outline agreement between joellipman.com and you: Once I have the domain names, I will configure my server to receive requests for those domains ...; Created on 15 November 2013
43. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal ...; Created on 04 October 2013
44. Compare two databases using T-SQL: / Transact-SQL /; ... with name of database 1 and [myDB2] with name of database 2): -- Joins on table and column names, lists diffences if any SELECT t1.TABLE_CATALOG AS [DB1_Name], t2.TABLE_CATALOG AS ...; Created on 24 September 2013
45. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; ... (or whatever your script is trying to do). Method #2: FileSystemObject ComObjCreate UserFolder:="C:" -- to return file count in a folder ItemCount := ComObjCreate("Shell.Application").NameSpace(UserFolder).Items.Count FileCount ...; Created on 04 June 2013
46. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... all dialogs to close and save. Additional The affecting TNSNAMES.ORA file for the above setup is located in "C:\app\\product\11.2.0\client_1\Network\Admin". I also checked that the data therein ...; Created on 04 March 2013
47. Setup a copy of your Joomla website: / Joomla /; ... usernames/passwords created in the previous steps. $sitename - I would suffix this with "TEST" so as to quickly distinguish this from your main website. $db, $user and $password - these are the database ...; Created on 19 December 2012
48. Search a database for a value and count matching rows: / Databases /; ... table names) DECLARE Cursor1 CURSOR FOR SELECT TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS ...; Created on 05 November 2012
49. Convert a delimited string to table: / Databases /; What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- ...; Created on 26 October 2012
50. Search a database for a string (MySQL, T-SQL): / Databases /; ... - Sorna Kumar IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL DROP PROCEDURE usp_SearchDB GO CREATE PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly ...; Created on 08 October 2012
51. Slideshow Addon: Created on 30 November -0001
52. Form Builder: Created on 30 November -0001