Inline variable Assignment Process in Microsoft Sql Server 2008

Inline variable assignment in SQL Server 2008 enables to – declare, and assign the variables in a ‘single line’.

For example :

In Traditional Way :

DECLARE @myVar int
SET @myVar = 5

need to declare the variable and assigning it to the variable to split into 2 

lines and use 2 statements - DECLARE and SET.

In SQL Server 2008, as the name suggests ‘inline’, both declaration and assignment can be given in a single line:

DECLARE @myVar int = 5

How Microsoft Sql Server store pdf files

There are two ways to store pdf files in Microsoft sql Server.

1. To store pdf file in Microsoft Sql Server, create a column as type ‘blob’ in a table. Read the content of the file and save in ‘blob’ type column in a table.
2. Store pdf files in a folder and establish the pointer to link them in the database. 

Order of Query Execution in Microsoft SQL Server

SQL query is excuted in following order.

The query goes to the shared pool that has information like parse tree and execution plan for the corresponding statement. Then validates the SQL statement and validates the source(table).

Acquire locks.

Checks all the privileges.

Execute the query.

Fetch the values for SELECT statement

Displays the fetched values.

To sum up, the sequence is:

SELECT
FROM
WHERE
GROUP BY
HAVING 

Cross Join and Full Outer Join in SQL Server

Cross Join

There is no join conditions specified in Cross Join. Results will be Cartesian product of two tables participating in join. Results in pairs of rows.

Full Outer Join

It is combination of both left and right outer joins. Results in every row from both of the tables , at least once. It assigns NULL for unmatched fields.

Establish Remote Connection to Microsoft SQL Server Database

Establish remote connection in database using following process.

• Use SQL Server Surface Area Configuration Tool for enabling the remote connection in database. 
• Click on Surface Area Configuration for Services and Connections.
• Click on SQLEXPRESS/Database Engine/RemoteConnections
• Select the radio button: Local and Remote Connections and select ‘Using TCP/IP only’ under Local and Remote Connections.
• Click on OK button / Apply button.