MS SQL Server MS SQL Server SQL Windows Server 

How to configure SQL server to access it remotely

How to configure SQL server to access it remotely?, Actually this is not a big issue there are some straightforward steps to configure, but there might be a possibility of giving problem after configure using the same steps also. So go through the below steps carefully. To establish a successful remote connection is to set up ports through the Window Firewall. In SQL Server there are two types of instances. First is a default instance and the second is a named instance. To connect to the default instance of Database…

Read More
MS SQL Server BackEnd Programming MS SQL Server SQL 

Stored Procedure Vs Function in MS SQL Server

Stored Procedure: A set of SQL Queries which are used to perform a specific task. A stored procedure can improve the performance of a database. Function: A  set of SQL Queries which can be used to pass parameters into and return values from it. Difference: Sl.No Stored Procedure Function 1 Compiled only once Complies every time the function is invoked 2 Input and Output Parameters are permitted Only input parameters are permitted 3 Need not necessarily return a value A return value is necessary 4  A Function can be invoked…

Read More