|
|
-
Jeff Moden Commented 6 Days ago through Blogs
I also agree that things like email shouldn't be sent in a trigger and I agree that the CC can take some of the burden when sending the same email to multiple people, but it would be awfully nice if you could send a result set to the intrinsic email que...
|
-
Jeff Moden Commented 6 Days ago through Blogs
Short and Solid. Nice post, Nakul....
|
-
Jeff Moden Commented 7 Days ago through Blogs
I didn't down-vote the two posts above but understand why they were down-voted...
The first one doesn't actually address performance (which is what Madhivanan's question is all about), at all.
The second answer doesn't explain why "cursors are a b...
|
-
Jeff Moden Commented 8 Days ago through Blogs
@Jahid,
p.s. Don't expect to be able to print out the variable and see more than 8,000 characters because SSMS doesn't like to do such a thing. Rather, use LEN() to confirm that the variable holds more than 8,000 characters....
|
-
Jeff Moden Commented 8 Days ago through Blogs
@Jahid,
Look again. The variable used by Madhivanan is a VARCHAR(MAX) which will hold up to a binary 2 billion characters, which is a tidu sum more than a mere 8,000.
If you are stuck in SQL Server 2000 or less, then it is very likely that you wi...
|
-
Jeff Moden Commented 10 Days ago through Blogs
> Thanks Jeff Moden for your valuable
> feedback. Whenever there is a post
> about tally number table, I always
> refer your article.
I'm truly humbled, ol' friend. Thank you....
|
-
Jeff Moden Commented 15 Days ago through Blogs
Nicely done and thank you for the honorable mention.
I've also seen single column Holiday and other reference tables, some of which are also used for "Pull Down" menus in applications....
|
-
Jeff Moden Commented 2 Months ago through Blogs
Since closing the conection in Step 7 effectively ends the session, you don't have to drop the Temp Table. It will drop all by itself. As a matter of fact, if the script is used a whole lot, there's a benefit to NOT explicitly dropping the Temp Table....
|
-
Jeff Moden Commented 2 Months ago through Blogs
Nicely done, Nakul. I still use this method instead of Table Valued Parameters. It just seems easier....
|
|
|