...

...

...

Bala Krishna, None of those results are surprising. If you examine the interim result of the `Convert` expression in each case, you will see that due to the number-literal being interpreted as an `int`, the resulting expression is never longer than 4...

The result for timestamp and rowversion is interesting. You can achieve this value another way, too: Substring(Convert(varbinary(10), 0), 0, 0) -- yields 0x This is like an empty string that has length 0--it is essentially a `varbinary(0)` val...

@Reuven is correct, and the original post has an error. However, the point being made is still valid, if only the error will be fixed. Just change `INSERT #temp1 VALUES(3)` to use #temp instead, and then adjust the wording "while the query with EXIST...

Any SSRS report is not re-displaying the changed information when running the same report back-to-back, even though the report itself is set with the following in the SSRS setup: Always run this report with the most recent data, Do not cache temporar...

Any SSRS report is not re-displaying the changed information when running the same report back-to-back, even though the report itself is set with the following in the SSRS setup: Always run this report with the most recent data, Do not cache temporar...

For what it's worth, you may want to update the title to be "Intelligent use of Intellisense". Normally I don't point out spelling in blogs or Just Learneds but given the subject--intelligence--I thought I'd try to help out. I couldn't find a way to mes...

Using regex to validate email addresses is very difficult. The regular expression you presented does work in many cases but is very basic. One example is that `+` is a valid character in an email name. You are going to make a lot of gmail users mad i...