|
|
-
Cris Commented 9 Months ago through Blogs
Another question would be...
Is there ever a real world case for including the NULL keyword in a COALESCE call?
COALESCE(NULL, AddressLine1, @myVar1, NULL, AddressLine2, @myVar2, NULL)
Under what circumstance would any of the NULL's above be of...
|
-
Cris Commented 9 Months ago through Blogs
But getting to the original question:
The reason why
select coalesce(null,null,null) returns an error
but
select coalesce(null,null + 1,null) returns null
is because...
|
-
Cris Commented 9 Months ago through Blogs
RE: SELECT(COALESCE(null * 3, '') returning NULL
Manoj is correct. It depends upon the datatype.
Another way to see this is SELECT(COALESCE(null + 'x','y'))
This will return the value 'y'.
But SELECT(COALESCE(null + 1,'y'))
will return this ...
|
-
Cris Commented 11 Months ago through Interview Questions
The **WHERE** clause is a filter that is applied against the tables in the query statement to determine which rows will be included in the result.
The **HAVING** clause is a filter that is applied **after** the selected rows have been aggregated with...
|
-
Cris Learned 1 Years ago through Just Learned
These properties are useful when you export reports to Excel workbooks. Use the **InitialPage** property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the **PageName** property to provide dif...
|
-
Cris Liked 1 Years ago through Just Learned
These properties are useful when you export reports to Excel workbooks. Use the **InitialPage** property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the **PageName** property to provide dif...
|
-
Cris Learned 1 Years ago through Just Learned
These properties are useful when you export reports to Excel workbooks. Use the **InitialPage** property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the **PageName** property to provide dif...
|
-
Cris Liked 1 Years ago through Just Learned
These properties are useful when you export reports to Excel workbooks. Use the **InitialPage** property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the **PageName** property to provide dif...
|
-
Cris Commented 1 Years ago through Pages
Eric, sry I dnt hv tm 2 rd yr cmnt....
|
-
Cris Commented 1 Years ago through Interview Questions
I also misunderstood the original question.
I thought the question was asking if it was possible to be logged into a database and execute code to create a trigger on a table in a different database.
Yes that can be accomplished.
If the question...
|