随笔分类 - SQL Server
摘要：select DATEADD(dd,DATEDIFF(dd,0,getdate()),0)
阅读全文
摘要：SET TRANSACTION isolation level READ uncommitted SELECT Waits.wait_duration_ms / 1000 AS WaitInSeconds, Blocking .session_id AS BlockingSessionId, Db_
阅读全文
摘要：USE AdventureWorks2012; GO SET SHOWPLAN_ALL ON; GO -- First query. SELECT BusinessEntityID FROM HumanResources.Employee WHERE NationalIDNumber = '5096
阅读全文
摘要：CREATE TABLE EMPLOYEE([EID] INT, [ENAME] VARCHAR(45),[DEPT] VARCHAR(45)); INSERT INTO EMPLOYEE VALUES (1, 'Mahesh','IT'); INSERT INTO EMPLOYEE VALUES
阅读全文
摘要：SELECT des.program_name , des.login_name , des.host_name , COUNT(des.session_id) [Connections] FROM sys.dm_exec_sessions des INNER JOIN sys.dm_exec_connections DEC ON de...
阅读全文
摘要：netsh advfirewall firewall add rule name="SQL Server Browser" protocol=UDP dir=in localport=1434 action=allow netsh advfirewall firewall add rule name
阅读全文
摘要：環境 Windows8 64bitVisual Studio 2010Access 2010 32bit接続プロバイダは「Microsoft.ACE.OLEDB.12.0」 Windows8 64bit Visual Studio 2010 Access 2010 32bit 接続プロバイダは「Mi
阅读全文
摘要：REM INIT→既に指定したファイルが有った場合, 上書きするREM NORECOVERY→接続先データベースへの既存の接続を閉じるREM REPLACE→既存のデータベースを上書きするset BkupPath={path1}sqlcmd -S (local)\{SERVICENAME} -U {
阅读全文
摘要：/* Drop all non-system stored procs */DECLARE @name VARCHAR(128)DECLARE @SQL VARCHAR(254)SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [ty
阅读全文
摘要：DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR SET @Cursor = CURSOR FAST_FORWARD FOR
SELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_NAME + '] D...
阅读全文
摘要：CD %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Releasesetup.exe /ACTION=uninstall /FEATURES=AS,SQL,RS,Tools /INSTANCENAME=SQLEXPRESS
阅读全文
摘要：【名 称】SQLserver用 ログ出力拡張ストアドプロシージャ（サンプル版）【版 数】0.90【動作環境】SQLserver【動作確認】Windows2003 server + SQLserver2000 EE SP3, Windows2000 server + SQLserver2000 DE SP3【提供形式】ZIP形式圧縮ファイル【制限事項】サンプル版につき2008年4月以降は使用でき...
阅读全文
摘要：osql -S "HIGH\UNCHIN" -U sa -P bzpass -d BzDB2 -Q "update bz_LocStkMta set HIKIATSU = 0"MYSQL可以在控制台下进行操作，利用命令SQL代码mysql -h localhost -u root -p123456 就可以登陆MYSQL的控制台。sql server也提供了控制台下的操作功能。在SQL SERVER...
阅读全文
摘要：更多请参考： http://www.bristle.com/Tips/SQL.htm#Oracle%20Tips 黄色背景为经常用并且容易用错的条目 语法结构 Description Oracle MS SQL Server Left Outer Join ...
阅读全文
摘要：SQL Server和Oracle的常用函数对比
阅读全文
摘要：/*************导出到Access********************/ insert into openrowset('Microsoft.Jet.OLEDB.4.0', 'x:\A.mdb';'admin';'',A表) select * from 数据库名..B表 /*************导入Access********************/ insert into...
阅读全文
摘要：1.声明变量 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->DECLARE @F001 SMALLINT, @F002 INTEGER, @F003 VARCHAR(20), ...
阅读全文
摘要：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->CREATE INDEX NewIndex ON NewTable (Field1); CREATE INDEX NewIndex ON NewTable (Field1) WITH IGNORE NUL...
阅读全文
摘要：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->create proc a param1 varchar(16), param2 varchar(16) output as 如何在另一...
阅读全文
@@@
end feedwind code -->
