|
|
-
|
|
VS 2010 also now supports importing/exporting pinned DataTips to XML files – which you can then pass off to other developers, attach to a bug report, or simply re-load later.
To export the datatips, choose Debug -> Export Datatips
To import the datati...
|
|
-
|
|
While debugging code, we wants to see the variable data to be always visible, i.e. pin to solution, even when execution is away from the variable. In this scenario, Visual Studio 2010 provides variables data to be pinned.
While debugging, select the va...
|
|
-
|
|
Visual Studio 2010 ultimate provides a feature "Intellitrace", which helps to developers to get information about the errors, which are difficult to produce. Enabling the intellitrace will provide you the detailed trace information, which records all th...
|
|
-
|
|
Visual studio 2010 provides an important feature, "Bookmarks", which can be used to mark the certain locations in code and use them for later reference.
You can create a bookmark by pressing Ctrl+k,Ctrl+k on a line. On creating a bookmark, this will c...
|
|
-
|
|
In Visual Studio 2010, we can import external styles and change the look and feel of visual studio. We can find some styles in "http://studiostyl.es"
1. Go to "http://studiostyl.es" and download any of the style.
2. In VS 2010, Go to Tools -> Import an...
|
|
-
|
|
Until silverlight 4, while saving a file using FileDialog, we can't specify "DefaultFileName" property. User has to explicitly specify file name. Now in
Silverlight 5, FileDialog has an property "DefaultFileName", by using which, we can specify the def...
|
|
-
|
|
Often in financial applications, its required to calculate End date of a month. SQL Server 2012 provides a function EOMONTH() to calculate end date of a month.
DECLARE @Currentdate DATETIME
SET @Currentdate = '12/12/2010'
SELECT EOMONTH (...
|
|
-
|
|
Until SSIS 2012, in annotations, to enter multi-line text, user has to do it in text-editors or by pressing Ctrl+Enter. Now in SSIS 2012, annotations support entering multi-line text. By just pressing enter key, we can insert text in next line.
![alt ...
|
|
-
|
|
In few scenarios, our packages might contain a lot of items, which makes very difficult to understand those. Now in Denali, you can group these items, which gives better look and feel, and a new user can simply understand, what’s happening inside the pa...
|
|
-
|
|
This functions will return columns values from subsequent rows in the same result set without the use of a self-join.
Example:
DECLARE @Users TABLE(
UserID INT IDENTITY,
UserName VARCHAR(20)
)
INSERT INTO @Users (UserNa...
|
|