Posts

Insert Comma Separated String to Database table in My SQL

 If the database table contains this id than it update the data if not contain it insert a new record which are not in table  I am writing this for my requirement ,you can also change the input parameter as per your requirement. DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `USP_Update_ServiceTask`(             in  in_Action           varchar(10),         in  PKService_Task_ID   int,         in  in_serviceid        int,         in  in_TaskIds          varchar(8000),         in  in_Updatedby        varchar(50),         out  message ...
Post a Comment
Read more

Split Comma Separated String in My SQL

DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `String_Split`(  vString VARCHAR(8000),   vSeparator VARCHAR(5) ) BEGIN DECLARE vDone tinyint(1) DEFAULT 1; DECLARE vIndex INT DEFAULT 1; DECLARE vSubString VARCHAR(15); DROP TABLE IF EXISTS tmpIDList; CREATE TEMPORARY TABLE tmpIDList (ID INT); WHILE vDone > 0 DO   SET vSubString = SUBSTRING(vString, vIndex,                     IF(LOCATE(vSeparator, vString, vIndex) > 0,                       LOCATE(vSeparator, vString, vIndex) - vIndex,                       LENGTH(vString)                     )...
Post a Comment
Read more

How to creat slideshow in javascript

Slidesh Step 1: Open your webpage and paste the following code anywhere between <body> and </body>: <!----------------------------------------------> <!-- START OF CODE FOR THE SLIDESHOW --> <!----------------------------------------------> <!-- CONFIGURATION OF TEXT-STYLE STARTS HERE --> <style> .textstyle {                 /* style attributes for the comments */                 font-family:Arial;                 font-size:8pt;                 color:#aaaaaa;                 background-color:#FFFFFF;   ...
Post a Comment
Read more
Ajaya
Post a Comment
Read more