转载：How to connect to Microsoft SQL Server using VBA? - Simple Excel VBA When it comes to big amount of data, Excel application is not the best solution to work with, in case of storage. Much better fit would be a database like Access or MSSM. In this article I’m going to show You how to connect to...

转载：Easy way to convert XML into Excel - Simple Excel VBA When I was young I thought, that if You want to send table data You use Excel. Now I know that there are tons of ways of transferring data. One of them is XML. In today’s article I will show You an easy way to convert XML into more user...

转载：How to create XML file from scratch? - Simple Excel VBA This is the third and the last part from the XML trilogy. Be sure You didn’t miss how to convert XML into Excel and how to overwrite XML file without copying or converting. In this article I’m going to show You how to create XML file from...

# EDI # Beginners Guide to EDI X12 # ANSI 997 - Functional Acknowledgement Accepted Transaction Set 123456789ISA*00* *00* *30*560891234...

转载：SQL Server LocalDB Getting Started Guide # Problem In a previous tip, I walked through installation and some caveats with the first version of SqlLocalDb, which shipped with SQL Server 2012. Well, it’s been several major releases, and some of the aspects have changed, so I thought I would...

转载：Perl Tutorial: Regular Expressions (Regex), File IO and Text Processing Perl is famous for processing text files via regular expressions. # 1. Regular Expressions in Perl A Regular Expression (or Regex) is a pattern (or filter) that describes a set of strings that matches the pattern. In other...

转载: Building a CodePen Type Editor from Scratch Building a CodePen Type Editor from ScratchWanting to show live examples of code on your website is very common, if you want to do it today there are a few services that provide that ability. However, if you are like me, you would rather roll your...

转载：SQL Auto Increment: How to Use It in Different Databases - Database Star SQL auto-increment is a feature that allows you to generate a unique number when inserting rows. Learn how to set this up in SQL Server, MySQL, PostgreSQL, and Oracle in this article. # What is SQL Auto...

# Divide / 12select cast(30 as float) / 120, 30::float / 120, 30 / 120;--0.25 0.25 0 # VARIADIC Parameter 参数 nums 是一个数组，可以传入任意多个参数；然后计算它们的和值。 例如： SELECT sum_num(1,2), sum_num(1,2,3); sum_num sum_num 3 6 1234567891011CREATE OR REPLACE FUNCTION sum_num(VARIADIC nums numeric[])RETURNS numericAS...