Posts

Showing posts from August, 2017

resgination mail

Dear Sir,          Kindly informed that I am submitting this letter for the purpose of resigning from the post of Software Engineer from SWASH Convergence Technologies Limited effective from today. Therefore, the last day of work for me here will be Today. The purpose of this resignation letter is to inform you that I will be leaving my position with Swash Company, effective long Period from now on August 11. my family is currently in the process of relocation that I will be relocating to the Hyderabad City metropolitan area in the near future. From the time I joined SWASH Convergence Technologies Limited as Software Engineer One year’s one Month ago, I have enjoyed immense professional growth and forged unbreakable bonds of friendship. I have received an abundance of support, advice, and encouragement from my superiors, and for that I shall be always grateful. I would like to special thanks our CEO , Dr. Pritam Pal for his coo...

3-6-years-experienced-Net-professional

http://www.dotnetspider.com/resources/44635-Interview-Questions-3-6-years-experienced-Net-professional.aspx

create multiple primary key in a single table

CREATE TABLE CUSTOMERS (    ID   INT               NOT NULL,    NAME VARCHAR ( 20 )      NOT NULL,    AGE  INT               NOT NULL,    ADDRESS   CHAR ( 25 ) ,    SALARY   DECIMAL ( 18 , 2 ),             PRIMARY KEY ( ID , NAME ) );

create procedure

----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...

sub-query in sql

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 JS step by Step

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 ...................................................................................