Assuming exec is required, the following 15 results were found.
-
This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE @SqlToExecute nvarchar(max); DECLARE @mySearchString varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
array('Content-Type: '.$mime_type, 'Content-Length: ' . filesize($file), 'Authorization: Bearer ' . $access_token) ); // execute cURL request $response=curl_exec($ch1); if($response === false){ $output = 'ERROR: '.curl_error($ch1); } else{ $output =...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
Stored Procedure to list distinct values and counts (defaults to case and accent-sensitive). ** ** ** ** Usage: ** ** EXEC [usp_ListDistinctValuesAndCounts] 'myDB.dbo.myTable', 'myColumn1,myColumn2', 'Latin1_General_CS_AS'; ** ** ** ** Return Values :...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE); // TRUE to return the transfer as a string of the return value of curl_exec() instead of outputting it out directly. // store the response $ch_result = curl_exec($ch); // close connection curl_close($ch);...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
headers (enable these during testing - malformed XML but more info) curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1 ); // curl_exec function will show the response directly on the page (if set to 0 curl_exec function will return the result) curl_setopt($ch,...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
Script to create a SQL query which searches a database with SOUNDEX (detects typos). ** ** ** ** Usage: ** ** Step #1: EXEC [usp_GenerateSearchbySoundexQuery] 'mySearchString', 'tableSchemaToSearch'; ** ** Step #2: Run the query this generates against...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
(exclusive) - allows you to run ** ** this against any table only changing the parameter column. ** ** ** ** Usage: ** ** EXEC [usp_CountRecordsPerTablePerColumn] '3', 'Customer_ID'; ** ** ** ** Parameters : ** ** - Value: the value you want to match on...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
used DECLARE @ColName varchar(50); DECLARE @TableName varchar(50); DECLARE @TableDeclaration nvarchar(4000); DECLARE @SqlToExecute nvarchar(4000); -- Set variable default values SET @TableName = SUBSTRING(@SchemaTableName, CHARINDEX('.',...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
** Once the Data has been scrambled it won't be possible to get the original set of Data. ** ** ** ** Usage Examples: ** ** EXEC usp_ScrambleMultivalue 'dbo.TableA', 'ColumnNameA'; ** ** ** ** EXEC usp_ScrambleMultivalue 'dbo.TableA', 'ColumnNameA', **...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
$url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout); $data = curl_exec($ch); curl_close($ch); return $data; } $file_content = get_data( "http://joellipman.com/xml_feeds/my_XML_url.xml" ); $file_xml =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
$url); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $response=curl_exec($ch); if ($response === false) { return curl_error($ch); } else { return json_decode($response, true); } curl_close($ch); } //...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
CURLOPT_POSTFIELDS, http_build_query($data)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($ch); curl_close($ch); $output = json_decode($response, true); return $output; } 5. Get Minutes Remaining on cached token So usually an...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
of the person running the report. This second page is called "HouseKeepForm". We have a 3rd report which will actually execute the stored procedure called "HouseKeepExec". The Problem We get the above error if we tried to execute the stored procedure...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Syntax CREATE [OR REPLACE] PROCEDURE stored_procedure_name [ (parameter [,parameter]) ] IS | AS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [stored_procedure_name ]; Example CREATE OR REPLACE PROCEDURE...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB