Wktsai.blogspot.com Website Review

is a simple SQL, the role should not be big, but for me it is quite easy to use, it can be regarded as a simple exercise with the transposition here is not In the PIVOT and UNPIVOT of the hub an*lysis, but the transposition of the simple data presentation, I really think that this horizontal situation sometimes looks very messy, so I rewrote the related CODE DECLARE @DBCatalog NVARCHAR(128) = N 'tempdb' DECLARE @DBSchema NVARCHAR(128) = N'dbo' DECLARE @DBTable NVARCHAR(128) = N'temptable' DECLARE @Condition NVARCHAR(MAX) = N'ID = 1' The data transposition action was reached. However, if you need to return multiple pieces of information, there will be some problems. Of course, this should also be a problem that the presented SQL adjustment may solve, just because I just want to see a specific single payment. Unexpectedly, I don’t think about how to deal with that small problem. Maybe it can be processed through PIVOT. It may be because of work factors, the need to convert files, because they found that they have been encrypted files. 0A is automatically added to a 0D in front of it, which causes me to decrypt it. I wrote a program to rule out this situation, but I want to confirm if it might affect the operation of the normal program, so I found the Unicode code distribution. Information and keep it for your own reference. In many cases, I love to put the pick list into the Table variable. In most cases, he is effectively improved and the Table has a scope that is only executed in the current state. After leaving, it automatically expires, so I don't need to clean it up, and The benefits of values ​​that are not manipulated by others during use. However, I encountered a performance bottleneck when I used it yesterday. I took the list of current employees from the employee database and put them in the Table. Then other query styles went through the list to get the employees I want. After the data, it was found that he performed more than 40 minutes to finish.. This article is an essay. It is purely my previous impression. VB's one-line judgment IIf is problematic under certain conditions. The result is seen in the company's Code. Single-line judgment - If, originally thought to be similar to Alias ​​