| |

VerySource

 Forgot password?
 Register
Search
View: 1143|Reply: 6

Question mark appears in the stored procedure display results, urgent

[Copy link]

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-3-9 22:00:01
| Show all posts |Read mode
Query results using stored procedures, one of which shows a lot of nvarchar ??? Question mark

what's up
Reply

Use magic Report

0

Threads

126

Posts

73.00

Credits

Newbie

Rank: 1

Credits
73.00

 China

Post time: 2020-5-31 17:45:01
| Show all posts
Is there any character set data that is not installed in other systems in this column?
Reply

Use magic Report

0

Threads

114

Posts

69.00

Credits

Newbie

Rank: 1

Credits
69.00

 China

Post time: 2020-5-31 19:15:01
| Show all posts
Exceeded the maximum length?
Reply

Use magic Report

0

Threads

9

Posts

9.00

Credits

Newbie

Rank: 1

Credits
9.00

 China

Post time: 2020-5-31 22:30:01
| Show all posts
The nvarchar type should not be. Didn't add N when inserting, you open the table directly to see if it is also?
Reply

Use magic Report

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 Hong Kong

 Author| Post time: 2020-6-1 01:45:01
| Show all posts
It is normal to open the table in SQL, but the result of the query through the stored procedure has a question mark
Reply

Use magic Report

0

Threads

93

Posts

46.00

Credits

Newbie

Rank: 1

Credits
46.00

 China

Post time: 2020-6-1 20:45:02
| Show all posts
Is caused by the defined sorting
Reply

Use magic Report

1

Threads

17

Posts

15.00

Credits

Newbie

Rank: 1

Credits
15.00

 Hong Kong

Post time: 2020-6-3 08:45:01
| Show all posts
ls, how to define sorting?
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list