All about sp_addlinkedserver syntax

sp_addlinkedserver linked 2 servers. Once sp_addlinkedserver query executes, query can be run against these servers. Run below queries one by one to link, to provide login credentials and to access data EXEC sp_addlinkedserver @server=’ServerName’ EXEC sp_addlinkedsrvlogin ‘ServerName‘, ‘false’, NULL, ‘username’, ‘password’ select * from [ServerName].[DBName].[DBO].[TableName] Once your requirement is done, you may drop the linking by … Read more

Why we use Cookie?

What is Cookies? Cookies here refer as Web Cookies, HTTP Cookies is a small piece of code stored at user’s machine by bowers. Why we use Cookies ? To collect demographic information about who is visiting the Web site. Sites often use this information to track how often visitors come to the site and how … Read more

What is Service Oriented Architecture?

Service Oriented Architecture (SOA) is a style to design software system where 2 or more component communicates with each other over a network through a defined protocol. Advantages of SOA architecture. Loosely Couple – A component in SOA architecture must be loosely coupled. One service does not require to know the technical and platform details … Read more

Learn OOPS concept in simple and easy way

In this blog, We will see Object Oriented Programming Principal in simple and easy way. What is Object Oriented Programming Concept? Object oriented is an approach to do programming in C#, Java etc. Before object oriented programming structural programming model was in use. C programming language is an example of  structural programming. But the problem … Read more

How to Crop and Upload image using JQuery

In this blog, I will explain how to crop an image and then upload that image using jQuery. Here you will come to know about preview an image, and then crop that image and finally upload it using jQuery and C# code.  This implementation has been done using jQuery, so no post back only smooth … Read more