Viewing 15 posts - 5,176 through 5,190 (of 8,416 total)
Digs (3/17/2010)
Ok so I think I will change the field to DATETIME.So how can i get this DATETIME field into a VARCHAR that looks like MM/dd/yyy
If, for some reason, you...
March 18, 2010 at 1:49 am
Another great instalment.
One thing for the section on inserting the contents of an XML variable when using 2005: there is a good workaround by Denis Ruckebusch here.
March 18, 2010 at 1:11 am
Nawar.Tabaa (3/18/2010)
Has any one tried it on a named instance with a default one of 2005?
I have a named instance of 2008 and a default instance of 2005 installed.
March 18, 2010 at 12:58 am
Henrico Bekker (3/18/2010)
How is SQL Server involved?
I'm also a bit confused Paul, just took a shot and hoped he meant, SQL notifications, to an outlook/exhange mailbox.
If not: this question...
March 18, 2010 at 12:57 am
Things are slightly different when an IDENTITY column exists on the table.
See The behavior of the IDENTITY function when used with SELECT INTO or INSERT .. SELECT queries that contain...
March 18, 2010 at 12:22 am
bramanthe (3/18/2010)
Thank you for reply. I will try your solution.
Let us know how you get on.
March 18, 2010 at 12:09 am
Did you see Michael's link?
Michael Valentine Jones (3/11/2010)
The scripts on the link below demos two methods for doing this.
The examples there show how to extend the method for a greater...
March 17, 2010 at 11:53 pm
Can't think of a direct T-SQL method, given the conditions, aside from to use regular expressions via a CLR routine.
March 17, 2010 at 11:50 pm
Can you post a CREATE TABLE definition for the destination table and a small amount of sample data to bulk insert?
You should not use sp_sqlexec; use sp_executesql instead.
March 17, 2010 at 11:48 pm
March 17, 2010 at 11:25 pm
Sandhya-371593 (3/17/2010)
It worked for me both on 2005 and 2008. Thanks so much !!!
No worries.
March 17, 2010 at 11:16 pm
Cool. Thanks for the feedback Drew.
March 17, 2010 at 10:45 pm
Lamprey13 (3/17/2010)
Actually, the second condition would be superfluous if included. 🙂
Thank you for that. Maybe it is just personal habit, but I usually include the conditions that cover a...
March 17, 2010 at 10:43 pm
DECLARE @command VARCHAR(MAX),
@script VARCHAR(MAX);
SET @command =
...
March 17, 2010 at 10:28 pm
Viewing 15 posts - 5,176 through 5,190 (of 8,416 total)