sql server tutorial | Angular | ASP.NET Tutorials

sql joins in sql server

by Yogesh | Jun 25, 2016 | 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

by Yogesh | Jun 24, 2016 | 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...

sql joins in sql server

triggers in sql server

Other Tutorials

Click here for more stuff