now at the time of insertion i will enter like this
insert into test10 values ('book' ,1)
but at the time of display in the table i want
item state
book true
from above i want to ask that when i am going to insert 1 i want to
get true and 0 as false.I never enter true or false in the insert
command. please help me in coding and with an example as i am new to
SQL
thankyou,
lucky.
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Jean-Pierre FORESTIER
Hi Sorry, y're not on the right newsgroup!
-- Jean-Pierre FORESTIER Microsoft MVP PowerPoint Auteur de PowerPoint 2002 chez Micro Application "lucky" a écrit dans le message news:
Hai, Here is a query that i am creating a table
create table test10 (item varchar(10),state bit)
now at the time of insertion i will enter like this
insert into test10 values ('book' ,1)
but at the time of display in the table i want
item state book true
from above i want to ask that when i am going to insert 1 i want to get true and 0 as false.I never enter true or false in the insert command. please help me in coding and with an example as i am new to SQL thankyou, lucky.
Hi
Sorry, y're not on the right newsgroup!
--
Jean-Pierre FORESTIER Microsoft MVP PowerPoint
Auteur de PowerPoint 2002 chez Micro Application
"lucky" <j.v.s.s.baba@gmail.com> a écrit dans le message news:
1142489518.788915.108790@i40g2000cwc.googlegroups.com...
Hai,
Here is a query that i am creating a table
create table test10 (item varchar(10),state bit)
now at the time of insertion i will enter like this
insert into test10 values ('book' ,1)
but at the time of display in the table i want
item state
book true
from above i want to ask that when i am going to insert 1 i want to
get true and 0 as false.I never enter true or false in the insert
command. please help me in coding and with an example as i am new to
SQL
thankyou,
lucky.
-- Jean-Pierre FORESTIER Microsoft MVP PowerPoint Auteur de PowerPoint 2002 chez Micro Application "lucky" a écrit dans le message news:
Hai, Here is a query that i am creating a table
create table test10 (item varchar(10),state bit)
now at the time of insertion i will enter like this
insert into test10 values ('book' ,1)
but at the time of display in the table i want
item state book true
from above i want to ask that when i am going to insert 1 i want to get true and 0 as false.I never enter true or false in the insert command. please help me in coding and with an example as i am new to SQL thankyou, lucky.