1) create a configuration file and account (create a configuration file and configure database mail Wizard to access the database mail node in the configuration database mail management node and the account Used in the context menu .)
Open
I have discussed how to configure database mail sending in the database. (Note: the database mail function is implemented based on SMTP. First, configure the SMTP function in the system. In the "Add/delete programs" Panel, "Add/delete WINDOWS
Ms SQL SERVER gets information such as the current database file for multiple versions:Copy codeThe Code is as follows:SELECT dbf. file_id AS FileID, Dbf. name AS [FileName], S. filename AS FileLocation, CAST (dbf. size/128.0 as decimal (19,2) AS
First, the Code is as follows:Copy codeThe Code is as follows:Select distinctB. OrgID, B. CompanyID, B. AreaID, B. CustChannelID, B. CustID, B. SaleTotalQty,GETDATE () from KDS400TelSurveyCustAll_Temp as tmp1 cross apply(Select top 10 percent * from
I. IdeasThe free version of MongoVUE supports importing Mongo from MySQL, so the idea is to import MySQL from SQL server and then Mongo from MySQL.
2. Preparation
1. Install the mysql database (I used WAMP to integrate mysql and phpadmin). If
Create a query and execute the following statement to generate the function fn_GetPy.Copy codeThe Code is as follows:-- Generate the first pinyin codeCREATE function fn_GetPy (@ str nvarchar (4000 ))Returns nvarchar (4000)-- WITH
When you use the SQL Server 2000 database to open the Enterprise Manager, the following error occurs:The window name is MMC.An error occurred while initializing the SQL Server Management Unit.Name: Microsoft SQL Enterprise ManagerCLSID {00100100-1816
There are associations between multiple tables in the actual project. It is impossible to retrieve all data in a table. If there is no table connection, we need a lot of operations. For example, you need to find restrictive conditions from Table A
If we insert a value in the ID column, for example:
Copy codeThe Code is as follows:Insert member (id, username) values (10, 'admin ')
The query analyzer will return an error message:[Plain]Reference contentServer: Message 544, level 16, status 1,
1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order.
2. Try to avoid null value determination on the field in the where clause. Otherwise, the engine will discard
1. Meaning of WITHThe with as phrase, also known AS subquery factoring, allows you to do a lot of things and define an SQL segment, which will be used by the entire SQL statement. Sometimes, it is to make the SQL statement more readable, or it may
A few days ago, "read", "sqlserver2005 advanced programming", and "SQL Server 2008 Programming beginners (3rd edition)" were translated Chinese versions. It turns out that the directory structure is roughly the same, and its content is almost the
For newly added records, you can obtain the value of the Automatic Identification column for the new record in two ways:1. Use the OUTPUT keyword in INSERTInsert into table_name (column1, column2, column3)Output inserted. ID -- return the
When you modify two or more tables, you have to use several statements to modify them. If one of the tables is not modified and there is no transaction mechanism, the processing is very troublesome, so I thought it would be possible to complete a
Optimization skills are mainly for DBA, But I think developers should master these skills, because not every development team has a dedicated DBA.
Step 9: properly organize database file groups and files
When creating an SQL Server database, the
ACCESS2000 File
Open it with ACCESS2007 and migrate it to SQLSERVER2005
Open ACCESS2007 database tool
Method 1: Use the database migration tool that comes with ACCESS2007
1. Open the database migration wizard for ACCESS2007
2. Click SQLSERVER to
Clear records in all data tables in SQL Server
Clear records in all data tables:
Copy codeThe Code is as follows: exec sp_msforeachtable @ Command1 = 'truncate table? '
Delete all data tables:
Copy codeThe Code is as follows: exec sp_msforeachtable '
Let's talk about the procedure.1. query 50 thousand pieces of data from management studio of sql2008, right-click to export to csv2. Because no column name is exported by default, the column name is added after manual editing.3. The error message
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.