When we write batches, we often use echo to make a simple sound, but we may need to get a different warning sound when we write a alt+7 batch file, we can use MPLAY32 to do it, let him pronounce it for me and then close it. You can simply add the
Cloud Habitat Community added: batch processing is relatively simple language, we can write more to see other people's examples to learn, do not understand Baidu.This is a technical tutorial, sincerely will use very simple words to express their
The design problem of some intranet dialing software, after dialing in an accidental situation can not automatically obtain DHCP to update the intranet IP, and later found that by manually releasing and regain IP can solve this problem, but each
It supports command-line arguments and can receive the JS and VBS methods. Look at the example (test at the command line):
Js:
Copy Code code as follows:
Mshta vbscript:window.execScript ("alert (' Hello world! ');", "JavaScript")
When you list all the field names in a table, you use one of these SQL functions: object_id
Here I list the function and usage so that you can understand:
OBJECT_ID:
Returns the database object identification number.
Grammar
OBJECT_ID (' object '
Copy Code code as follows:
Function getipaddress ()
Dim Flag, Source
Set getipobj = Wscript.getobject ("http://ipseeker.cn//")
Flag = 0
For I=1 to 10
If getipobj.readystate = "complete" Then
Flag=1
Exit for
End If
Wscript.Sleep 500
1, save the following code to: C:\windows\system32\vdm.vbs
Copy Code code as follows:
Dim Args
Set Args = wscript.arguments
Tranargs = ""
For i = 0 to Args.count-1
Tranargs = Tranargs & "" "& Args (i) &" "" & ""
Next
If Args (0
In our actual work, we often encounter the separation of worksheets by a header field, our general practice is to first sort by the specified header and then segmented copy paste out, not only trouble is also easy to get wrong.
The following VBS
Below to introduce the next MySQL5.7.16 green version of the installation tutorial, the details are as follows:
As shown in the figure:
Original window Instruction
Microsoft Windows [version 10.0.xxxxx] (c) 2016 Microsoft Corporation.
All
Mobile phone typing is really troublesome, so some simpler or too complex code I do not directly provide an example.
1, not the method of the method--Add notes
Add some rules useless annotations without signatures. Code slightly
2. Mixed case
All along, I used the New RegExp to create regular expression objects:
Set regex = new RegExp However, it is also possible to create a regular expression object that is new to the VBS:
Set regex = CreateObject ("VBScript.RegExp") it seems that none
Core code:
Copy Code code as follows:
If WScript.Arguments.UnNamed.Count <> 1 Then Syntax
If WScript.Arguments.Named.Count > 1 Then Syntax
Blntd = False
If WScript.Arguments.Named.Count = 1 Then
If UCase (WScript.Arguments.Named (0))
Recently in the project has such a piece of code: Download Server base business data for local BULK insert operation, because the project uses MyBatis for persistence operation, so consider using MyBatis BULK Insert function directly.
1. The
Establish regular expressions
The method for constructing regular expressions is the same as for creating mathematical expressions. That is, using multiple metacharacters and operators to combine small expressions to create larger expressions.
You
Qualifier
Sometimes you don't know how many characters to match. To accommodate this uncertainty, regular expressions support the concept of qualifiers. These qualifiers can specify how many times a given component of a regular expression must
VB Tutorials > Seventh Lesson use conditional statementsProgram executionUse conditional statements and circular statements to control the Script's process. Use conditional statements to write VBScript code for judging and repeating operations. The
OpenTextFile method
Opens the specified file and returns a TextStream object that can be read, written to, or appended to the file.
object.OpenTextFile(filename[, iomode[, create[, format]]])
Parameters
Object
Required option. Should be the name of
Method One
Declare @max integer, @id integer
Declare cur_rows cursor Local for select main field, COUNT (*) from table name Group by main field having count (*) > 1
Open Cur_rows
Fetch cur_rows into @id, @max
While @ @fetch_status
There is a very ingenious SQL technique on the itpub to learn and record here.
The initial problem is this:
I have a table structure,
Fphm,kshm
2014,00000001
2014,00000002
2014,00000003
2014,00000004
2014,00000005
2014,00000007
2014,00000008
2014,000
SQL Server Basic functions
1. String function length and analysis
DATALENGTH (char_expr) returns the string contains the number of characters, but does not contain the trailing spaces
SUBSTRING (expression,start,length) Don't say much, take the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service