AFAIK, image or varbinary(max) are not supported by raw data files. (BTW: image data type is marked as deprecated. You should move to VARBIANRY(MAX)).

If both sides are SQL Server, you...

If your view contains something like this

SELECT * FROM FooTable

... and you want to see your new columns automatically after adding to your table, have a look to BOL for...

Hey Lutz!

Been busy last time. It's always hard for a (primary) .net-dev to stay too much in sql. It's...

?

Try MAX with an included CASE WHEN.

Greets

Flo

Are you sure that your statement is correct? You don't use "B" anywhere. (BTW: Try to get rid of this old join-style)

Greets

Flo

You could save your script with SQLCMD variables and call it via xp_cmdshell.

Greets

Flo

I'd also suggest using Service Broker.

Why are you looking for another solution?

tan110 (1/27/2010)

---

its weird, when I run:

declare @ TimeVal varchar(16); -- Added space between @ and TimeVal to get code to post

set @TimeVal = '00.13.00';

select @TimeVal, cast(replace(@TimeVal,'.',':') as time)

declare @ TimeVal...

If your columns wouldn't have a name, how would you access those columns in your next SELECT?

As Dave wrote, why not using a incremental default name like col1, col2, ......

Hi

Guess you are looking for a scalar function, not a procedure. This enables you to directly return a value into a scalar variable.

-- scalar function

DROP FUNCTION GetAmount;

GO

CREATE FUNCTION GetAmount(@productId INT)

...

Interview

Hi weitzera

Sorry for the late feedback.

... and thanks for this lesson. Apparently I did all my test wrong. So there seem to be only two ways to get correct identity...

Hi weitzera

weitzera (1/20/2010)

---

A couple of notes on Florian's post:

The sample script works because you're using Table variables, which are local to the scope. If you use real tables, it...

Hi %

It's possible to use bulk insert operations if table containing...