Earlier on Beyondrelational I read a tip, for the same topic. combination of keys Shift + Print screen, allows us to take screen shot of Remote Desktop. But recently I faced problem using these keys. It allowed taking print screen only once. Every ot...

If you use "select * into" to create a new table from an existing table having a primary key, then the new table will not have a primary key by default....

There are four schedule types. 1. One Time : It executes once as per the schedule 2. Recurring : It is recurring type and execute on specified interval on specified time till schedule end. 3. Start when CPU Idle : It executes when CPU is sufficien...

Hello friends, one interviewer asked that suppose you have two tables `Employee_Details`, `Employee_Details_History` now I want to delete original table `Employee_details` and maintain it’s history to other table. How can it’s possible with only ...

Start > Programs > high-lite any item on the Menu and right click > Sort by ...

In SQL Server 2008, We have a feature to select multiple lines with specific characters. In SQL Server 2012, we can append the same text to multiple lines. Below images will give the clear picture to understand this feature. Some times we need to ad...

In SQL Server 2008, We have a feature to select multiple lines with specific characters. In SQL Server 2012, we can append the same text to multiple lines. Below images will give the clear picture to understand this feature. Some times we need to ad...

Hi, We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName. ![SSMS Hint][1] Today , i learned another method to do the same, **Select the query** and **right click**...

Hi, We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName. ![SSMS Hint][1] Today , i learned another method to do the same, **Select the query** and **right click**...

A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances. A Tool can do the things as below: 1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replica...