Viewing 15 posts - 2,206 through 2,220 (of 14,953 total)
Brandie Tarvin (1/18/2012)
In case anyone is interested, the text of SOPA (the House bill) can be found here: http://www.gpo.gov/fdsys/pkg/BILLS-112hr3261ih/pdf/BILLS-112hr3261ih.pdfThe text of PIPA (the Senate bill) can be found here:
And the...
January 18, 2012 at 12:47 pm
What happens if you have a cursor step through the rows in sys_mail tables that you need, and call sp_send_dbmail using the values from that table?
I've done that before, but...
January 18, 2012 at 12:45 pm
By unprintable characters, do you mean extended character set? Like Chinese "letters" and that kind of thing? Or do you mean ASCII instruction characters, like the tab-left character?
January 18, 2012 at 11:42 am
Edit: Misread what fahey was trying to do. Never mind.
January 18, 2012 at 11:26 am
Are you using SQL 2000 or something later (forum is 2005, but I don't like to assume on that)?
In SQL 2005 and later, you should Varbinary(max) instead of Image as...
January 18, 2012 at 11:18 am
This is about the 10th time the idea of rep on this site has been discussed since I've been here, and I still don't see a valid "solution". Nor...
January 18, 2012 at 10:56 am
Cadavre (1/18/2012)
adrian.facio (1/18/2012)
Did you tried it before your change??
Admittedly, the answer to that is "no".
However IMO, to avoid ambiguity, whether or not your method works is irrelevant. ...
January 18, 2012 at 9:55 am
Any reason to still be using @@Identity instead of an Output clause?
January 18, 2012 at 9:50 am
TravisDBA (1/18/2012)
January 18, 2012 at 9:48 am
On the original question, definitely go with an Output clause.
If you insert all the companies at one go, and use Output Into to dump the names and their IDs into...
January 18, 2012 at 9:26 am
fahey.jonathan (1/18/2012)
The OUTPUT clause is going to work only with the MERGE statement.
Huh???
Output works with any of the data modification actions. Not just Merge.
January 18, 2012 at 9:21 am
Viewing 15 posts - 2,206 through 2,220 (of 14,953 total)