Hi Jacques

J-F Bergeron (9/3/2009)

---

Now that is REALLY interesting...

Is there a way to use a cursor, or a foreach, and cycle through a list of database servers?

We have 100 branches here,...

Hi Paul

Maybe you don't know where your data from, but I'm quite sure that you know the required destination for them.

I think a completely generic approach makes it impossible to...

Accidentally 😛

Noticed the menu item as I started with SSMS 2005 some years ago and remembered that SQLCMD is the new command line tool for SQL Server 2005. Thought "command...

Hi Tim

Could you please give a short description of what your procedure does?

Thanks

Flo

Thanks for the correction,...

Hi

You can use the UPDATE() function which is available within triggers:

USE tempdb

GO

IF (OBJECT_ID('TestTrigger') IS NOT NULL)

DROP TABLE TestTrigger;

GO

CREATE TABLE TestTrigger

(

Id INT NOT NULL IDENTITY...

Hi

Problem seems to be the size of your varchar not the type.

This works:

DECLARE @v VARCHAR(36);

SELECT @v = NEWID();

This doesn't work:

DECLARE @v VARCHAR(30);

SELECT @v = NEWID();

Greets

Flo

Hi

You can set your query window to SQLCMD mode (menu -> Query -> SQLCMD) and use the ":connect" method

:connect MyServer1 -U MyUserName -P MyPwd

SELECT @@SERVERNAME

GO

:connect MyServer2\MyInstance

SELECT @@SERVERNAME

Greets

Flo

Have a look to BOL (Books Online) for REPLACE and STUFF functions.

Everybody of us uses techniques stolen from somebody else. From a book, a thread, a blog or the guy next to us at work.

It's not just the answers you give,...

And you stay my mentor. 🙂

Glad we could help! 🙂

Thanks for the feedback

Hi Paul

Sorry for saying that, but this sounds like a coding for fun project. :crazy:

Probably this might be possible with hundreds and thousands of lines SQL using thinks like ISNUMERIC()...

Sorry, I miss read your post at first time... Try this

UPDATE m SET

m.Date = t.Date

,m.Description = t.Description

...

Hi washawgolla

Try to avoid the query-method. You can use value() directly:

DECLARE @xml XML

SELECT @xml = '

1

10629

10629

31524

31524

Gwadz

Marya

Viorst

102713

900017303

32166

2

2008-05-27T00:00:00

'

--code

SELECT x.legacy_data.value('(./id/text())[1]', 'int'),

x.legacy_data.value('(./prot/text())[1]', 'varchar(20)'),

...