sql语句如何实现换行写

sql语句怎么实现换行写
ADODataSet2-> CommandText= "select   *   from   a "
                                                + "where   v=1 ";

用“+”号连接不好用

------解决方案--------------------
不用+号，直接换行写

ADODataSet2-> CommandText= "select * from a "
" where v=1 ";
------解决方案--------------------
sql= "CREATE TABLE theTb \r "
"( \r "
"自动编号字段 COUNTER , \r "
"文本字段 CHAR(66) PRIMARY KEY \r " // 主键
") ";

------解决方案--------------------
strSQL= "select * from table \
where ID= '0001 ' \
and time= '2000-1-1 \
order by name ";
------解决方案--------------------
strSQL= "select * from table \
where ID= '0001 ' \
and time= '2000-1-1 \
order by name ";