as per your requirement, i think you can achieve this through function, why you are tring to use trigger can you explain a bit about your logic.

create a udf where...

thanks paul,

i will check it.

thanks dev to clarify it.

sry need slight modification in the xml. value part of the code

you have to use this to get the value from @Message.

@Message.value('(MessagesWaiting/ReturnMessage/@id)[1]', 'nvarchar(40)') AS ReturnMessageID

i would like to make some comments on this,

1) would u please like to post ur ddl for [SW_ReturnMessages] table.

2) you are inserting into [SW_ReturnMessages] table as waitingmessageID as scope_identity()...

Thanks dude,

i got it, as i was new to visio i was found it little confusing.

the steps i follow i am mentioning here, it might help somebody else.

visio

1) open a...

u can use like this.

update table1 set table1.col1=table2.col1

from table1 t1 inner join table2 t2 on t1.id=t2.id

Really nice article tom. i come to know so many uses of information_schema. good one thanks.

The error itself is self explanatory, if your file is in the same machine and copy the files complete path and use it.

can you post your DDL and your query with some sample data. that we can follow.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Mr. rams you have already started a thread on this topic, do continue on that

pleas don't repeat the same question in multiple thread.

Mr. Rams provide us your DDL, table definations, keys, constraints with sample data and your desired output you want. the more details you provide, it would be easy for us...

we can use debugger on sql 2008 onwords, but there are some configuration to be made for this

follow this link to get the idea how to use it.

It depends,

let take an example of an update statement, if the number of rows effected by the statement is one or little more it will put row level lock, if...

can you post your DDL properly with constraint of two tables. as per me your table design is not correct.

you should have deptid in emp table as department is a...