Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 ´æ´¢¹ý³ÌʵÏÖ·ÖÒ³

     ÔÚ¿ª·¢²»ÂÛÊÇWEB»¹ÊÇWinform³ÌÐòÖУ¬Êý¾Ý·ÖÒ³ÊǾ­³£Óöµ½µÄÎÊÌ⣬ҪÊÇÔÚ´úÂëÖÐʵÏִ˹ý³Ì£¬ÏÔÈ»½µµÍÁË·þÎñÆ÷µÄЧÂÊ£¬¿ÉÒÔʹÓÃÒÔÏ´洢¹ý³ÌÀ´ÊµÏÖ¡£
CREATE PROCEDURE pagination
@tblName varchar(255), -- ±íÃû
@strGetFields varchar(1000) = '*', -- ÐèÒª·µ»ØµÄÁÐ
@fldName varchar(255)= ......

SQLÎÞÏÞ·ÖÀà´æ´¢¹ý³ÌÕûÀí1

Óŵã:×ֶνÏÉÙ£¬ÓÐÔöɾ¸Ä²é¹¦ÄÜ£¬²»¹ý²éѯ̫Áýͳ¡£
ȱµã:
1.²»ËãÊÇÔÚºÜÕýµÄÎÞÏÞ·ÖÀà,ClassPathÕâ¸ö×ֶζ¨ÒåÏÞÖÆ¡£
2.Ö÷¼üCLASSID²»ÊÇ×ÔÔöµÄ£¬Ê¹ÓÃCODESMITHÅúÁ¿Éú³É¶à²ã¼Ü¹¹´úÂëÖлᵼÖ³ö´í¡£
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ArticleClass]') and OBJECTPROPERTY(id, N'IsUse ......

SQL²éѯʱ¼ä·µ»Ø¸ñʽ

Select CONVERT(varchar(100), GETDATE(), 23)£»
·µ»ØÐÎʽ£º2008-11-29
Select CONVERT(varchar(100), GETDATE(), 102)  
·µ»ØÐÎʽ£º2008.11.29
Select CONVERT(varchar(100), GETDATE(), 101)
·µ»ØÐÎʽ£º11/29/2008
¸ü¶àÏêÇéÇë²Î¼ûÈçÏÂÁÐ±í£º
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 ......

SQL»ù±¾Óï¾ä

ÕÆÎÕSQLËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä£ºInsert£¬Select£¬UpdateºÍDelete¡£
¡¡¡¡ Á·ÕÆÎÕSQLÊÇÊý¾Ý¿âÓû§µÄ±¦¹ó²Æ ¸»¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃǽ«Òýµ¼ÄãÕÆÎÕËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä—SQLµÄºËÐŦÄÜ—À´ÒÀ´Î½éÉܱȽϲÙ×÷·û¡¢Ñ¡Ôñ¶ÏÑÔÒÔ¼°ÈýÖµÂß¼­¡£µ±ÄãÍê³ÉÕâЩѧϰºó£¬ÏÔÈ»ÄãÒѾ­¿ªÊ¼ËãÊǾ«Í¨SQLÁË¡£
¡¡¡¡ÔÚÎÒÃÇ¿ªÊ¼Ö®Ç°£¬ÏÈ ......

SQL²éѯÓï¾äʹÓÃ

Ò»¡¢¼òµ¥²éѯ
¡¡¡¡ ¼òµ¥µÄTransact-SQL²éѯֻ°üÀ¨Ñ¡ÔñÁÐ±í¡¢from×Ó¾äºÍWHERE×Ӿ䡣
ËüÃÇ·Ö±ð˵Ã÷Ëù²éѯÁС¢²éѯµÄ
±í»òÊÓͼ¡¢ÒÔ¼°ËÑË÷Ìõ¼þµÈ¡£
ÀýÈ磬ÏÂÃæµÄÓï¾ä²éѯtesttable±íÖÐÐÕÃûΪ“ÕÅÈý”µÄnickname×ֶκÍemail×ֶΡ£
SELECT nickname,email
from testtable WHERE name='ÕÅÈý'
(Ò»)Ñ¡ÔñÁбí
¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ