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

.netÁ¬½Ósql server

Êý¾Ý¿âÃû£ºEmployee
±íÃû£ºEmployees
uid£ºsa
pwd£ºsa
ÎÊÌâ²¹³ä£º
×îºÃÊÇÌṩSQL SERVER½Ó¿Ú·ÃÎÊÊý¾Ý¿âµÄ´úÂë
Õâ¶Î´úÂëÊÇVS.NET×Ô¶¯Éú³É£¬ÀïÃæÓÐÄÄЩÊDz»ÐèÒªµÄÄØ£¿Ó¦¸Ã°ÑÊý¾Ý¿âÁ¬½ÓµÄ´úÂë·ÅÔÚÄĸöµØ·½ÄØ£¿
<%@ Page language="c#" Codebehind="WebForm3.aspx.cs" AutoEventWireup="false" Inherits="WebApplication1.WebForm3" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<html>
<head>
<title>WebForm3</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name=vs_defaultClientScript content="JavaScript">
<meta name=vs_targetSchema content="http://schemas.microsoft.com/intellisense/ie5">
</head>
<body MS_POSITIONING="GridLayout">

<form id="Form1" method="post" runat="server">
</form>

</body>
</html>
landy543210 µÄ»Ø´ðÊǶԵ쬲»¹ýÓÐЩÎÊÌ⣺
1¡¢ºÜÏÔÈ»LZÔÚwebÓ¦ÓóÌÐòÉÏÊÇÐÂÈË£¬Ö±½Ó¸ø´úÂëLZ¿ÉÄܲ»´óÃ÷°×£»
2¡¢LZµÄÊÇwebÓ¦ÓóÌÐò£¬ËùÒÔMessageBox¾Í²»ÒªÓÃÁË£¬ÒªµÄ»°×Ô¼º·â×°Ò»¸ö£»
3¡¢Ê¹ÓÃsqlÊý¾Ý¿âµÄÁ¬½ÓÓëÃüÁÐèÌí¼ÓÒýÓÃ
using System.Data.SqlClient;
4¡¢LZÌí¼Ó×Ô¼ºµÄÒ³Ãæ¿Ø¼þÓë´¦Àí´úÂëºó£¬È»ºó½«
landy543210µÄ´úÂëÔÚÐÞ¸ÄÏÂÒÔ·ûºÏ×Ô¼ºµÄÒµÎñÐèÇó£¬È»ºóÈ¥µôÏûÏ¢¿ò²¿·Ö£¬ÔÙÌí¼Óµ½×Ô¼ºµÄÏìӦʼþÖУ¬±ÈÈçbutton_click


Ïà¹ØÎĵµ£º

SQL Server 2000°²×°¹ÒÆðµÄ´¦Àí

¹ØÓÚSQL°²×°±»¹ÒÆðµÄÐÞ¸´´ó¼Ò¿ÉÄܶ¼Óöµ½¹ýµ±SQL±»É¾³ýºóÐèÒªÖØÐ°²×°Ê±£¬½øÈë°²×°½çÃæ¾Í»á³öÏÖSQL´íÎóÌáʾ£º ´ÓǰµÄ°²×°³ÌÐò²Ù×÷ʹ°²×°³ÌÐò²Ù×÷¹ÒÆð£¬ÐèÒªÖØÐÂÆô¶¯¼ÆËã»ú
È»¶øÕâЩ¶¼Êǰ׷Ѿ¢£¬²»¹ÜÄãÖØÐÂÆô¶¯¶àÉÙ´ÎÒ²¶¼ÎÞ¼ÃÓÚÊ£¬ÏÂÃæÎҾͽ²½²ÔõÑùÄܹ»½â³ý°²×°»òÉý¼¶Ê±Îļþ±»¹ÒÆðµÄ²Ù×÷¡£
µã»÷ ¿ªÊ¼ ÔËÐÐ ÊäÈ룺regedit ......

ÓÅ»¯SQL ServerÊý¾Ý¿â·þÎñÆ÷ÄÚ´æÅäÖÃ

ǰÑÔ
Å©ÒµÒøÐÐ×ÜÐÐ1998ÄêÒÔÀ´ÕýÊ½ÍÆ¹ãÁËаæÍøÂç°æ×ÛºÏÒµÎñͳ¼ÆÐÅϢϵͳ£¬¸ÃϵͳÊÇ»ùÓÚWindowsNT4.0ƽ̨£¬²ÉÓÿͻ§£¯·þÎñÆ÷ģʽ£¬ÒÔMicrosoft SQL ServerΪ»ù´¡½¨Á¢ÆðÀ´µÄ´óÐÍÊý¾Ý¿âÓ¦ÓóÌÐò£¬ÏµÍ³½çÃæÓѺᢲÙ×÷¼ò±ã£¬¼ÆËã¡¢·ÖÎö¡¢¼ìË÷¹¦Äܷdz£Ç¿´ó£¬Îª±£Ö¤Å©ÒµÒøÐÐϵͳ¼°Ê±½øÐÐ×ÝÏòºÍºáÏòÒµÎñÊý¾Ý²É¼¯¡¢°´ÕÕ²»Í¬ÒªÇóÉú³ ......

SQL ServerÖи÷¸öϵͳ±íµÄ×÷ÓÃ

 
sysaltfiles            Ö÷Êý¾Ý¿â              ±£´æÊý¾Ý¿âµÄÎļþ
syscharsets        Ö÷Êý¾Ý¿â        &nb ......

SQLʱ¼ä¶Î²éѯ


SQLʱ¼ä¶Î²éѯ
ACCESSµÄ»°
select * from table where date1<#2008-1-20# and date2>#2007-8-30#
MYSQLµÄ»°
select * from table where date1<'2008-1-20' and date2>'2007-3-30'
Ò²¿ÉÒÔ
select * from table where date1 between '2008-1-20' and '2007-3-30'
ÆäÖÐdate1,date2¶¼ÊÇÈÕÆÚÀàÐ͵Ä× ......

SQL Server 2000½Ì²Ä¶ÁÊé±Ê¼Ç£¨1£©

  ºÜ¾Ã֮ǰ¾ÍÏëÒª°Ñ×Ô¼ºµÄ¶ÁÊé¹ý³Ì¼Ç¼ÏÂÀ´£¬½ñÌìÉÔ΢ÕûÀíÁËһϣ¬ÈÏΪ²»¹ÜʲôÊ飬×Ô¼ºÃ»ÔõôÍêÕûµØ¿´Í꣬¸ü±ðÌáÈÏÕæµØÈ«²¿µØ¿´ÍêÁË¡£ÌýÈË˵£¬ÒªÑ¡1±¾ºÃÊéÀ´¿´£¬ÎÒ²»·´¶ÔÕâÖÖ˵·¨£¬µ«¸üÖØÒªµÄÊÇ£¬²»½öÊÇÊé±¾Éí£¬¶øÊÇÎÒÃÇ×Ô¼ºµÄÇé¿ö£¬ÊDz»ÊÇÕæÕýͶÈë½øÈ¥¿´ÁË£¬²»¹ÜÔõÑù£¬Ð´ÊéµÄÈ˵Ä֪ʶ¿Ï¶¨±ÈÄãÕâ·½ÃæµÄ֪ʶҪ¶®ºÜ¶à£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ