nisar1

--TSQL
create procedure uspPhoneNumberInsertUpdateSingleItem
	@id int,
	@phonenumber nvarchar(20),
	@phonenumbertype int,
	@contactpersonid int
as
	declare @ReturnValue int
	if(@id is null) --new Item
	begin

nisar1

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

nisar1

Hours and minutes, 12-hour clock:
┌──────────────────────────────────────────────┐
│ ^(1[0-2]|0?[1-9]):([0-5]?[0-9])(●?[AP]M)?$   │
└──────────────────────────────────────────────┘
Hours and minutes, 24-hour clock:
┌──────────────────────────────────────────────┐
│     ^(2[0-3]|[01]?[0-9]):([0-5]?[0-9])$      │
└──────────────────────────────────────────────┘
Hours, minutes, and seconds, 12-hour clock:
┌──────────────────────────────────────────────────────────────┐

nisar1

# add all files to the index of the 
# Git repository
git add . 



# commit your file to the local repository
git commit -m "Initial commit" 

nisar1

DELIMITER $$

CREATE PROCEDURE `transaction_sp` ()

BEGIN

DECLARE exit handler for sqlexception
  BEGIN
    -- ERROR
  ROLLBACK;

nisar1

Try these different settings in C:\wamp\bin\apache\apache2.2.8\bin\php.ini

Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:

nisar1

SELECT AUTO_INCREMENT FROM information_schema.tables WHERE table_name = 'item_tbl' AND table_schema = 'db_sanitary2'

nisar1

CREATE PROCEDURE USP_SearchTables
 
 @Tablenames VARCHAR(500) 
,@SearchStr NVARCHAR(60) 
,@GenerateSQLOnly Bit = 0 
AS 
 
/* 
    Parameters and usage 
 

nisar1

CREATE TABLE #backup
(
  id BIGINT IDENTITY(1, 1),
  sptext NVARCHAR(MAX) NOT NULL,
  spname NVARCHAR(100) NOT NULL,
  encrypttext NVARCHAR(MAX) NULL,
  encryptstatus BIT NOT NULL
  DEFAULT ( 0 )
)
DECLARE @sptexttable TABLE

nisar1

Part I: Relational Database Design
  The Relational Database
  Design Objectives
  Terminology
Part II: The Design Process
  Conceptual Overview
  Starting the Process
  Analyzing the Current Database
  Establishing Table Structures
  Keys