Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding a boolean field in select
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00843725
Message ID:
00843732
Vues:
24
SELECT CAST(0 AS bit) AS completed, ...
>I'm used to adding a few fields to a query that don't belong to the table I'm getting data from like (assume table has two fields id int, and name char(30):
>
>select id, name, 0 as completed from mytable
>
>How can I go about a similar select but adding a boolean field to the resulting datatable versus integer?
>
>Select id, name, false as completed from mytable
>
>Doesn't work.
>
>TIA
>
>Terry
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform