Hello,

Just want to know whether trigger is fired after every insert statement or after every transaction......

awaiting for ur reply

This is my execution string

exec [PTH_DeploymentStatus_PR1] 1,1,'D','2007-12-12 00:00:00.000','2009-12-28 19:06:53.940','1,0'

which gets the resultset but if i change the date as

exec [PTH_DeploymentStatus_Pr1] 1,1,'D','2007-12-12 00:00:00.000','2010-09-21 19:06:53.940','1,0'

Then i get an...

ya but if i increase the size thn too i m getting the same error

Pls suggest......

But im getting null values for last node

Please help me out ,its urgent

create PROC [dbo].[PTH_Overall_SecUpdate_Byfurcation_DPMA_PR1]

(@OUTXML xml output)

as

begin

...

Hi,

declare @table table

select * into @table

from abc

Am i need to give all columns in table variable or else can i do directly copying from table1 to table variable.......In...

what is dmv ?

can a non- clustered index provides better performance than clustered index.

Pls let me know