wsprintf函数有字节限制啊//d:\vs03\win32_sql\win32_sql.cpp(147): error C2026: 字符串太大,已解决方法

wsprintf函数有字节限制啊????//d:\vs03\win32_sql\win32_sql.cpp(147): error C2026: 字符串太大,已

TCHAR wide_sql_splite_statement[512*10] = {0};
wsprintf(wide_sql_splite_statement,L"insert into sms_song_diff_analyse(diff_state,song_code,song_name,file_name,language,star,edition) \
select 1 flag,song.song_id,song.song_name,song.song_relative_path,song.language,song.singer_name,song.song_version from song \
where not exists (select 1 from (select song.accompany_sing_track,song.guid_track,song.song_name,song.language,song.singer_name,\
song.spell_first_letter_abbreviation,song.song_version,song.song_relative_path,song.new_song_date from song,song_from_access \
where song.accompany_sing_track=song_from_access.accompany_sing_track and \
song.guid_track=song_from_access.guid_track and \
song.song_name=song_from_access.song_name and \
song.language=song_from_access.language and \
song.singer_name=song_from_access.singer_name and \
song.spell_first_letter_abbreviation=song_from_access.spell_first_letter_abbreviation and \
song.song_version=song_from_access.song_version and \
song.song_relative_path=song_from_access.song_relative_path and \
song.new_song_date=song_from_access.new_song_date \
) equal_data \
where equal_data.accompany_sing_track
");  

------解决方案--------------------
用这个试试

wsprintf(wide_sql_splite_statement,L"insert into sms_song_diff_analyse(diff_state,song_code,song_name,file_name,language,star,edition)"
        "select 1 flag,song.song_id,song.song_name,song.song_relative_path,song.language,song.singer_name,song.song_version from song "
        "where not exists (select 1 from (select song.accompany_sing_track,song.guid_track,song.song_name,song.language,song.singer_name,"
                "song.spell_first_letter_abbreviation,song.song_version,song.song_relative_path,song.new_song_date from song,song_from_access "