Viewing 15 posts - 5,281 through 5,295 (of 8,416 total)
Steve Jones - Editor (3/16/2010)
Yep, #7, many moons ago.
Same guy - very different shirt :laugh:
March 16, 2010 at 8:55 am
Use SQLCMD mode straight from SSMS...easy!
See http://msdn.microsoft.com/en-us/library/ms174187.aspx for details, and an example 🙂
Example preview:
:out C:\testoutput.txt
SELECT @@VERSION As 'Server Version'
!!DIR
!!:GO
SELECT @@SERVERNAME AS 'Server Name'
GO
March 16, 2010 at 8:42 am
Thanks for the information, Grant.
I am suddenly more motivated.
March 16, 2010 at 8:38 am
TedS (3/16/2010)
March 16, 2010 at 8:35 am
Roy Ernest (3/16/2010)
I got my $500 yesterday. If I can write an article there, anyone here can write it for sure. 🙂
Is there a publicly-accessible link to it?
March 16, 2010 at 8:18 am
Chris Morris-439714 (3/16/2010)
It fooled the hippo?
Disturbing...:hehe:
March 16, 2010 at 8:15 am
Grant Fritchey (3/16/2010)
Yeah, it was absolutely top notch. Too bad he didn't write it for the Standard. I would have paid more. 😀
$500!!!
But, you must:
Have 5 years professional experience as...
March 16, 2010 at 8:12 am
mbricker-600840 (3/16/2010)
I used to work for a company that had a frozen marguerita machine in the kitchen
Why would anyone freeze a marguerita machine? 😛 :w00t:
March 16, 2010 at 7:52 am
nraaj.del (3/16/2010)
@SSCarpal Tunnel,Allright, but i want seperate application would be stored procedure, so could i send SMS through Stored procedure.
My name is Paul 😛
The stored procedure should just write...
March 16, 2010 at 7:47 am
Lynn Pettis (3/16/2010)
Good point. This is definately one I should look at now before I don't have time to go back and fix it later.
That's odd, I did not...
March 16, 2010 at 7:43 am
You can use IF UPDATE or COLUMNS_UPDATED, see Programming DML Triggers for details and examples.
March 16, 2010 at 7:31 am
Eralper (3/16/2010)
You can find reference documents about the code for sql split string function
Yikes. XML is not the right tool for the job when it comes to string splitting.
The...
March 16, 2010 at 7:04 am
Store the data describing the message you want to send to a queue table.
Write a separate application to read from that table and send the messages.
March 16, 2010 at 6:58 am
Way too much code. If you can present your problem using a simple example, you will get a better answer, faster.
March 16, 2010 at 6:52 am
vijay.s (3/16/2010)
Unpivot is the best way to achieve this task.
It has certainly been suggested at least twice already, but I am intrigued to know how you can say it is...
March 16, 2010 at 6:50 am
Viewing 15 posts - 5,281 through 5,295 (of 8,416 total)