SQL server-CodePudding

Dear bosses, help to take a look at this code what went wrong, why it is wrong to query results

CodePudding user response:

 where right (cname, 2)!

='system'

CodePudding user response:

 where cname like N '% system

CodePudding user response:

The

reference 1/f, February 16 response:

 where right (cname, 2)!='system'

No, the query results or wrong

CodePudding user response:

refer to the second floor of gypsy song response:

 where cname like N '% system

It is wrong to still query results

CodePudding user response:

reference 4 floor CFHHHHH response:

Quote: refer to the second floor of the gypsy song response:

where cname like N '% system

Is still the wrong query results

What's the result of the mistake? You want to post up,
Incomplete information is not detailed, somebody else can't help you, post is also a technology...

CodePudding user response:

reference 5 floor gypsy song reply:

Quote: refer to 4th floor CFHHHHH response:

Quote: refer to the second floor of the gypsy song response:

where cname like N '% system

Is still the wrong query results

What's the result of the mistake? You want to post up,
Incomplete information is not detailed, somebody else can't help you, post is also a technology...

Find the reason, I define the data type is char (10), I input the corresponding column content "information system" back when it automatically give me growth for 10 string, and when I query query is "% system"

CodePudding user response:

refer to 6th floor CFHHHHH response:

Quote: refer to the 5 floor gypsy song response:

Quote: refer to 4th floor CFHHHHH response:

Quote: refer to the second floor of the gypsy song response:

where cname like N '% system

Is still the wrong query results

What's the result of the mistake? You want to post up,
Incomplete information is not detailed, somebody else can't help you, post is also a technology...

Find the reason, I define the data type is char (10), I input the corresponding column content "information system" back when it automatically give me growth for 10 string, and when I query query is "% system"

Hey hey, number of Posting too inexperienced, after know the

thank you