In SQL Server 2005, you would need three separate DELETE, UPDATE and INSERT statements. You can find an example (look at the last example) here: http://www.sqlservercentral.com/columnists/jSebastian/2912.asp

I did some search on internet to see there are any references to similar errors. The one given below looks interesting. http://social.msdn.microsoft.com/forums/en-US/sqlsmoanddmo/thread/94f476c9-6d22-44e2-ba15-0786c0dfffaa/

It speaks about two downloads/feature-packs and probably...

So what is the problem you are facing? Did you get an error?

I had tested it on SQL Server 2005 while writing the article. Did not test on SQL Server 2008 yet. However, I would expect it to work on SQL Server...

Try executing the scripts for each object one by one and this might help you to identify the statement that fails.

Jason Hall (10/15/2008)

---

Do you know how the debugger handles temporary tables and/or table variables. Can you watch the contents of these table objects while a script is debugging and...

Glad to hear that it helped

You can do this by prefixing the table with the database name. For example, the trigger in db1 can run something like "INSERT INTO DB2.dbo.TableName(column1, column2)....".

However, I would not recommend...

Use a CASE expression like the example given below:

SELECT

CASE INDEX_CODE WHEN 'Bnk' THEN 'BankDep'

ELSE Index_code

END AS IndexCode

from TableTest

Thanks,

Most people did not like the previous article because it was too short. May be they would like this 🙂

Configure database mail on the server and create a trigger in the table. Add the code to send an email using Database Mail. This article might help you to configure...

VARCHAR2 is not a valid data type in SQL Server.

Try the following

create table tbl (

name as varchar(50) not null

)

GO

insert into tbl (name)

Select name from account union

Select...

Another option:

SELECT * FROM SYS.COLUMNS

WHERE OBJECT_ID = OBJECT_ID('TableName')

This is how you can store it to a variable

IF EXISTS(

SELECT ID

FROM mytable

WHERE [Start] = convert(datetime,@Start,120)

AND [End] = convert(datetime,@End,120))

BEGIN

SELECT @Existing = 1

END...

You need to specify the table name after "alter table". For example:

create table schematest (data xml(ElementTest))

go

alter table schematest alter column data xml