C#µ÷ÓÃSQL´æ´¢¹ý³ÌÒÔ¼°·µ»ØÖµºÍ²ÎÊýµÄ»ñÈ¡
QZone Editor
.dump{}
//TODO ÓòÃû
if (location.hash) {
document.domain=location.hash.substr(1);
}
//parent.qZEditor.callback();
function init(){
//»ñÈ¡±à¼Æ÷Ãæ°åID
var pid = frameElement.panelID;
//»ñÈ¡±à¼Æ÷Ãæ°å¶ÔÏó
var panel = parent.QZFL.editor.editPanel.get(pid);
panel["html"]._enableEditMode();
}
¡¡¡¡ÔÚsql2005ÖУ¬´æ´¢¹ý³Ì¹¦Äܷdz£Ç¿´ó£¬ÈçºÎÔÚC#Öе÷ÓÃÄØ£¬ÏÂÃæ¾ÍÒÔʾÀý˵Ã÷£º
¡¡¡¡Ê×ÏÈÔÚÊý¾Ý¿âÖд´½¨´æ´¢¹ý³ÌXSPTest
¡¡¡¡CREATE PROCEDURE dbo.XSPTest
¡¡¡¡¡¡¡¡@In As nvarchar(16),
¡¡¡¡¡¡¡¡@Out As int OUTPUT
¡¡¡¡As
¡¡¡¡¡¡¡¡-- deal with @In
¡¡¡¡¡¡¡¡Set @Out = 1;
¡¡¡¡¡¡¡¡Select 2 As SValue;
¡¡¡¡¡¡¡¡RETURN 0;
¡¡¡¡ÉÏÃæµÄ´æ´¢¹ý³ÌÐèÒªÒ»¸öÊäÈë²ÎÊý£¬Ò»¸öÊä³ö²ÎÊý£¬·µ»ØÒ»¸öÖµ£¬²¢ÇÒselectÒ»¸ö¡£ÏÂÃæ¾Í·Ö±ð˵Ã÷һϣº
¡¡¡¡ SqlCommand cmdCommit = new
SqlCommand("XSPTest", myConnect)
cmdCommit.CommandType =
CommandType.StoredProcedure;¡¡¡¡// ˵Ã÷µ÷ÓÃÒ»¸ö´æ´¢¹ý³Ì
cmdCommit.Parameters.Add(new SqlParameter@In", SqlDbType.NVarChar,
16));
cmdCommit.Parameters.Add(new SqlParameter("@Out ",
int));
cmdCommit.Parameters.Add(new SqlParameter("RValue",
SqlDbType.Int));
cmdCommit.Parameters[0].Value =
"MyTest";¡¡¡¡// ´«ÈëµÄÖµ
cmdCommit.Parameters[1].Direction =
ParameterDirection.Output;¡¡¡¡// ˵Ã÷ÊÇÊä³ö²ÎÊý
cmdCommit.Parameters[2].Direction = ParameterDirection.ReturnValue;¡¡¡¡//
»ñÈ¡returnµÄÖµ
Ïà¹ØÎĵµ£º
¸ÕÅöµ½Õâ¸öÎÊÌâʱ£¬ÒÔΪÊÇÓ¦Ó÷þÎñÆ÷ºÍÊý¾Ý¿â·þÎñÆ÷ûÁ¬Í¨£¬²éÁ˰ëÌìµÄÍøÂç½á¹ûÍøÉÏÒ»²é£¬¸úSQL Server 2005Óйأ¬ÄãÌ«ÑôµÄ£¡
¿ªÊ¼²Ëµ¥-SQLServer2005-ÅäÖù¤¾ß-SQL Server Configuration Manager-SQLserver2005ÍøÂçÅäÖÃ-MSSQLSERVERµÄÐÒé-Ë«»÷TCP/IPÐÒé
°ÑIP¸Ä³Éµ±Ç°Ê¹Óõ쬵±È»£¬¶Ë¿ÚҲҪȷ±£ ......
SQL code
SQL ServerÊý¾Ýµ¼Èëµ¼³ö¹¤¾ßBCPÏê½â
BCPÊÇSQL ServerÖиºÔðµ¼Èëµ¼³öÊý¾ÝµÄÒ»¸öÃüÁîÐй¤¾ß£¬ËüÊÇ»ùÓÚDB
-
LibraryµÄ£¬²¢ÇÒÄÜÒÔ²¢Ðеķ½Ê½¸ßЧµØµ¼Èëµ¼³ö´óÅúÁ¿µÄÊý¾Ý¡£BCP¿ÉÒÔ½«Êý¾Ý¿âµÄ±í»òÊÓͼֱ½Óµ¼³ö£¬Ò²ÄÜͨ¹ýSELECT fromÓï¾ä¶Ô±í»òÊÓͼ½øÐйýÂ˺󵼳ö¡£ÔÚµ¼Èëµ¼³öÊý¾Ýʱ£¬¿ÉÒÔʹÓÃĬÈÏÖµ»òÊÇʹÓÃÒ»¸ö¸ ......
Ò»¡¢±í½á¹¹²éѯ
SELECT TOP (100) PERCENT a.name AS zdm,COLUMNPROPERTY(a.id, a.name, 'IsIdentity') AS bs ,
CASE WHEN EXISTS (SELECT 1 from dbo.sysindexes si INNER JOIN dbo.sysindexkeys sik ON si.id = sik.id
AND si.indid = sik.indid INNER JOIN dbo.syscolumns sc ON sc.id = sik.id AND sc. ......
Óï¾äÐÎʽ£º¡¡ SELECTTOP10*
fromTestTable
WHERE(ID>
¡¡¡¡¡¡¡¡¡¡(SELECTMAX(id)
¡¡¡¡¡¡¡¡from(SELECTTOP20id
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡fromTestTable
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ORDERBYid)AST))
ORDERBYID
SELECTTOPÒ³´óС*
fromTestTable
WHERE(ID>
¡¡¡¡¡¡¡¡¡¡(SELECTMAX(id)
¡¡¡¡¡¡¡¡from(SELECTTOPÒ³´óС*Ò³Êýid
¡¡¡¡¡ ......
ÔÚSQLSERVER£¬¼òµ¥µÄ×éºÏsp_spaceusedºÍsp_MSforeachtableÕâÁ½¸ö´æ´¢¹ý³Ì£¬¿ÉÒÔ·½±ãµÄͳ¼Æ³öÓû§Êý¾Ý±íµÄ´óС£¬°üÀ¨¼Ç¼×ÜÊýºÍ¿Õ¼äÕ¼ÓÃÇé¿ö£¬·Ç³£ÊµÓã¬ÔÚSqlServer2KºÍSqlServer2005Öж¼²âÊÔͨ¹ý¡£
/*
1. exec sp_spaceused '±íÃû' £¨SQLͳ¼ÆÊý¾Ý£¬´óÁ¿ÊÂÎñ²Ù×÷ºó¿É ......