1, clear problem belongs to section
This will give a more professional person to help you solve problems faster, because different professionals, pay more attention to their familiar field, don't put the same question to ask questions to the multiple sections, found the section with similar themes,
Part have a net friend like to keep their problems in hot plate, such as: Access, MySQL, Oracle in SQL Server edition piece when Posting must indicate what is the database, the database programming language such as C # and best sent to the correct section, it is conducive to more effective problem solving,
2, ask questions to say as much as possible, provide simulation problem statements or provide data generated code
Is the prerequisite, so ask questions in what circumstances yourself as much as possible when a what kind of problems, or they want to achieve what kind of effect, problem description to lean as far as possible, save respondents read time,
In SQL programming problems, for example, when the expression is not clear the best provide simulation data and display effect
- the following simulation can be directly capture (Posting in the tool bar is inserted into the "image" icon) or post data
Question title: line transfer columns - the keywords accurate
The table name: Class
Student Course Score - column name
Zhang SAN Chinese 78
Zhang SAN mathematics 87
Zhang SAN English 82
Zhang SAN physics 90
Li si Chinese 65
Li si math 77
Li si English 65
Li si physics 85
- to achieve the effect:
Mathematical physics English language Student grade
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Li si, 77, 85, 65, 65, 292
Zhang, 87, 90, 82, 78, 337
- provide simulation table data script
Posting in the toolbar to insert "code" icon to select "SQL"
if not object_id is null (" Class ")
Drop table Class
Go
The Create table Class ([Student] nvarchar (2), [running] nvarchar (2), [Score] int)
Insert Class
Select N 'Joe', N 'language', 78 union all
Select N 'Joe', N 'mathematics', 87 union all
Select N 'Joe', N 'English', 82 union all
Select N 'Joe', N 'physical', 90 union all
Select N 'bill', N 'language', 65 union all
Select N 'bill', N 'mathematics', 77 union all
Select N 'bill', N 'English', 65 union all
Select N 'bill', N 'physical', 85
3, two questions best attach first link address to ask or to direct messages to the other party notice
is usually the first to ask questions after the solution and the subsequent problems, the connection address, convenient for the first time I see you question the zeal of a net friend, know before problem, easy to communicate effectively solve the problem of the second, the situation is a few people at the same time to answer your question, could you second question, the second question is more specific, you may direct messages for the first time to reply your enthusiastic netizen,
4, ask pay attention to the two don't, don't in other netizens post reply directly to ask questions, don't continue to ask questions on has knot stick stick son,
4.1. Usually appear netizens found similar problems, a direct questions, and questions from netizens problem resolved in each other's put a question, affect the normal Internet browsing content,
Before 4.2. Usually in problem solving and subsequent problems, directly in the junction labeled repeatedly ask new questions and direct messages, reply post and usually don't attention has had a direct messages a lot (DMS), the questioner would not solve their own problems in time,
5, if the problem to solve, don't forget to provide answers to reply on the score "" post"
If your problem is resolved, don't forget to help people respond to floor play score "knot", as to help people affirmation,
6, if you can not get the best answer for a long time, you can stick the closest answer score knot on
If the post is not solved for a long time, that is the problem baffled everyone, everyone may not be accurate reply your problem, then you can pick the best reply to help people score on the floor the answer and knot,
Some netizens in post didn't get the perfect solution, learn and draw lessons from the online method and train of thought to solve the problem, and they marked "no satisfaction" stick ", such behavior is not respect helped you, what is more answers are identified as "no satisfaction" stick ", also direct messages I help it solve the problem of subsequent new, personal view: if it is found that this type of account had such behavior, I will refuse to offer him any other problems, no matter whether or not your direct messages to inform me,
7, thanks for the help of others to
It is also important, because it is voluntary to learning platform, to build a harmonious community,
Note: the the above reference online content, then joint is essentially version is rearranging question instructions, SQL Server moderators have permissions to edit this post (such as the layout and content)
CodePudding user response:
Support large version.
CodePudding user response:
Support large version.CodePudding user response:
666666666CodePudding user response:
Top up and more splendid!CodePudding user response:
Jacking
CodePudding user response:
6666666666666666666CodePudding user response:
CodePudding user response:
CodePudding user response:
That's right, we should learn,CodePudding user response:
I to learn
CodePudding user response:
Support theCodePudding user response:
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull