imp links

----1st Step---------------Create a Table---------------- CREATE TABLE UserRegistration ( C_Id int IDENTITY(1, 1) NOT NULL, C_Name varchar(100) NULL, C_Age varchar(100) NULL, C_Country varchar(100) NULL ); ----2nd Step---------------Create a Stored Procedure---------------- CREATE  procedure [dbo].[SpMyProcedure] ( @C_Id int = null, @C_Name varchar(100)= null, @C_Age varchar(100)= null, @C_Country varchar(100)= null, @Is_Active bit = 1, @Action varchar(100)= null --@flag bit output-- return 0 for fail,1 for success )   As begin if @Action='Select'   select * from UserRegistration   if @Action = 'Insert' Insert into UserRegistration values  (@C_Name, @C_Age, @C_Country,@Is_Active) if @Action = 'Update' Update  UserRegistration  set  C_Name = @C_Name,  C_Age = @C_Age,  C_Country = @C_Country where C_Id = @C_Id if @Action = 'Delete' --Delete from  UserRegistration  where  C_Id = @C_Id UPDA...

http://beginner-sql-tutorial.com/sql-subquery.htm http://www.c-sharpcorner.com/blogs/bitwise-operators-in-sql http://www.c-sharpcorner.com/UploadFile/a20beb/find-the-3rd-or-nth-highest-salary-in-a-table-way-1/

Learn Angular step by step (Covering Angular 2 and Angular 4) By Shivprasad Koirala (Part of Core advisory group of Indiamentor) www.indiamentor.com Contents About IndiaMentor.com ......................................................................................................................... 6 About the Author .................................................................................................................................... 6 Why should we Learn Angular ? ............................................................................................................. 7 How does this book teach you Angular ?................................................................................................ 7 Why do we need Angular ? ..................................................................................................................... 9 Lab 1:- Practicing NodeJS ...................................................................................