Other mode is box mode selection, to do this, use the Shift + Alt + Arrow Key or use Alt + Mouse left button, this selection resembles as given below
After set the property, click on the “Apply” button then Click “ok” button to exit the window. Now you need restart the SQL Server Services to update the changes.
Hope it Helps!
CAT.NET is a binary code analysis tool that helps identify common variants of certain prevailing vulnerabilities that can give rise to common attack vectors such as Cross-Site Scripting (XSS), SQL Injection and XPath Injection.
You can set this Format by,
In SQL Server Management Studio,
Tools à Options à Environment à General à Environment Layout à Select Option you Desire Here, Either MDI (Multiple Document Interface) or Tab.
See the screenshot
If you use MDI environment, you can see only one window at time. If more than one window is opened, you can activate other window by using Ctrl + Tab keys.
Here I opened many query windows, due to MDI Options, it will shows one will be active, as shown in the screen shot.
If you use Tab Document, you can see Multiple Tabs on the Query windows, you can switch over any window by Ctrl + Tab keys or Click on the Tab
Hope it helps to someone.
One of my friend requested me a code of Javascript to validate the time, which is in the format of 00:00 (24 hrs). i written this code. it may useful to someone, so that i posted in this blog
function Validate24Hrs(Time_Field) {
RegEx = "\([0-2][0-9]):([0-5][0-9])$";
Err_Msg = "";
{
if (Regs = Time_Field.value.match(RegEx)) {
if ((Regs[1] > 23)) {
Err_Msg = 'Not Matching';
}
}
else {
Err_Msg = 'Not Matching';
}
}
if (Err_Msg != "") {
alert(Err_Msg);
Time_Field.focus();
return false;
}
else {
alert('Matching');
return true;
}
}
if it is useful or face any problem, please leave ur valuable comments here.
Have a Great Day!
Hi,
Have a look at this link.
Download Hands on Lab of SQL Server 2005
This link provides "Hands on Lab of SQL Server 2005" for the followings, and it is a downloadble
Hope it helps you!
In SQL percent keyword helps to retrieve %age of records from a table.
Have a look at this sample query, In AdventureWorks database, Sales.SalesOrderHeader contains 31465 records, in the following query we are going to retrieve almost 10% of records
USE AdventureWorks
GO
SELECT top 10 percent * FROM Sales.SalesOrderHeader
This query will return 3147 records
In previous versions of SQL Server, TOP operator used only to return the number of rows or a percentage in SELECT queries. In SQL Server 2005, 2008 or later versions, you can use TOP in DELETE, UPDATE, and INSERT queries and can also specify the number of rows (or percent) by using variables or any valid numeric returning expression (such as a subquery). The main reason for allowing TOP with DELETE, UPDATE, and INSERT was to replace the SET ROWCOUNT option, which SQL Server traditionally didn't optimize very well.
You can specify the TOP limit as a literal number or an expression. If you're using an expression, you must enclose it in parentheses. The expression should be of the bigint data type when you are not using the PERCENT option and a float value in the range 0 through 100 when you are using the PERCENT option.
Following Sample Query is a sample Example for delete with Top
-- Top with delete query
delete top (2) from dbo.table3
-- Top with Subquery
USE AdventureWorks
GO
SELECT TOP (SELECT COUNT(*) FROM Sales.SalesPerson)
SalesOrderID, RevisionNumber, OrderDate
FROM Sales.SalesOrderHeader
ORDER BY SalesOrderID
| CustomerID | Y2001 | Y2002 | Y2003 | Y2004 |
| 1 | 40732.6067 | 72366.1284 | NULL | NULL |
| 2 | NULL | 15653.6715 | 12118.0275 | 4962.2705 |
| 3 | 39752.8421 | 168393.7021 | 219434.4265 | 51925.3549 |
| 4 | NULL | 263025.3113 | 373484.299 | 143525.6018 |
| 5 | NULL | 33370.6901 | 60206.9999 | 20641.1106 |
