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...
Posts
Showing posts from April, 2018