STOP!! There is a hidden trap...

What is the data type of the current column employeeno?

If it's any numeric data type (e.g. INT), the update statement will fail.

Before updating a column...

Yes. That simple. 😉

The question is in the title:

Something like

CREATE PROCEDURE NameHere AS

SELECT...

hoanglong88i (1/3/2011)

---

First, I wish Lutz, Harin and other members a new year full of health and joy 🙂

Thank Lutz again, with your solution, now I know how to reference to...

Edit: original statement partially removed.

However, if the view is defined at SQL Server side, it should work. At least the following code does:

USE tempdb

GO

CREATE TABLE [a/totally silly / TABLE...

Andy Warren (1/3/2011)

---

Lutz, totally agree that security is a concern, especially if the physical implementation of the cloud is in a different country. Not arguing that it fits all cases,...

Ouch. :blush: Link added. Thanx Gail. (It's the Disk Is...

There is one additional major concern to bring up (and it has been done frequently already in other articles/threads): data security.

Currently, most companies have a strict regulation who has direct...

duplicate post. Please reply here

@sqlpassion: please don't start a new thread with the same content shortly after the initial just because you didn't get any immediate reply.

There are several possibile...

Just have a look at my previous post... 😉

"does not work" is a rather vague statement. Can you post the code you're using and the related error message ?

Here's the solution I came up with.

I'm using the "quirky update" method with safety check as described here. Please follow the link mentioned in that post and read the related...

Barry,

a very Happy and Healthy New Year!!

JD,

With reference to your other recent thread you really seem to love the DISTINCT key word, do you? 😉

Due to the names used in that sproc let me ask: is...