what ole automation

Generally speaking, we do this through ODBC to access the remote backend database. However, ODBC has a fatal drawback--slow speed. In fact, for Oracle databases, in addition to ODBC, we can use the OLE object (Oracle Objects for OLE) provided by

CREATE FUNCTION [dbo]. [Regexreplace] (@string varchar (MAX),--substituted string @pattern varchar (255),--Replacement template @replacestr varchar (255),--replaced string @IgnoreCase int = 0--0 Case-sensitive 1 is case-insensitive) RETURNS

Use PUBDBGoIF object_id (N ' dbo. Regexreplace ') is not NULLDROP FUNCTION dbo. RegexreplaceGO--Start creating a regular replacement functionCREATE FUNCTION DBO. Regexreplace(@string VARCHAR (MAX),--the string to be replaced@pattern VARCHAR

If you ever had the problem where you need to extract files from a SharePoint Content database or normal SQL database stor Ed as binary, this post would help you.The script I have included would export all the content from the SharePoint content

A xp_cmdshellEXEC Master.. xp_cmdshell ' ipconfig ' Open xp_cmdshell: --To allow advanced the options to be changed. EXEC sp_configure ' show advanced options ', 1 Go --To update the currently configured value for advanced

No single application can fully load the processor. When a thread encounters a longer wait-time event, synchronous multithreading also allows instructions in the other threads to use all the execution units. For example, when one thread has a cache

In fact, we all know that SQL statement error information can be found in the Sys.messages table Such as: If you are executing a statement in Try...catch we can get the error message in the following ways. The SQL statement is as follows:

The first chapter of programming C # Introduction welcome you to join the world of C #! This chapter will introduce you to the world of C # and answer related questions such as: Why do you use c#,c++ and C # for the main differences, and why C #

Issue Summary: This article contains frequently asked questions about Microsoft. NET and the Microsoft. NET Framework. Directory Conceptual issues Run-time technical issues Terms Assembly Application Deployment and Isolation Garbage

Visit | Visit SolidWorks Two development -02-two APIs for accessing features To learn two APIs: SelectByID2 and GetSelectedObject5. The first of these functions is to select the object by giving the name of the object. The second gets the object by

Although the use of SQL Server to invoke the service interface is relatively small, but also to understand the corresponding use of the situationFirst, to open the configuration of the componentsp_configure ' show advanced options ', 1;

A xp_cmdshellEXEC Master. xp_cmdshell ' ipconfig 'Open xp_cmdshell:--to-allow advanced options to be changed.EXEC sp_configure ' show advanced options ', 1GO--To update the currently configured value for advanced options.RECONFIGUREGO--to enable the

One, check the configuration, if ' Show advanced options ', ' Ole Automation procedures ', ' Ad Hoc distributed Queries ' config_value and Run_value is not 1, Two scripts are required to execute.Second, execute the script, open SQL Server access

-- SQL Regular Expression replacement function The Code is as follows:CREATE function dbo. regexReplace(@ Source ntext, -- original string@ Regexp varchar (1000), -- Regular Expression@ Replace varchar (1000), -- replace value@ GlobalReplace bit = 1,

ATL-JavaScript Mixed ProgrammingJavaScript hybrid programming-ATL Last update date: Environment:Windows 8.1 64bit English version, Visual Studio 2013 Professional Update1 English version Prerequisites:Basic concepts of COM Author:KagulaIntroduction

1: System-necessary processesSystem processProcess files: [System process] or [system process]Process name: Windows Memory Processing System processDescription: Windows page memory management process with 0 levels of precedence.Alg.exeProcess file:

Use regular expressions to replace strings and Server Regular Expressions in SQL server Create a regular expression replacement function and use the OLE object. The following is the function code: [SQL]View plain copy -- If yes, delete the

Recent projects mainly archive data and pull the data from one database to another, resulting in a large log file for the new database; or the log files are continuously increased during the use of the database, this reduces database performance and

How can SQL Server obtain processor (CPU), Memory (Memory), Disk (Disk), and operating system information through SQL statements? sqlserversql In SQL server, how does one obtain SERVER hardware and system information through SQL statements? The

Recent projects mainly archive data and pull the data from one database to another, resulting in a large log file for the new database; or the log files are continuously increased during the use of the database, this reduces database performance and