pst files stored

Tags: finding the specified directory file SQL stored procedureWildcards find the process for files in a specified directory:--Finds files under the specified folder (directory). Alterprocedure[files]. [Dir_files] @Path nvarchar (--) search path. --means "folder path" must end with ' \ '; --means "file path" cannot en

Label:In the InnoDB engine, the tables of the database can share storage space and can be stored separately by table, although the shared storage space looks neat and clean, but it is not advisable from the perspective of management and operations. First in the same MySQL server can not access the database table will be stored in a file, this file will not be the database of a table or the deletion of some

Label:--The log file shrinks to how many m DECLARE @DBLogSise as INT SET @DBLogSise =0 --Query out the database corresponding log file name DECLARE @strDBName as NVARCHAR (+) DECLARE @strLogName as NVARCHAR (+) DECLARE @strSQL as VARCHAR (+) SELECT @ Strlogname=b.name, @strDBName =a.name from master.sys.databases as A INNER JOIN sys.master_files as B On a.database_id = b.database_id WHERE a.database_id=db_id () set @

,out_file_ Name, ' W '); Count_num: = 0; while Count_num /* ==================== Fourth step: Create the output directory and authorize the relevant user ==================== */ Create or replace DIRECTORY MYDIR as ' d:\tmp\ '; GRANT read,write on DIRECTORY MYDIR to Wenglin; /* ==================== Step Fifth: Command line execution, view output file To see the command line print results, execute: Set serveroutput on ==================== * /exec export_to_csv (' MYDIR '); Additional instruct