Viewing 10 posts - 316 through 325 (of 325 total)
I wrote something similar in my current job, but using purely dynamic SQL and using a table (in any database, including temp tables) as the source rather than a query...
June 6, 2017 at 12:09 am
Knut Boehnert (4/18/2013)
As long as there is always the same column used then it is fine and won't need a recompile.
As always, it depends. If the distribution of values in...
April 17, 2015 at 11:10 am
Sean Lange (2/4/2015)
andycadley (2/4/2015)
dmcquade (2/3/2015)
Is there a downside to using the IsNULL function? For example, using the COUNT script when I try:SELECT COUNT(IsNULL([Name], ''))
I get 8 as the result
It'll probably...
February 5, 2015 at 12:58 am
dmcquade (2/3/2015)
Is there a downside to using the IsNULL function? For example, using the COUNT script when I try:SELECT COUNT(IsNULL([Name], ''))
I get 8 as the result
It'll probably be slower than...
February 4, 2015 at 1:18 am
Charles Kincaid (1/30/2015)
February 1, 2015 at 2:47 am
SQLMaister (1/30/2015)
January 30, 2015 at 1:57 pm
nvm, others said it better....
January 30, 2015 at 1:18 am
How long is the path it's getting stuck on? Does it contain any "weird" characters like square brackets, etc?
June 6, 2014 at 4:54 am
Jeff Moden (6/3/2014)
I'm thinking that would make the process batch-job resistant.
How so? You can still specify the parameters on the command line, you can even specify them positionally and it'll...
June 3, 2014 at 7:58 am
Useful, but I'd avoid using the args[] variable and do it "the Powershell way" with a Param block at the start of the script, that way you get things like...
June 3, 2014 at 6:46 am
Viewing 10 posts - 316 through 325 (of 325 total)