| |

VerySource

 Forgot password?
 Register
Search
View: 1268|Reply: 11

The SQL statement is wrong ...

[Copy link]

1

Threads

3

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

Post time: 2020-1-13 15:20:01
| Show all posts |Read mode
select * from guestbook order by gst_time desc I always feel that this sentence is wrong .. It is a bit like MYSQL ... but how should SQLSERVER be changed?
Reply

Use magic Report

0

Threads

66

Posts

27.00

Credits

Newbie

Rank: 1

Credits
27.00

 China

Post time: 2020-1-16 20:18:01
| Show all posts
Yes
Reply

Use magic Report

1

Threads

3

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

 Author| Post time: 2020-1-16 20:27:01
| Show all posts
MYSQL and SQLSERVER are the same?
Reply

Use magic Report

0

Threads

66

Posts

27.00

Credits

Newbie

Rank: 1

Credits
27.00

 China

Post time: 2020-1-16 21:09:01
| Show all posts
Yes, there are no syntax errors, reverse the order of gst_time
Reply

Use magic Report

1

Threads

3

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

 Author| Post time: 2020-1-17 01:36:01
| Show all posts
Oh. . Thanks. ..
Reply

Use magic Report

0

Threads

66

Posts

27.00

Credits

Newbie

Rank: 1

Credits
27.00

 China

Post time: 2020-1-17 03:00:02
| Show all posts
--#
Reply

Use magic Report

0

Threads

17

Posts

12.00

Credits

Newbie

Rank: 1

Credits
12.00

 China

Post time: 2020-1-17 07:09:01
| Show all posts
select * from guestbook order by gst_time desc
Reply

Use magic Report

0

Threads

48

Posts

30.00

Credits

Newbie

Rank: 1

Credits
30.00

 China

Post time: 2020-1-21 17:45:01
| Show all posts
ansi sql
Reply

Use magic Report

0

Threads

100

Posts

53.00

Credits

Newbie

Rank: 1

Credits
53.00

 China

Post time: 2020-1-21 19:54:01
| Show all posts
Nothing wrong.
Reply

Use magic Report

0

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-1-21 21:45:01
| Show all posts
I think there is something wrong, just check it with the query analyzer ...
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