SQL error! The master helps solve it! 10

Manually set an interrupt and output the SQL statement.

And then I see you can figure out the rest on your own.

The method of debugging is very important.

insert into Table 1(Field 1, Field 2, SZRQ) values('1','2',cstr(nian+"-"+yue+"-"+ri))

I wrote Fields 1 and 2, change them yourself according to your needs.

If the field corresponding to SZRQ is char, then your date format is arbitrary, whatever you want! If it's date, it's not pulled. Conversion to date() is required'nian+"-"+yue+"-"+ri','yyyy-mm-dd'According to the error message, your column name may not correspond!

You didn't post the sql either. You can only guess and pull.

SZRQ is of type char??? The char type in SQL Server cannot be modified.

It should work in insert though!

If you're using SQL Server, put:"Instead'Try it, it seems that you can only use single quotes in SQL!

First of all, I think your train of thought is a bit confusing :

char a[100],m;The foundation is not good, char is a character, str is a string;

When comparing letters, if you compare them one by one, it will take longer and the space is larger, your o(100 2),o(100 2); Mine is o(100*52), o(100*52);

When comparing the number of times, it's confusing, your o(100), o(100); My o(52), o(52), and just compare it once;

Finally, I personally think that gets() and printf don't match, and the input and output should match each other to make mistakes;

Hehehe, I'm sorry, your program has been modified beyond recognition.

ps I don't have software installed on my computer, so I haven't tried whether the program is feasible, you can try it yourself!!

#include

#include

void main()

int i,j,b[52]=;

for(i=0;iscanf("%s",a)

for(i=0;i<52;i++) to compare a to 52 letters

for (i=0;i<52;i++) because b and m take care of each other

printf("%c %d",flag,max);

There are a lot of mistakes, I'll just say a few:

1.There is no end condition, which means that your program will enter an endless loop after running and will not be able to exit normally2People want to input multiple lines and output the result together.,You can only input one line and the result will be output.3.

I didn't look at the details in it, because it looks tired, how can there be a program written like this, a, b, c, i, j, m, n variables, the ghost knows what it means, so short and tired to look at, if it's a longer program, you can't see it at all.

1."The length does not exceed 100"If the maximum value is 100 characters, the character array a should be at least 101, i.e., char a[101].

2.This implementation is not the best, it is better to open an array count that records the number of occurrences of the character, with the character as the subscript. For example, there is a character'a', then the corresponding count['a'+ You can improve it with this idea.

I'm coming, I'm coming

The procedure is as follows: include

#define max ‘z’

#define min ‘a’

#define enter ‘’

#define zero 0

#define name l

int main(void)

for(num=min;num<=max;num++)text[num]=zero;

printf("the program is end.");

return 0;

abcd abcd abcd abcd

With the test case above, the result is d 3You see if it's missing (if there are multiple characters with the same number of times, only the smallest character in the ASCII code is output).

Parties, games, playgrounds, relaxation.

1。If you are an introvert, you can look in the mirror and say why you are introverted, and then vent every time you fail because of introversion, and then do more things that you think are brave.

2。You can look at the jokes more, and then learn to tell them to your relatives and people who are not afraid, and then gradually tell them to your classmates, and if this is successful, you will not be afraid of everything else.

3。This is a very common problem, I used to be like this, but you only need to be very sure of yourself, and then treat the people in the audience as a machine, so that slowly you will not tremble, this is my experience, I hope you can add points.

Your main problem is a lack of self-confidence. You are a person who strives for perfection, and if you are not 100% sure that you will not speak easily, you are afraid that when you say it, you will expose your ignorance.

I think it's a process that most adolescent kids have to go through, and the solution is simple:

1. Make a few intimate friends, the sincerity between friends is mutual, if you want to get the sincerity of others, you must first treat others sincerely.

2. Since you can realize this problem, then it is not a big problem, and if you can do the first one, it can be solved.

3. It doesn't matter, everyone is the same at the beginning. Exercise more, make more remarks in public, such as positive teacher questions in class, participate in school activities more, show yourself more, and gradually you will not have stage fright.