Web
Analytics
SQL Server | Tutorial

For Consultation : +91 9887575540

Stay Connected :

user defined sql function in sql server

user defined sql function in sql server

create function ganesha(@id int) returns int as begin declare @work int select @work=avg(salary) from emp_info where id=@id; return @work; end; declare @my int select dbo.ganesha(1) b) alter function myfun(@date datetime) returns varchar(50) as begin declare @myoutput...

sql joins in sql server

–Self Join select *from emp as p where p.salary=p.gsalary –Equi Join select d.*, e.* from dept as d , emp as e where d.id=e.deptids –Inner Join select d.*, e.* from dept as d inner join emp as e on d.id=e.deptids –Outer Join –Left Outer...
triggers in sql server

triggers in sql server

create trigger getid on [login] after insert as select @@identity as mynewid insert into [Login](username ,password) values('aabc','bbcc') disable trigger getid on [login] enable trigger getid on [login] create trigger trig_uppercase on [state] after insert ,update as...
How to take all database backup in sql server

How to take all database backup in sql server

Generally we face a problem when we want to upgrade our sql server management studio version , all the databases are lost. To take all database backup one by one is completely irritating. To overcome this irritating job , our sql provides a great solution to take all...

Stored Procedure in sql server

Stored Procedure: Set of logical group of SQL statements which are grouped to perform a specific task. Benefits of Using the Stored Procedure Reduces the amount of information sent to the database server. Compilation step is required only once when the stored...
Select your currency