I need to know the identity column (EventId) When the Trigger Got Fired i know tha can be done by Select EventId From inserted But what i am not...

There is one point that i forgot to tell that the rows insertions are done by more that one appliication running simultaneously

just i need dynamic exectution of query that i didnt get

Thank you all for your valuable responses

Jonathan' s Method has solved my problem.

Thank you again

jonathan

Hello Thomas,

Thanks for your valued comments.

this solves my problem to some extent

agin i am not able to fix the problem completly because when i create function like i have...

anayone can help me to get that its urget

Can be used this way also

quote:

---

Create Function DateOnly(@dt DateTime)

returns Datetime

as

begin

return Cast(convert(varchar(8),@dt,1) AS datetime)

end

CREATE Function TimeOnly(@dt DateTime)

returns datetime

as

begin

return Cast(convert(varchar(8),@dt,8) AS...

Let me correct myself

i need the result like this

 

Select *,fnTest123(SomeTable.SomeField) Result From SomeTable 

there is much more than Points that i earned by answering the question that in future i can think this thing in my mind that i am always not wrong...

quote:

---

That's correct, you can't use sp_executesql inside a UDF. Why do you need a function? You could wrape this code...

But Somehow i am again where i was before

when i create the function using same statements

Example:

Create Function fnTest123()

Returns varchar(255)

As

Begin

declare @sql nvarchar(4000)

declare @Params nvarchar(4000)

declare @name varchar(255)

select @sql =...

quote:

---

use sp_executesql with an output parameter, like this:

declare @sql nvarchar(4000)

declare @Params nvarchar(4000)

declare @name varchar(255)

select @sql = 'Select @name = name from sysobjects...

page designing is not in layout tables or anything used for formatting the pages is not correct also left navigation menu must have z-index greater than the ad displayed benethe

where...

Hi Venkata,

can u be give me details

Hi to all,

Thanks for your response

but the problem still persist

i need to know that is their any way to convert from one time zone to anoyther without hampering the...