08 2012 档案
摘要:IntroductionThis article tackles two related questions:How can I use the result set from one stored procedure in another, also expressed as How can I use the result set from a stored procedure in a SELECT statement?How can I pass a table data in a parameter from one stored procedure to another? In t
阅读全文
摘要:-- Set the database where the stored procedure is locatedUSE SecurityDataGO-- Drop older version if it existsIF OBJECTPROPERTY(OBJECT_ID(N'dbo.fn_SplitStringToTable'), N'IsTableFunction') = 1 DROP FUNCTION dbo.fn_SplitStringToTableGO-- Procedure: dbo.fn_SplitStringToTable-- Purpose:
阅读全文
摘要:C:\Users\atian1\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\Templates
阅读全文
摘要:The stored procedure "master.sys.xp_instance_regwrite" is not documented in SQL Server Books Online (BOL), but is usefull. In general the syntax isEXECUTE [master].[sys].[xp_instance_regwrite] @rootkey = N'<name of root key>',@key = N'<key name>',@value_name = N
阅读全文
摘要:1.0 GoalDB is only the storage and we should not depend too much on DB . DB should be simple and stable.2.0 Four workflow Create new tableAlter tableCreate/Alter the sp and functionI/D/U flow3.0 Setup three different environmentsdev/beta/live4.0 Basic workflow __________________________
阅读全文
摘要:今天在itput上看了一篇文章,是讨论一个语句的优化: 原贴地址: http://www.itpub.net/viewthread.php?tid=1015964&extra=&page=1 一,发现问题 优化的语句:Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->请问以下语句如何优化:CREATETABLEaa_001(ipVARCHAR2(28),nameVARCHAR2(10),passwordVARCHAR2(30))
阅读全文
摘要:Database Standard Operations List1. DB Development standardl Database is only a storage , do not depend too much on database l Build a standard workflow for who ,when , how regarding different object levels l Make a standard permission control for who should have which rightl Training and let all kn
阅读全文
摘要:DECLARE cConnections CURSOR READ_ONLY FAST_FORWARD FOR SELECT spid FROM master..sysprocesses p INNER JOIN master..syslogins l ON p.sid = l.sid WHERE l.loginname LIKE 'MSDOMAIN1\%' AND l.loginname NOT IN ('MSDOMAIN1\xzhang3', 'MSDOMAIN1\ouli', 'MSDOMAIN1\atian1') AND p
阅读全文
摘要:一、数据库运维工作总原则 1、能不给数据库做的事情不要给数据库,数据库只做数据容器。 2、对于数据库的变更必须有记录,可以回滚。 二、权限相关 总原则,以最低粒度控制权限。 SELECT权限:所有开发人员均可拥有自己业务范围内的表权限。 INSERT/UPDATE/DELETE权限:所有项目经理可以拥有自己业务范围内的表权限。 Structure权限:数据库管理员可以拥有。 Administration权限:系统管理员和数据库管理员可以拥有。 程序访问权限:根据IP和系统名建立用户名,只拥有必须表的访问权限。 全部权限:技术总监掌管,MySQL系统表mysql表权限除技术总监任何人不得拥有。.
阅读全文
摘要:http://www.cnblogs.com/peterzb/archive/2009/06/21/1507880.html
阅读全文
摘要:http://weblogs.sqlteam.com/mladenp/archive/2007/11/20/Free-SQL-Server-tools-that-might-make-your-life-a.aspx
阅读全文
摘要:@ECHO OFFECHO ***************************************************************************************************ECHO ** Deploy Command For SoapDataManager.Performance ECHO ***************************************************************************************************::::::::::::::::::::::::::::
阅读全文
摘要:@ECHO OFFECHO ***************************************************************************************************ECHO ********** Deploy FileCenter For Beta Environment ************************************************* ECHO *****************************************************************************
阅读全文
摘要:@ECHO OFF::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::Init environment for FileCentre::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::IF %1]==] GOTO UsageIF %2]==] GOTO UsageIF %3]==
阅读全文
摘要:@ECHO OFFIF %1]==] GOTO UsageFOR /F "TOKENS=1,2 DELIMS=/ " %%A IN ("%1") DO SET @DependedServer=%%A&SET @DependedSchtask=%%BIF ERRORLEVEL 1 ( ECHO ERROR: ** The input parameters - %1 init failed GOTO ExitError)::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
阅读全文
摘要:@ECHO OFFIF %1]==] GOTO UsageFOR /F "TOKENS=1,2 DELIMS=/ " %%A IN ("%1") DO SET @DependedServer=%%A&SET @DependedSchtask=%%BIF ERRORLEVEL 1 ( ECHO ERROR: ** The input parameters - %1 init failed GOTO ExitError)::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
阅读全文
摘要:@ECHO OFFIF %1]==] GOTO UsageFOR /F "TOKENS=1,2 DELIMS=/ " %%A IN ("%1") DO SET @DependedServer=%%A&SET @DependedService=%%BIF ERRORLEVEL 1 ( ECHO ERROR: ** The input parameters - %1 init failed GOTO ExitError)::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
阅读全文
摘要:@ECHO OFFIF %1]==] GOTO UsageFOR /F "TOKENS=1,2 DELIMS=/ " %%A IN ("%1") DO SET @DependedServer=%%A&SET @DependedProcess=%%BIF ERRORLEVEL 1 ( ECHO ERROR: ** The input parameters - %1 init failed GOTO ExitError)::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
阅读全文
摘要:@ECHO OFFIF %1]==] GOTO UsageFOR /F "TOKENS=1,2 DELIMS=/ " %%A IN ("%1") DO SET @DependedServer=%%A&SET @DependedService=%%BIF ERRORLEVEL 1 ( ECHO ERROR: ** The input parameters init failed GOTO ExitError):::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
阅读全文
摘要:::::ShareLib::@ECHO OFFCOPY "%MainWorkspace%\Lib\Alcorian\Alcorian.Operations\bin\Release\Morningstar.Alcorian.Operations.dll" "%ShareLibPath%"COPY "%MainWorkspace%\Lib\Alcorian\Alcorian.Core\bin\Release\Morningstar.Alcorian.Core.dll" "%ShareLibPath%":UsageECH
阅读全文
摘要:::::Performance Team::@ECHO OFFSET @Team=GPPSET @7ZEXE="C:\Program Files\7-Zip\7z.exe"FOR %%P IN (Parser Downloader FileCenter Importer TrackingMerger AsyncTaskExecuter OrphanDataTransfer BatchDataTransfer ReValidater SuggestGenerator) DO ( CD "%MainWorkspace%\Processes\Performance\%%
阅读全文
摘要:<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <Import Project="$(MSBuildExtensionsPath)\MSBuildCommunityTasks\MSBuild.Community.Tasks.Targets"/> <PropertyGroup> <AssemblyVersion Condition="'$(A
阅读全文
摘要:[Parser_Beta_Deploy] $ cmd /c call "C:\DOCUME~1\usdataadmin\Local Settings\Temp\hudson9222766694324685644.bat"D:\jenkins\workspace\Parser_Beta_Deploy>D:\PsTools\psexec.exe -accepteula \\szpc668g -ihcf Parser_Deploy.bat 1.0.1 153 N Beta PsExec v1.98 - Execute processes remotelyCopyright
阅读全文