What?
A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...
What?
If you're installing an app and it creates two icons:
Why?
I don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. ...
... Rows : One row per space separated string value
** Return Values : None
*********************************************************************************/
BEGIN
DECLARE @StringValue ...
What?
An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value:
-- What I have:
//
-- ...
... words that you want in a specific case.
CREATE FUNCTION ufn_ProperCase(@Text AS VARCHAR(8000))
RETURNS VARCHAR(8000)
AS
BEGIN
-- declare some variables
DECLARE @Reset BIT;
DECLARE @Ret VARCHAR(8000);
...
... equation can be written:
Table: DMExtractEmployeeTable
ID ForeName SurName
---------------------------------
1 Joel Lipman
2 JOE THE GREATEST
DECLARE ...
...
How?
Perhaps we should determine the position of the last needle first (reverse the haystack string and find needle):
DECLARE @Haystack VARCHAR(31);
SET @Haystack = 'String1.String2.String3.String4';
-- ...
... "WarehouseLoadKey" and the value we want to search on is "3" (the 3rd incremental load).
How?
The below stored procedure can be reduced to just a script as long as you declare and set the parameters ...
... **
*****************************************************************************************************************/
BEGIN
-- Declare some variables to use
...
... 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 ...
... script you have to use the $_GET, $_POST or $_SESSION methods. Or redeclare it after the above.
MYSQLI_USE_RESULT allows these results to be used once, remove it if you need counts or to use ...
... OR REPLACE PROCEDURE sp_get_studentdetails_from_ad (
p_STUDENT_ADNAME IN varchar2,
l_CURSOR OUT sys_refcursor
)
IS
BEGIN
-- going to declare variables that are to be returned in SSRS ...
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.