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µÄÖµ
Ïà¹ØÎĵµ£º
ÔÚ¿ª·¢²»ÂÛÊÇWEB»¹ÊÇWinform³ÌÐòÖУ¬Êý¾Ý·ÖÒ³ÊǾ³£Óöµ½µÄÎÊÌ⣬ҪÊÇÔÚ´úÂëÖÐʵÏִ˹ý³Ì£¬ÏÔÈ»½µµÍÁË·þÎñÆ÷µÄЧÂÊ£¬¿ÉÒÔʹÓÃÒÔÏ´洢¹ý³ÌÀ´ÊµÏÖ¡£
CREATE PROCEDURE pagination
@tblName varchar(255), -- ±íÃû
@strGetFields varchar(1000) = '*', -- ÐèÒª·µ»ØµÄÁÐ
@fldName varchar(255)= ......
»Ö¸´Ä£Ê½£¨Recovery Model£©Ö¼ÔÚ¿ØÖÆÊÂÎñÈÕ־ά»¤¡£»Ö¸´Ä£Ê½ËµÃ÷Á˹¤×÷¶ªÊ§µÄ·çÏÕ£¬ÄÜ·ñ»Ö¸´µ½Ê±µã£¿
SQL ServerÊý¾Ý¿âÓÐÈýÖÖ»Ö¸´Ä£Ê½£º¼òµ¥»Ö¸´Ä£Ê½¡¢ÍêÕû»Ö¸´Ä£Ê½ºÍ´óÈÝÁ¿ÈÕÖ¾»Ö¸´Ä£Ê½¡£
Ïà¶ÔÓÚ¼òµ¥»Ö¸´Ä£Ê½¶øÑÔ£¬ÍêÕû»Ö¸´Ä£Ê½ºÍ´óÈÝÁ¿ÈÕÖ¾»Ö¸´Ä£Ê½ÌṩÁ˸üÇ¿µÄÊý¾Ý±£»¤¹¦ÄÜ¡£ÕâЩ»Ö¸´Ä£Ê½¶¼ÊÇ»ùÓÚ±¸·ÝÊÂÎñÈÕÖ ......
Óŵã:×ֶνÏÉÙ£¬ÓÐÔöɾ¸Ä²é¹¦ÄÜ£¬²»¹ý²éѯ̫Áýͳ¡£
ȱµã:
1.²»ËãÊÇÔÚºÜÕýµÄÎÞÏÞ·ÖÀà,ClassPathÕâ¸ö×ֶζ¨ÒåÏÞÖÆ¡£
2.Ö÷¼üCLASSID²»ÊÇ×ÔÔöµÄ£¬Ê¹ÓÃCODESMITHÅúÁ¿Éú³É¶à²ã¼Ü¹¹´úÂëÖлᵼÖ³ö´í¡£
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ArticleClass]') and OBJECTPROPERTY(id, N'IsUse ......
ÔÚʹÓÃNHibernate¹ý³ÌÖо³£»áʹÓõ½¸´ÔÓµÄsql²éѯ£¬µ«ÊÇʹÓÃhqlÓֱȽÏÂé·³µÄÇé¿öÏ£¬ÎÒÃÇÍùÍù¶¼»áÏëµ½²ÉÓÃÔʼµÄsqlÀ´Ö´ÐС£µ«ÊÇÈçºÎÀûÓÃNHibernateÀ´Ö´ÐÐsqlÄØ£¿ÎÊÌâÀ´ÁË£¬ÔÚNHibernateÖÐÒ²ÓÐAdoTemplateµÄ·½·¨¿ÉÒÔÖ´ÐÐsqlµÄ£¬µ«ÊÇÕâÀïÒª½éÉܵÄÊÇÁíÍâÒ»ÖÖ·½·¨£ºCreateSQLQuery¡£ÒÔϲ¿·ÖÀý×ÓÔ´×ÔÓÚÍøÂç¡£
ʵÀýÒ»£¨Ô´×ÔÓÚ ......
½¨±í£º
CREATE TABLE [DB.dbo].tableName
(Stud_id int CONSTRAINT constraintName1 not null primary key,
Name nvarchar(5) not null,
Birthday datetime,
Gender nchar(1),
Telcode char(12),
Zipcode char(6) CONSTRAINT constraintName2 CHECK(zipcode like [ ......