Hi Ken,
Thanks for your explaination! It helps me.
Zili

-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Thursday, August 30, 2001 8:19 PM
To: sql language
Subject: [sql_language] RE: Can table name be a parameter in stored p
roce dure ?


No, the 3D is something that your email client is putting in - get rid of
those...

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Zili Liu" <liu@Q...>
To: "sql language" <sql_language@p...>
Sent: Friday, August 31, 2001 8:13 AM
Subject: [sql_language] RE: Can table name be a parameter in stored p roce
dure ?


: Hi Francois,
:
: I run the following code. I still get many errors.  Can you try to  run
the
: code when you have tim?
: I don't understand 3D. Is it alias for its following string?
:
: Thanks!
:
: Zili
: --------------------------------------------------------------------------
--
: -------------
:
: IF EXISTS (SELECT name
:    FROM   sysobjects
:    WHERE  name = N'sp_createTable'
:    AND   type = 'P')
:     DROP PROCEDURE sp_createTable
: GO
:
: CREATE PROCEDURE sp_createTable
: @tableName varchar(6)
: AS
: BEGIN
: DECLARE @strSQL varchar(500)
:
: SET @strSQL =3D 'IF EXISTS(SELECT name FROM sysobjects WHERE  name 
: =3D3D '
: SET @strSQL =3D @strSQL + @@tableName
: SET @strSQL =3D @strSQL + ' AND type =3D3D 'U') DROP  TABLE ' + 
: @tableName
:
: EXEC (@strSQL)
:
: SET @strSQL =3D 'create table ' + @tableName + '(cityID int not null 
: =3D'
: SET @strSQL =3D @strSQL + 'primary key, cityName varchar(25) )'
:
: EXEC (@strSQL)
:
: END
:
: GO
: ------------------------------------
:
:
: C
:
: -----Original Message-----
: From: Francois_Vallieres@I...
: [mailto:Francois_Vallieres@I...]
: Sent: Thursday, August 30, 2001 2:52 PM
: To: sql language
: Subject: [sql_language] RE: Can table name be a parameter in stored p
: roce dure ?
:
:
: Hi Zili,
:
: Did you put the line DECLARE as follow (I think I didn't put the SET 
: before)
: :
:
:
: BEGIN
: DECLARE @strSQL varchar(500)
:
: SET @strSQL =3D 'IF EXISTS(SELECT name FROM sysobjects WHERE  name 
: =3D3D '
: SET @strSQL =3D @strSQL + @@tableName
: SET @strSQL =3D @strSQL + ' AND type =3D3D 'U') DROP  TABLE ' + 
: @tableName
:
: EXEC (@strSQL)
:
: SET @strSQL =3D 'create table ' + @tableName + '(cityID int not null 
: =3D'
: SET @strSQL =3D @strSQL + 'primary key, cityName varchar(25) )'
:
: EXEC (@strSQL)
:
: END
:
:
: And your @tablename should be put in the parameter of your sp.