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

ͨÓõÄSqlServer²Ù¿ØÀà

 using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections.Generic;


public class CommandInfo
{
public string CommandText;
public SqlParameter[] Parameters;
}
/// <summary>
/// Êý¾Ý·ÃÎʳéÏó»ù´¡Àà
/// </summary>
public abstract class DbHelperSQL
{
//Êý¾Ý¿âÁ¬½Ó×Ö·û´®(web.configÀ´ÅäÖÃ)£¬¿ÉÒÔ¶¯Ì¬¸ü¸ÄconnectionStringÖ§³Ö¶àÊý¾Ý¿â.
public static string connectionString = ConfigurationManager.ConnectionStrings["cnpg_newsConStr"].ToString();


public DbHelperSQL()
{


}
#region ¹«Ó÷½·¨
public static int GetMaxID(string FieldName, string TableName)
{
string strsql = "select max(" + FieldName + ")+1 from " + TableName;
object obj = DbHelperSQL.GetSingle(strsql);
if (obj == null)
{
return 1;
}
else
{
return int.Parse(obj.ToString());
}
}
public static bool Exists(string strSql)
{
object obj = DbHelperSQL.GetSingle(strSql);
int cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
if (cmdresult == 0)
{
return false;
}
else
{
return true;
}
}
/// <summary>
/// ±íÊÇ·ñ´æÔÚ
/// </summary>
/// <param name="TableName"></param>
/// <returns></returns>
public stati


Ïà¹ØÎĵµ£º

OracleÖÐÓëSQLSERVER ISNULLº¯ÊýÏàͬ×÷Óõĺ¯Êý

NVL(Expr1,Expr2)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr1µÄÖµ
NVL2(Expr1,Expr2,Expr3)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr3µÄÖµ
NULLIF(Expr1,Expr2)Èç¹ûExpr1ºÍExpr2µÄÖµÏàµÈ£¬·µ»ØNULL£¬·ñÔò·µ»ØExpr1µÄÖµ ......

.NetÔÚSqlServerÖеÄͼƬ´æÈ¡¼¼Êõ

±¾ÎÄ×ܽáÈçºÎÔÚ.Net WinformºÍ.Net webform(asp.net)Öн«Í¼Æ¬´æÈësqlserverÖв¢¶ÁÈ¡ÏÔʾµÄ·½·¨
1£¬Ê¹ÓÃasp.net½«Í¼Æ¬ÉÏ´«²¢´æÈëSqlServerÖУ¬È»ºó´ÓSqlServerÖжÁÈ¡²¢ÏÔʾ³öÀ´
Ò»£¬ÉÏ´«²¢´æÈëSqlServer
Êý¾Ý¿â½á¹¹
create table test
{
id identity(1,1),
FImage image
}
Ïà¹ØµÄ´æ´¢¹ý³Ì
Create proc UpdateImage ......

³õʶSQLSERVER´¥·¢Æ÷(Ò»)


´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚÆäËü±à³ÌÓïÑÔÖеÄʼþº¯Êý£¬SQL Server? ÔÊÐíΪ INSERT¡¢UPDATE¡¢DELETE ´´½¨´¥·¢Æ÷£¬µ±ÔÚ±í£¨ÊÓͼ£©ÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQL Óï¾ä¡£
    ±¾×¨ÌâµÄÄ¿µÄ²¢·ÇÊÇÏòÄúÏ꾡µØ½éÉÜ´¥·¢Æ÷£¬¶øÊÇϵͳµØÏòÄú½éÉÜ´¥·¢Æ÷µÄ³£ÓÃ֪ʶÓëÏà¹ØÓ¦Ó㬲¢ÓëÄúÒ ......

SQLSERVERÐÞ¸´Ð¡ÖªÊ¶

ÔÚÓëÊý¾Ý¿â´ò½»µÀµÄ¹¤×÷ÖÐʱ³£»áÅöµ½Ò»Ð©Êý¾Ý¿âµÄ´íÎó£¬Õâ¾ÍÉæ¼°µ½ÁËÐÞ¸´µÄ¹ý³Ì£¬ÒÔÏÂ֪ʶµã¶¼ÊÇ´ÓÍøÉÏÊÕ¼¯¶øÀ´:
1¡¢dbcc checkdb
Õâ¸öÃüÁî¿ÖÅÂÊÇÎÒÃÇ×î³£ÓõÄÁË£¬´ø¼ì²éºÍÐÞ¸´¹¦ÄÜ
Óï·¨¸ñʽ£º
DBCC CHECKDB
[
[ ( database_name | database_id | 0
[ , NOINDEX
| , { REPAIR_ALLOW_DATA_LOS ......

SQLserverÖÐÓÃconvertº¯Êýת»»ÈÕÆÚ¸ñʽ

¡¾ÎÊÌâÃèÊö£º¡¿
      Ò»¸öÓû§±íÖеÄ×¢²áÈÕÆÚÏÔʾ¸ñʽÊÇ£ºyyyy-mm-dd Thh:mm:ss.mmm ¡£¶øÎÒÏëͳ¼Æ³öÿÌìµÄÓû§×¢²áÊý£¬Ö±½Ógroup×¢²áÈÕÆÚ×Ö¶ÎÏÔÈ»ÊDz»Ðеġ£
¡¾ÎÊÌâ´¦Àí£º¡¿
      ÀûÓÃSQLserverÖеÄconvertº¯Êý¶ÔÈÕÆÚ½øÐÐת»»×ª»»¡£groupת»»ºóµÄÈÕÆÚ¡£
¡¾½Å  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ