SQL date and join Functions

The time requirements in sqlserver are as follows:

If the source or target column is not of the string type, the corresponding format string is ignored.

The following are available Standard date format strings:

• Dd Mmm YY

• Dd mmmm YY hhmm
• Dd mmmm YY hhmmss. FF
• Dddd mm/DD/yy hh: Mm TT
• Dddd, Mmmm DD, yyyy hh: mm: Ss. FFFF TT
• Hh: mmtt

Today, I did not pay attention to this problem. A colleague made a small mistake. While obtaining the date and time format, the colleague did not use format for formatting. In this way, the system reports an error, originally, the Tester Used a strange setting in the local time settings, so there was an error in sqlserver. In fact, this problem was encountered before, the format must be used to store data of the date type in sqlserver. To reduce the interference of large local formats, this problem can also affect character encoding, some users are willing to change the time zone to North Korea and Japan, so there will be conflicts in coding, so the best software should try to avoid interference in this aspect.

There is also the join function. In the past, the longest use of the split function in VB was the split function, which was rarely used in the join operation. I used it today. It feels good and can save a lot.CodeIn some cases, good things are under your eyes, that is, you don't need:

Description

Returns a string created by concatenating multiple substrings in an array.

Syntax

Join (Sourcearray[,Delimiter])

JoinFunction syntax has the following naming parameters:

Part	Description
Sourcearray	Required. Contains a one-dimensional array of connected substrings.
Delimiter	Optional. The characters used to separate the substrings in the returned string. If this option is ignored, a space ("") is used to separate the substrings. IfDelimiterIf it is a zero-length string (""), all the items in the list are connected with no Separator in the middle.

In addition, when using TD, we found that progress bars were used in many parts of TD. This is a good idea. It is not a bad thing to use progress bars in the system. Pay attention to them later.