flysun0311

摘要： clsfunction get-diskratio(){ param([Parameter(Position=0, Mandatory=$true)] $DiskString ) if ( $DiskString -eq ""){ Write-Output $null ; } else { Write-Host $DiskString.substring($DiskString.IndexOf("|")+1,$DiskString.length-$DiskString.IndexOf("|")-2) Write-Output $Dis 阅读全文

摘要： USE [NutsAndBolts]GO/****** Object: StoredProcedure [dbo].[alert_AlterFailedJobInfo] Script Date: 2012/9/7 9:36:10 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: Alex Tian-- Create date: 2012-09-01-- Description: auto alte... 阅读全文

摘要： http://www.sqlservercentral.com/Forums/Topic611107-146-1.aspx 阅读全文

摘要： Microsoft Knowledge BaseFind samples and solutions for your problemsMicrosoft SQL Server HomepageProvides product info. & features good articlesMicrosoft universal data accessAll about Microsoft data access technologiessql-server-performance.comPerformance tuning and optimization tips for Micros 阅读全文

摘要： 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)) 阅读全文