... 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 ...
... 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 ...
... (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 ...
... 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 ...
... 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 ...
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
------ ----------------
...
... - 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 ...
... (dummyIndex INT);
-- Alter temporary table structure to match given table
SET @TableDeclaration='ALTER TABLE #myScrambledTable ADD ' + STUFF(
(
-- Code to concatenate column names and data ...
This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.