Learn Little bit More

we can use comma separated values as input in sql. For this we should use some xml queries. Use the below query. declare @emp_id varchar(6000) set @emp_id ='clkl23,kjlj90,89kjm,88474ur,' select distinct employeename from employee where emp_id in( SELECT t.c.value('.', 'VARCHAR(6000)')            FROM (                  SELECT x = CAST('<t>' +                   REPLACE(@emp_id, ',', '</t><t>') + '</t>' AS XML)                 ) a      CROSS APPLY x.nodes('/t') t(c) )

Asp.net Core is the free,open source and cloud optimized web framework which will run on any operating system such as windows,linux and mac.It is a new technology developed by Microsoft. now we'll see vividly about Asp.net core. Asp.net core applications will run on windows,linux and mac. So we don't need to build separate application for different platforms using different frameworks. Asp.net web applications can be hosted in multiple platforms with any web server such as IIS,apache and so on.It is independent. Asp.net core application runs on Dotnet core framework. Asp.net MVC and Web API have been merged into one. Inbuilt dependency injection. Json based project structure  Compilation is done with new Roslyn real time compiler.

Triggers are special type of procedures which fire implicitly or automatically.There are 2 types Triggers available in sql.They are 1.DDL Triggers 2.DML Triggers 1.DDL Triggers                              This trigger will fire while doing DDL operations. (e.g)  create trigger Employee on database for create_table,alter_table,drop_table as print'you can not create ,drop and alter table in this database' rollback; 2.DML Triggers                              This trigger will fire while doing DML operations. (e.g) create trigger deep on tblemp for insert,update,delete as print'you can not insert,update and delete this table ' rollback;

Introduction Entity framework core is the new version of Entity framework .It is an Object Relational Mapping framework .In olden days we were using ADO.Net to connect database from backend. We can use it even now also. However Entity framework has some advance features to connect ,access and store data from various databases.Entity framework is the enhancement of  ado.net . Types of Entity Framework Core                  Entity framework core has 2 approaches .They are 1.Code first 2.Database first 1.Code first     In this approach database and tables  are created EF Core. 2.Database first     In this approach domain and contexts are created EF Core from the existing database. Parts of Entity Framework Core DbContext Class              The dbcontext ...

Live your life as if there’s no tomorrow. Think as if this is your last day in the world because if you will do your best in everything you will have no regrets. Be adventurous. Conquer your fears. Don’t let your emotion control you. Be unique. Don’t be afraid to be different because sometimes being different is good. Be a risk-taker to have a good career. If you wouldn’t try and explore new things you wouldn’t be able to learn in life. Life will teach you how to live. Your failures, mistakes and success will either make or break you. Study hard and work hard. Always smile it gives people happiness as well to you. If you smile other people will also smile. Be a good person. Help those people who are in need. Believe in what you truly believe Love yourself, your family and your friends. Share your love to everybody because every human being in this world deserve to be loved. Treasure your loved ones. Find friends who will make you push to work harder, who encourage and inspi...

Mummy your saree is like the sky Mummy your saree is like the sky Mummy your saree is like the sky Make a cradle to sleep ,make a swing to play to catch fish in the river, to dry the fathers head Make a cradle to sleep ,make a swing to play to catch fish in the river, to dry the fathers head want to cuddle it if see cover me if i die by it want to cuddle it if see cover me if i die by it Mummy your saree is like the sky Mummy your saree is like the sky if act inside the tank it is beautiful coral garland, your saree will cover if fingers injure the saree which you wear is giving a tear fragrance if your saree bring water it will be sweetest as sugar it will be spreaded as a peacock feather inside my soul it will give light if it is fired your saree is flower garden. Mummy your saree is like the sky Mummy your saree is like the sky For sisters training,for pasture the goats to stop the sunlight by covering the upstair Mummy...