Mmmm...  The following are the test cases, they are the expected results for non-compound primary key table definition:

-- test cases for insert with results

INSERT INTO tblNullable VALUES (1, 1, 1)

GO

(1...

I cannot change the table definition because it is defined by a client's database team.  Actually the real table definition has more than 5 columns which are defined as nullable column...

Hi there, I finally composed my 1st trigger and it works fine.  However, it doesn't work if I defined a table with compound primary keys.  The following is my test code, please...

I captured the profile info by putting SET STATISTICS PROFILE ON into both my stored procedure and Query Analyzer for the sql statment.  It returns somewhat different results between the two,...

Thanks for your info Antares686. The link you sent to me is broken; however, I can open a web site using msdn.microsoft.com. Is that a typo? Or...

Thank you guys, that is all I needed to know. Many thanks.

Oh, I am so sorry for the confusion of some missing codes and logic. Since my focus was in the dynamic sql string and the performance for the use...

I did it this way but not really satisfied because it seems to me that it is not the most efficient way. I still like my initial idea for...

That is actually my original design of my sp and it is still the design but added replace function before execute the sql statement(s). Again, I have no idea...

Well, I did mention the simple sql statement that passed in from the app interface before. Anyhow, here is the statement look like --> 'SELECT * FROM abc WHERE...

Of course, it is not a stupid suggestion but I have the basic requirements for my sp. The app pass in a sql statement and my sp has to...

First of all, many thanks for you guys response. I appreciate it. The basic requirements for my sp is simple, it must be able to store (temporary) in...

OK, may be I should mentioned about the requirements. I have no control on what a user creates a "creative" sql statement and pass in. Therefore, I cannot...

So, you can try a simple test like this and see what will happened! No to say INSERT into a table.

DECLARE @sql VARCHAR(5000)

SET @sql =...

That is what my initial design for my sp. I basically taking whatever the pass in string and simply insert the value in the table. But if the...