sql qurery如何设置空值 [英] sql qurery how to set null value

问题描述

专家！!!!


我为选择数据创建了一个查询，此查询仅选择表的5个字段，

此查询还用于填充dataTable，dataTable中的所有列均存在.所以它给错误.

因此如何只对列目标使用选择查询，由于数据表繁重，我不选择所有列数据.

在快照查询中从任何特定的列" 中选择空值.

hi expert!!!!


i create one query for select data and this query select only 5 field of table,

this query also use for fill dataTable, in dataTable all column present. so its give error.

so how can use select query with only column destination, i don''t select all column data because of heavy datatable.

in shot query for select null value from any particular "column".

推荐答案

Try:

Try:

SELECT a AS a, null AS b, null AS c, d AS d FROM myTable

这篇关于sql qurery如何设置空值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！