vyelchri (6/23/2009)

---

Thank you for your quick reply..

i have created the table and trigger in my database and i did some modifications in one stored procedure. when i clicked on execute...

Ok, this works but does not return the number of times the procedure is modified. Anyway is a nice way to return last...

You can use the PIVOT operator, but I think this is not as flexible as you would expect.

Anyway this code does the trick.

DECLARE @Invoices TABLE (

InvoiceNumber int,

BillName varchar(10)

)

INSERT...

You can use database triggers to accomplish this task.

I use this simple one:

1) Code for destination table:

CREATE TABLE [dbo].[ChangeLog](

[LogId] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,

[DatabaseName] [varchar](256) NOT NULL,

[EventType] [varchar](50) NOT...

This could sound like a silly reply, but, what about optimizing the query so that it runs faster on the linked server?

Are you running the query with OPENQUERY / EXECUTE...

Looks a lot like this one.

Please don't post duplicates.

Gianluca

Try using a temp table instead. Table variables exist only in the scope they're defined in.

Take a look at this article[/url]: it's an excellent resource for a complete understanding of...

I look forward hearing from you.

Good luck!

You might also be interested in taking a look at this article on dynamic search conditions.

I think it is one of the best resources on the topic.

Regards

Gianluca

Try with this:

SELECT *

FROM table

WHERE Id = COALESCE(@id,Id,-1)

I chose -1 as a non existent value for Id to exclude NULL values for Id column, but this depends on the data...

Well done, Gail!

I think this is going to be part of many people's signature like Jeff's article on posting best practices.

Some Java jdbc drivers turn prepared statements into...

That's right Gail, I'll edit my previous post.

Mjarsaniya, you can use the dynamic sql when the columnname is determined at...

The problem is with the variable, you can't use it that way. You should define the whole alter statement in a string variable and the execute it:

DECLARE @sql nvarchar(4000)

SET @sql...

You could do it splitting the parameters into a table with a script like this:

http://www.sqlservercentral.com/scripts/T-SQL+Aids/31871/

There are lots around, even more efficient, with tally tables or with loops, just pick one.

create...