ITPub博客

ApplicationIntent=ReadOnly

use demogocreate table testid([ID] [bigint] IDENTITY(1,1) NOT NULL,col1 varchar(100),[TMSTAMP] [timestamp] NOT NULL)insert into testid(col1) values ('a')insert into testid(col1) values ('b')insert into testid(col1) values ('c')create table testid2([ID] [bigint] IDENTITY(1,1) NOT ...

n.replica_server_name, rs.role_desc, DB_NAME(drs.database_id) as 'database_name', CASE WHEN drs.is_suspended=0 THEN 'RESUMED' ELSE WHEN drs.suspend_reason_desc='SUSPEND_FROM_PARTNER' THEN '在强制故障转移后挂起数据库副本' WHEN drs.suspend_reason_desc='SUSPEND_FROM_APPLY' THEN '在将日志写入文件...

CREATE PROCEDURE [dbo].[sys_viewTableSpace]ASBEGINSET NOCOUNT ON;CREATE TABLE [dbo].#tableinfo( 表名 [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, 记录数 [int] NULL, 预留空间 [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, 使用空间 [varchar](50) COLLATE Chinese_PRC_CI_AS NU...

DELIMITER |CREATE TRIGGER phpmyadmin.tri_hisInsert AFTER INSERTON pma__history FOR EACH ROWBEGIN  INSERT INTO user_act_history (`username`,`db`,`table`,`timevalue`,`sqlquery`) VALUES (NEW.`username`,NEW.`db`,NEW.`table`,NEW.`timevalue`,NEW.`sqlquery`);END|DELIMITER ;

EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0,    @time = 0, @reset = 1EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0,    @time = 0, @reset = 0exec sp_replflush 

点击(此处)折叠或打开

 and may differ in some ways from the official phpMyAdmin documentation. Specifically it does:

/usr/sbin/pma-secureDebian and Ubuntu have changed way how setup is enabled and disabled, in a way that single command has to be executed for either of these.To allow editing configuration invoke:/usr/sbin/pma-configureTo block editing configuration invoke:/usr/sbin/pma-secure...

sudo service apache2 restart

一、确认是否已安装php5-mcrypt，如果未安装执行sudo apt-get install php5-mcrypt二、进入 /etc/php5/apache2   修改其下的php.ini(eg:sudo vim php.ini)，找到如下字段并添加红色字串;;;;;;;;;;;;;;;;;;;;;;; Dynamic Extensions ;;;;;;;;;;;;;;;;;;;;;;;;; If you wish to have an extension loaded au...

点击(此处)折叠或打开/****** Script for SelectTopNRows command from SSMS ******/SELECT m.tran_begin_time,[__$start_lsn]      ,[__$end_lsn]      ,[__$seqval]&n...

 exec sp_addlinkedserver 'testdblink' , '' , 'SQLOLEDB' , 'dbserver名'exec sp_addlinkedsrvlogin 'testdblink' , 'false' , null , '用户名' , '密码'

grant view definition to <user_id>revoke VIEW DEFINITION  from  <user_id>sp_helptext XXXXXXXXXXX

点击(此处)折叠或打开USE [master]RESTORE DATABASE [news_par] FROM DISK = N'F:\SQLBak\news40.bak' WITH FILE = 1, MOVE N'news' TO N'F:\SQLData\news_par.mdf', MOVE N'news_log' TO N'F:\SQLLog\news_par_log.ldf', NOUNLOAD, REPLACE, STATS = 5...

1. create SP to create or maintain the partition sheme, partition function, file, file group, USE [DYDB]GO/****** Object:  StoredProcedure [dbo].[sp_maintain_partion]    Script Date: 2017/1/18 10:41:21 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE ...

USE topicdbGOEXEC sys.sp_cdc_enable_dbGOSELECT  is_cdc_enabled ,        CASE WHEN is_cdc_enabled = 0 THEN 'CDC功能禁用'             ELSE 'CDC功能启用'        END 描述FROM    sys.databasesWHERE &n...

/*--------------------创建数据库的文件组和物理文件------------------------*/declare  @tableName varchar(50),  @fileGroupName varchar(50),  @ndfName varchar(50),  @newNameStr varchar(50),  @fullPath varchar(50),  @newDay varchar(50),  @oldDay datetime,  ...

/* * First server */$i++;$connect_hosts = array(                '1'=>array(                      "host"   => "",  //server1      ...

INSERT INTO mysql.USER(HOST,USER,PASSWORD) VALUES("localhost","testsuer",PASSWORD("1234"));FLUSH PRIVILEGES;GRANT SELECT,INSERT,DELETE,UPDATE ON test.* TO 'testuser'@'10.24.%.%' IDENTIFIED BY '1234';FLUSH PRIVILEGES;GRANT SELECT ON phpmyadmin.pma_table_uiprefs TO 'testuser'@'10.24.%.%' IDENT...