asp.net´Ósql server2005ÖвéѯÊý¾Ý
Ê×ÏÈÒªÌí¼Ó
using System.Data;
using System.Data.SqlClient;
½ÓÏÂÀ´£º
SqlConnection conn = new SqlConnection("server=QLPC\\SQL2005;uid=sa;pwd=£¨ÄãµÄÃÜÂ룩;database=£¨ÄãµÄÊý¾Ý±í£©"); //ÓÃÓÚÁ¬½ÓÊý¾Ý¿â
conn.Open(); //´ò¿ªÊý¾Ý¿â
SqlCommand cmd = new SqlCommand("select * from [user]", conn); //Ï൱ÓÚÖ´ÐÐÊý¾ÝÓï¾ä°É
SqlDataReader read = cmd.ExecuteReader(); //´´½¨Ò»¸öSqlDataReaderµÄreadÏó
while (read.Read()) //µ±¶ÁÈ¡µÄÊý¾Ý´æÔÚʱÔòд³öÀ´
{
Response.Write(read[0]);
}
conn.close(); //¹Ø±ÕÊý¾Ý¿âµÄÁ´½Ó
Ïà¹ØÎĵµ£º
in µÄ»°£¬ Èç¹ûÊÇnull ¾Í²»±È½ÏÁË£¬¼È²»ÊÇin Ò²²»ÊÇ not in
existsµÄ»° ÒòΪÓà = ¼ÓÔÚÌõ¼þÀï±È½ÏÁË£¬ËùÒÔ null ÊÇ not exists
select *
from pricetemp
where cast(ÉÌÆ·¥³ー¥É as varchar(10))not in(
select shohin_cd
&nbs ......
´úÂëÈçÏ£º
EXEC sp_rename '±íÃû.[ÔÁÐÃû]', 'ÐÂÁÐÃû', 'column'
*************************************************************************
Transact-SQL ²Î¿¼
sp_rename
¸ü¸Äµ±Ç°Êý¾Ý¿âÖÐÓû§´´½¨¶ÔÏó£¨Èç±í¡¢ÁлòÓû§¶¨ÒåÊý¾ÝÀàÐÍ£©µÄÃû³Æ¡£
ʾÀý
A. ÖØÃüÃû±í
ÏÂÀý½«±í customers ÖØÃüÃûΪ custs¡£ ......
1.Ê×ÏÈÐèÒª½¨Á¢plan table,·ñÔò²»ÄÜʹÓÃ
½¨Á¢·½·¨£º
$oracle\rdbms\adminÏÂÓиö
utlxplan.sql
ÆäÄÚÈÝΪ:
create table PLAN_TABLE (
statement_id varchar2(30),
timestamp date,
remarks varchar2(80),
operat ......
/// <summary>
/// ×Ö·û´®Çиî
/// </summary>
/// <param name="p_SrcString"></param>
/// <param name="p_Length"></param>
/// <returns></returns>
public static string GetSubString(string p_SrcString, int ......
ASP.NETÈý²ã½á¹¹ËµÃ÷
ÍêÉÆµÄÈý²ã½á¹¹µÄÒªÇóÊÇ:Ð޸ıíÏÖ²ã¶ø²»ÓÃÐÞ¸ÄÂß¼²ã,ÐÞ¸ÄÂß¼²ã¶ø²»ÓÃÐÞ¸ÄÊý¾Ý²ã¡£·ñÔòÄãµÄÓ¦ÓÃÊDz»ÊǶà²ã½á¹¹,»òÕß˵ÊDzã½á¹¹µÄ»®·ÖºÍ×éÖ¯ÉÏÊDz»ÊÇÓÐÎÊÌâ¾ÍºÜÄÑ˵.²»Í¬µÄÓ¦ÓÃÓв»Í¬µÄÀí½â£¬ÕâÖ»ÊÇÒ»¸ö¸ÅÄîµÄÎÊÌ⣮
Àí½âASP.NETÈý²ã½á¹¹——ΪʲôҪ·ÖÈý²ã£¿
ÎÒÃÇÓÃÈý²ã½á¹¹Ö÷ÒªÊÇÊ¹Ï ......