It means that one of the queries inside the isnull function returns more then 1 value, which is not allows. Here is a small demonstrations of the subject:

--returns an...

SQL Server has no arrays or lists. You can try sending it as XML and then use Xquery to get the values that were sent. Another alternative is...

Is there any question in this statement? If there is can you try to explain...

jinesh.i (1/7/2010)

---

Hi,

When I tried

DECLARE @Table TABLE

(

Matrix_User_ID INT --PRIMARY KEY IDENTITY(1,1)

,OldFirst_Name VARCHAR(20)

,NewFirst_Name VARCHAR(20)

)

BEGIN TRAN

UPDATE MSTR_User

SET First_Name=UPPER(First_Name)

OUTPUT inserted.Matrix_User_ID,deleted.First_name,inserted.First_name INTO @Table

WHERE Matrix_User_Id =1294

SELECT * FROM @Table

ROLLBACK TRAN

SELECT * FROM @Table

It returned row...

Sanz (1/6/2010)

---

Yes.. Tried that but it returns the following message...

Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291

There are no matching rows on which to report.

Correct me...

Did you try using sp_helprotect?

Adi

VALEK (1/6/2010)

---

The question is trying to test the knowledge of temp tables with TSQL transactions, and does it very badly.

There is not enough information.

You should not require any database...

I’m sorry, but this question is not a good one. With the information that we got from the question, there is no way that can know how many...

Dave Ballantyne (1/5/2010)

---

SQLServer doesnt destroy the variable when it drops out of scope, for instance this works

declare @l integer

select @l = 1

while(@l<10) begin

declare @x integer

...

You can check it with the procedure sp_change_users_login (you can read about it in BOL). If the needed logins don’t exist in the new database, you’ll need to create...

Personally I have to admit that I’m surprised that you don’t get a run time error saying that you are declaring a variable that was already declared. I guess...

This is what it means, but this is because January first 1952, is out of range for both smalldatetime and datetime data types, while January first 1953 is not out...

Personally, I’d do it in 2 different triggers because I’m doing completely different actions in both scenarios. Having said that, you can create 1 trigger and check if the...

Notice that using the IsDate function has some issues. Sometimes it can lead to surprising results as you can see from the small script bellow:

if isdate(1752) = 1

select convert(datetime,...

This is because your function is returning a string instead of datetime (or smalldatetime). You should return a datetime datatype and compare it to your dates.

One...