No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
[code=sql]DELIMITER $$ DROP PROCEDURE IF EXISTS `hrprocess_temp`.`sp_alltabinsert1` $$ CREATE DEFINER=`invensis`@`%` PROCEDURE `sp_alltabinsert1`(empid varchar(10),fname varchar(45),lname varchar(45), fathername varchar(30),dob varchar(20),gender varchar(6),maritalstatus varchar(9),spousename varchar(15),children varchar(8), commadd varchar(250),permadd varchar(250),mobileno varchar(15),landlineno varchar(15),email varchar(40), languages varchar(25),nationality varchar(25),bloodgroup varchar(5),drivingno varchar(20),panno varchar(15), passportno varchar(15),imagepath varchar(100),resumepath varchar(1000),skill varchar(250),deptname varchar(30), Course varchar(20),Specialize varchar(35),institute varchar(25),PassYear varchar(10), Organization varchar(25),Designation varchar(25),FromDt varchar(15),ToDt varchar(15),ReasonsChange … 
|
|
|
i have one table.i.e Employee.my empoyee table having 22columns. i used below code.but i got error [CODE] DELIMITER $$ CREATE PROCEDURE sp_search ( ) begin declare str varchar(255); set str="select * from Employee"; EXEC(str); end $$ DELIMITER ; [/CODE]
|