nisar1

According to the MySQL docs you can only cast to: 

    BINARY[(N)]
    CHAR[(N)]
    DATE
    DATETIME
    DECIMAL[(M[,D])]
    SIGNED
    [INTEGER]
    TIME

nisar1

-- Lists sp,tbl,fn in a dbz

--show procedure
SHOW PROCEDURE STATUS WHERE Db = DATABASE() AND TYPE = 'PROCEDURE';
SHOW FUNCTION STATUS WHERE Db = DATABASE() ;
select name from mysql.proc where db = database();

--list keys
select *
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS

nisar1

jQuery(document).ready(function () {
  jQuery.fn.clickToggle = function (func1, func2) {
        var funcs = [func1, func2];
        this.data('toggleclicked', 0);
        this.click(function () {
            var data = jQuery(this).data();
            var tc = data.toggleclicked;
            jQuery.proxy(funcs[tc], this)();
            data.toggleclicked = (tc + 1) % 2;
        });

nisar1

 jQuery('.barmenu').click(function () {
      var lwidth = '260px';
      
      if (!jQuery(this).hasClass('open')) {
          jQuery('.rightpanel, .headerinner, .topbar').css({ marginLeft: lwidth }, 'fast');
          jQuery('.leftpanel').css({ marginLeft: 0 }, 'fast');
          jQuery(this).addClass('open');
      } else {
          jQuery('.rightpanel, .headerinner, .topbar').css({ marginLeft: 0 }, 'fast');
          jQuery('.leftpanel').css({ marginLeft: '-' + lwidth }, 'fast');

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

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

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

nisar1

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

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

DELIMITER $$

CREATE PROCEDURE `transaction_sp` ()

BEGIN

DECLARE exit handler for sqlexception
  BEGIN
    -- ERROR
  ROLLBACK;