Dear Lowell,

Thanks for your comments.

Actually I use the "SqlCommand.ExecuteNonQuery Method" in my c# applications. Here is the partial codings in program :

-------------

//program body

....

...

Hi Lawerance,

Thank you for your suggestions.

I will try to implement by using the stored procedure.

Regards,

Edward

I achieve my goal now...:D

Many many thanks to all of you... 😛

Have a nice week-end like me ! :laugh:

Sorry to tell you it can't work.... :crying:

I issue the following codes :

DECLARE @ExStr varchar(500)

SET @ExStr = 'CREATE TABLE dbo._X080805 (

[ICno] [int] NOT NULL DEFAULT (0),

[Xdate] [smalldatetime] NOT NULL

)...

It can't work !!

A table named (@Fname) is created !

I change to codes as follows:

..

CREATE TABLE [dbo].[(@Fname)] (

..

Is the change correct ?

Thanks for your help.