救命：对数据库插入布尔值的问题

[kills]

请教，不用0和1，把一个bool值插入数据库，该怎么做？我插C#中的true和false不行

[stpangpang]

可以考虑用sql server 的bit 型

再使用case函数 显示出来你要的东西啊
sql server 2000的帮助中的的代码
USE pubs
GO
SELECT Category =
CASE type
WHEN 'popular_comp' THEN 'Popular Computing'
WHEN 'mod_cook' THEN 'Modern Cooking'
WHEN 'business' THEN 'Business'
WHEN 'psychology' THEN 'Psychology'
WHEN 'trad_cook' THEN 'Traditional Cooking'
ELSE 'Not yet categorized'
END,
CAST(title AS varchar(25)) AS 'Shortened Title',
price AS Price
FROM titles
WHERE price IS NOT NULL
ORDER BY type, price
COMPUTE AVG(price) BY type
GO