SQL Server

Data operations between different server databases --Create a linked server exec sp_addlinkedserver ' itsv ', ', ' SQLOLEDB ', ' Remote server name or IP address ' exec sp_addlinkedsrvlogin ' itsv ', ' false ', NULL, ' username ', ' password ' --

E Packing directory Create a new Excel file Aa.xls and test the following code Copy Code code as follows: Use tempdb Go if (object_id (' udf_getexceltablenames ') are NOT null) Drop function dbo. udf_getexce Ltablenames Go Create function

You can use the dtexec command in SQL Server to run SSIS packages (more than 2005 versions), and of course you can run SSIS packages through system procedures: xp_cmdshell invoke dtexec. The specific steps are as follows: 1. First of all, it is of

ASP tutorial two ways to connect to a SQL Server database tutorialThis tutorial focuses on two different ways of connecting ASP to the MSSQL server database, mainly the SQL Server connection method and the SQL Server OLE DB connection method.SQL

It used to be that the synonym (synonym) in SQL Server was useless, so it never looked up its syntax format. Today, there is a problem, with synonym to solve the better. The problem is that I use multiple databases in my system, and because some of

Many developers want to be a DBA, and a lot of people start by positioning themselves as a dba,dba. What kind of knowledge and skills do you need to know? Here's myWhile doing DBA work and interviewing DBAs, some of the 30 DBA issues that have been

Read Catalogue Brief introduction First, the general search conditions used like Second, like special case: Search wildcard characters Back to top introductionLike in sql: Use a good fuzzy query directive in SQL Server

Performance optimizations for SQL Server administrator-required skillsSQL Server is one of the essential services of the enterprise, so it is a great challenge for the daily operation of the administrator, the administrator is very important to the

Original: Effect of driving order on performance in multiple table joins in SQL ServerThe source of this article: http://www.cnblogs.com/wy123/p/7106861.html(It is not the original works right to retain the source, I my book still far to reach, just

When querying database records using SQL statements, there are many different ways to query the same content.Still, although you can get the same results using a variety of methods, if you use a different approach, the execution benefits are quite

1. If the MSSQLServer service is already started, stop.2. Open the command line as an administrator and execute the command: "C:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\binn\sqlservr.exe"-c-m(The path is modified according to

Start from Create By using the explicit CREATE INDEX command As an implied object when creating a constraint Implicit indexes created with constraintsAn implicit index is created when you add one of the following two constraints to

In SQL Server, both the cast and CONVERT functions are available for type conversions, and their functions are the same.It's just a different syntax.Cast is generally easier to use, and the advantage of convert is that dates and values can be

https://mssqlwiki.com/2012/10/16/sql-server-exception_access_violation-and-sql-server-assertion/SQL Server Exception, exception_access_violation and SQL Server assertionPosted by Karthick P.K on October 16, 2012I have got few request's from SQL

in the computer room charging system, their own database has repeatedly encountered a " in with SQL network-related or instance-specific errors when establishing a connection ! "This error hint, such as the following:A lot of information has not

This article will mainly list MySQL and SQL Server different places, and the common stored procedures related to the main content.1. Identifier Qualifier Sql server [] Mysql `` 2. Adding strings

1. Import or export through the designer of the tool "DTS"DTS's designer is powerful, multi-tasking, and visual interface, easy to operate, but people generally do not know much, if only a few tables in the SQL Server database movement, it is best

In AlwaysOn, SQL Server uses the "step-on" Record of the memory table, and sqlalwayson Preface Recently, memory tables were used in a database in the online alwayson environment. After about a week, the monitoring program found a very serious

How to remotely log on to the SQL Server 2014 Database: sql2014 Log on to the SQLServer (2014) database remotely for your reference. The details are as follows: Two computers with the same IP address and CIDR Block in the same

SQL Server temporary table and cursor usage summary, SQL Server 1. Temporary table Temporary tables are similar to permanent tables, but temporary tables are stored in tempdb. They are automatically deleted when they are no longer used.Temporary