I need to print to a log printer as a redundant fail-safe for a sports scoring application. I would like to print the values of several fields each time an insert occurs. I already have a trigger that fires on insert. Is there a way to use xp_cmdshell to copy values to a printer port or to a printers IP address?
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.