select cast(id as nvarchar(4000))+','+cast(name as nvarchar(4000))+','+cast(age as nvarchar(4000))+','+cast(weight as nvarchar(4000)) from person
可以不用那么麻烦的,直接利用Rtrim或Ltrim select Rtrim(id)+','+Rtrim(name)+','+Rtrim(age)+','+Rtrim(weight) from person Or select Ltrim(id)+','+Ltrim(name)+','+Ltrim(age)+','+Ltrim(weight) from person
select cast(id as nvarchar(4000))+','+cast(name as nvarchar(4000))+','+cast(age as nvarchar(4000))+','+cast(weight as nvarchar(4000)) from person
那要是想把这值在web上输出,那该怎么做呢?例如用asp
select Rtrim(id)+','+Rtrim(name)+','+Rtrim(age)+','+Rtrim(weight) As Info from person Or select Ltrim(id)+','+Ltrim(name)+','+Ltrim(age)+','+Ltrim(weight) As Info from personInfo可以改为你想要的字段名然后就可以用和你平时打开记录集,得到字段值一样的做法来得到Info这个字段的值了
select Rtrim(id)+','+Rtrim(name)+','+Rtrim(age)+','+Rtrim(weight) from person
Or
select Ltrim(id)+','+Ltrim(name)+','+Ltrim(age)+','+Ltrim(weight) from person
Or
select Ltrim(id)+','+Ltrim(name)+','+Ltrim(age)+','+Ltrim(weight) As Info from personInfo可以改为你想要的字段名然后就可以用和你平时打开记录集,得到字段值一样的做法来得到Info这个字段的值了
Rtrim的实际作用 去掉字符串右边的空格这里是巧妙利用一下这两个函数,以免转化字段类型写的那么长。可以查看联机帮助来了解这两个函数的用法。