asp.netÁ¬½ÓsqlÓõÄSqlHelper
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Collections;
using System.Data.SqlClient;
namespace DAL
{
/// <summary>
/// Êý¾Ý¿âµÄͨÓ÷ÃÎÊ´úÂë
/// ´ËÀàΪ³éÏóÀ࣬²»ÔÊÐíʵÀý»¯£¬ÔÚÓ¦ÓÃʱֱ½Óµ÷Óü´¿É
/// </summary>
public class SqlHelper
{
//»ñÈ¡Êý¾Ý¿âÁ¬½Ó×Ö·û´®£¬ÆäÊôÓÚ¾²Ì¬±äÁ¿ÇÒÖ»¶Á£¬ÏîÄ¿ÖÐËùÓÐÎĵµ¿ÉÒÔÖ±½ÓʹÓ㬵«²»ÄÜÐÞ¸Ä
public static readonly string Getcon = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
// ¹þÏ£±íÓÃÀ´´æ´¢»º´æµÄ²ÎÊýÐÅÏ¢£¬¹þÏ£±í¿ÉÒÔ´æ´¢ÈÎÒâÀàÐ͵IJÎÊý¡£
private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());
/// <summary>
///Ö´ÐÐÒ»¸ö²»ÐèÒª·µ»ØÖµµÄSqlCommandÃüÁͨ¹ýÖ¸¶¨×¨ÓõÄÁ¬½Ó×Ö·û´®¡£
/// ʹÓòÎÊýÊý×éÐÎʽÌṩ²ÎÊýÁбí
/// </summary>
/// <remarks>
/// ʹÓÃʾÀý£º
/// int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));
/// </remarks>
/// <param name="connectionString">Ò»¸öÓÐЧµÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®</param>
/// <param name="commandType">SqlCommandÃüÁîÀàÐÍ (´æ´¢¹ý³Ì£¬ T-SQLÓï¾ä£¬ µÈµÈ¡£)</param>
/// <param name="commandText">´æ´¢¹ý³ÌµÄÃû×Ö»òÕß T-SQL Óï¾ä</param>
&
Ïà¹ØÎĵµ£º
MySQLÖÐÎIJο¼ÊÖ²á- 7 MySQL ÓïÑԲο¼
<!--
body { font-size: 9pt; }
a:hover{color:red;}
a.t1:visited{color:red;}
-->
¶ÔÓÚÿ¸öÀàÐÍÓµÓеÄÖµ·¶Î§ÒÔ¼°²¢ÇÒÖ¸¶¨ÈÕÆÚºÎʱ¼äÖµµÄÓÐЧ¸ñʽµÄÃèÊö¼û7.3.6 ÈÕÆÚºÍʱ¼äÀàÐÍ
¡£
ÕâÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñÁËËùÓмǼ£¬Æädate_col
µÄÖµÊÇÔÚ×îº ......
create PROCEDURE sp_decrypt(@objectname varchar(50))
AS
begin
set nocount on
--CSDN£ºj9988 copyright:2004.07.15
--V3.2
--ÆÆ½â×Ö½Ú²»ÊÜÏÞÖÆ£¬ÊÊÓÃÓÚSQLSERVER2000´æ´¢¹ý³Ì£¬º¯Êý£¬ÊÓͼ£¬´¥·¢Æ÷
--ÐÞÕýÉÏÒ»°æ"ÊÓͼ´¥·¢Æ÷"²»ÄÜÕýÈ·½âÃÜ´íÎó
--·¢ÏÖÓÐ´í£¬ÇëE_MAIL£ºCSDNj9988@tom.com
begin tran
......
< type="text/javascript">
< type="text/javascript">
Èç×ªÔØ£¬Çë×¢Ã÷³ö´¦£ºhttp://blog.csdn.net/robinson_0612/archive/2009/11/07/4783702.aspx
Ëæ×ŵ±½ñÊý¾Ý¿âµÄÈÝÁ¿Ô½À´Ô½¿ìµÄ³¯×ÅÔÚ´óÐÍÊý¾Ý¿â»ò³¬´óÐÍÊý¾Ý¿âµÄ·¢Õ¹£¬¶ÔÓÚÊý¾Ý¿âÖеĴóÐͱíÒÔ¼°¾ßÓи÷ÖÖ·ÃÎÊģʽµÄ±íµÄ¿ÉÉìËõÐ ......
DATEDIFF(²ÎÊýÒ»,²ÎÊý¶þ,²ÎÊýÈý) ---²ÎÊýÒ»£ºyear month day; ²ÎÊý¶þ£º±È½ÏµÄÆðʼÈÕÆÚ,ĬÈÏ1900-1-1£»²ÎÊýÈý£º±È½ÏµÄÈÕÆÚ¡£
eg:DATEDIFF(year,0,getdate())±íʾ±È½Ï0£¨Ä¬ÈÏ1900-1-1£©µ½µ±Ç°µÄÈÕÆÚÏë²î¼¸Äê
SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) -- È¡µÃ±¾ÔµĵÚÒ»Ìì
SELECT DATEADD(wk, D ......
1:replace º¯Êý
µÚÒ»¸ö²ÎÊýÄãµÄ×Ö·û´®£¬µÚ¶þ¸ö²ÎÊýÄãÏëÌæ»»µÄ²¿·Ö£¬µÚÈý¸ö²ÎÊýÄãÒªÌæ»»³Éʲô
select replace('lihan','a','b')
&nb ......