Microsoft Agent is widely used. We can add it to common applications for use by local systems, or embed it into HTML documents for Internet/Intranet use. Microsoft Agent supports C/C ++, Visual Basic, Java, JScript, VBScript, and other programming
Overview
--------------------------------------------------------------------------------
In the usual work, I will often encounter this need to merge the SQL script problem. For example, there are a number of SQL script files that need to be
Microsoft Agent is widely used. We can add it to common applications for use by local systems, or embed it into HTML documents for Internet/Intranet use. Microsoft Agent supports C/C ++, Visual Basic, Java, JScript, VBScript, and other programming
The code for the SQL Regular Expression replacement function is as follows: CREATEfunctiondbo. regexReplace (@ sourcentext, -- original string @ regexpvarchar (1000), -- Regular Expression @ replacevarchar (1000), -- replace value @ globalReplacebit1
Reprinted with the source: BK instant groupInitial launchWeb Security Manual
//////////////////////////////////////// ////////////////////////////////Sa command execution method summary
By invincible cucumber//////////////////////////////////////// /
What is the difference between the namespace and the Assembly name?A namespace is a type logical naming scheme. A simple type name (such as MyType) is preceded by a hierarchical name separated by points. Such a naming scheme is completely under the
-- Verify the email Function
Create Function isemail (@ value varchar (100) returns bit as begin declare @ object int declare @ V bit declare @ STR varchar (8000) -- Javascript Regular Expression definition and call statement set @ STR = 'var Reg =/^
How to call WebService in Stored Procedures
After finding a solution for a long time, leave the following notes.
In the stored procedure, WebService is called by using system functions in the database to call Ole.
1. Search for the WebService
How to create an OLE Automation Object (TRANSACT-SQL)Create an OLE Automation Object
Call sp_oacreate to create an object.
Use this object.Call sp_oagetproperty to obtain the property value.
Call sp_oasetproperty to set the property to a new
Overview
No single application can fully enable this processor. When a thread encounters a long wait event, synchronous multithreading also allows the commands in another thread to use all execution units. For example, when a thread encounters a
SummaryAutomation and COMThree automated methods from Visual C ++How to use the office libraryEnable embedded Office components to run automaticallyReference
I. SummaryYou can use automation to control Microsoft Office Components from Visual C ++
C # not only supports. and supports the com platform. to support COM and. net, C # contains a unique language feature called attributes. an attribute is actually a C # class, which provides metadata by modifying the source code. properties enable C #
This digest from: http://www.job168.com/info/read_100394.htmlMany of Microsoft's technologies, such as OLE, ActiveX, and DirectX, are built on COM technology. Microsoft itself also uses a lot of COM components to customize their applications and
In sqlserver, a series of system stored procedures such as sp_oacreate can call the COM object on the server, so the T-SQL can stand on the shoulders of giants by calling COM, but this requires high permissions. for example, the following test
Section 6 Interface Conversion
C # not only supports the. Net platform, but also supports the COM platform. To support COM and. Net, C # contains a unique language feature called attribute. An attribute is actually a C # class, which provides
Section 6 Interface Conversion
C # not only supports the. Net platform, but also supports the COM platform. To support COM and. Net, C # contains a unique language feature called attribute. An attribute is actually a C # class, which provides
--sql Regular Replace function
The Code is as follows: CREATE function Dbo.regexreplace ( @source ntext, the original string @regexp varchar (1000),--Regular expression @rep Lace varchar (1000),--Replaces the value @globalReplace bit = 1,
The most recent projects are the archiving of data, pulling data from one database to another, resulting in a very large log file for the new database, or the fact that the database is being used to increase the log files, which can degrade the
Section sixth, Interface conversion
C # supports not only the. Net platform, but also the COM platform. To support COM and. net,c# contains a unique language attribute called attributes. A property is actually a C # class that provides meta
What is the difference between a namespace and an assembly name?
Namespaces are a logical naming scheme for types in which a simple type name, such as MyType, is preceded by a point-delimited hierarchy name. Such a naming scheme is entirely under
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.