Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG: sp and conditional temp table
Message
De
23/05/2005 05:52:18
Jon Neale
Bond International Software
Wootton Bassett, Royaume Uni
 
 
À
23/05/2005 05:15:16
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01016662
Message ID:
01016667
Vues:
10
I'm not sure what your doing so this may not be what your looking for.

But how about:

CREATE PROCEDURE dbo.test1
@choice bit = 0
as
exec('select CAST( ' + @choice + ' as varchar(1)) X from #temptable')

You have vastly more experience than me so excuse the answer if its not what your after.

Jon

>Someone knows an setting in order to jump this stupid error,
>and compile this simple sp:
>
>CREATE	PROCEDURE dbo.test1
>	@choice bit = 0
>as
>	if @choice=0
>		SELECT 1 x INTO #TEMPTABLE
>	else
>		SELECT 0 x INTO #TEMPTABLE
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform