Posts

Showing posts from April, 2018
Export 2 Excel using EPPlus create table EPPlus ( Id int, fname varchar(255), lname varchar(255), addr varchar(255), salary int, gradute bit, dob datetime ) --------------------------------------------------------------------------------------------------------- insert into EPPlus values (1,'harshal','desai','mumbai',10000,1,getdate()) insert into EPPlus values (2,'sneha','gaikwad','mumbai',20000,2,getdate()-10) insert into EPPlus values (3,'sachin' ,'tendulkar','mumbai',30000,3,getdate()-250) --------------------------------------------------------------------------------------------------------- CREATE PROCEDURE tableA  AS        SELECT id, fname, lname, addr FROM EPPlus GO CREATE PROCEDURE tableB  AS        SELECT id, salary, gradute, dob FROM EPPlus GO ----------------------------------------------------------------------------------------------------- ---Make Sure You install...