|
|
-
|
|
The Regex functions are useful for changing the format of existing strings, for example, suppose you want to display Phone no in (ddd) ddd-dddd format instead of ddd-ddd-dddd. To do this, Right click on the required textbox --> click expression... and e...
|
|
-
|
|
Being into application support we check daily and weekly jobs schedule status that has been scheduled in SQL server in many servers for different projects. I wrote some queries to get the status as below.(if you have better solution please comment)
We ...
|
|
-
|
|
In .NET 4.5, .NET Framework team made two improvements to the large object heap. First, they significantly improved the way the runtime manages the free list, thereby making more effective use of fragments. Second, in Server GC Mode, the runtime balance...
|
|
-
|
|
Within an INSERT/UPDATE trigger, we can use the UPDATE() function to determine where a specific column is part of the updated/inserted column list. For example:
IF UPDATE(CustomerName) BEGIN
PRINT 'Customer name is being updated'
--...
|
|
-
|
|
In SQL server 2008 and above, select an opening bracket and press CTRL + SHIFT + ] and the SSMS Query window will highlight all the code between the selected opening bracket and the ending bracket. ...
|
|
-
|
|
I just learned that SQL server (2008) was the last commercial database to support spatial data But then SQL Azure is the very first CLOUD based database to support spatial data. ...
|
|
-
|
|
Unfortunately SSIS does not provide regular expression or an IsNumeric check which is required very often to validate the data. I came across a neat work around. Here it goes:
In the derive column set up the following expression for a new column.
(...
|
|
-
|
|
Type “prop” and press tab 2 times it create property for you just give data type and name of property you would like to create....
|
|
-
|
|
To format number to two decimal point into SSRS (Reporting Services),
1. goto Properties, in **Format** enter **n2**...
|
|
-
|
|
System.Json new namespace available in net 4.5
we can parse json with JsonValue in net 4.5. ...
|
|