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

c#Æô¶¯Sql Server·þÎñ

³ÌÐòÆô¶¯Sql ServerÆäʵºÜ¼òµ¥
´úÂ룺
System.ServiceProcess.ServiceController   myController   =
new   System.ServiceProcess.ServiceController("MSSQL$ACCP4444"); //·þÎñÃû³Æ ÕÒÁ˰ëÌì²ÅÕÒµ½£¬±¿ËÀÎÒÍêÁË¡£ÔÚ·þÎñÉÏÓÒ¼üÊôÐÔ£¬ÄÜ¿´µ½
if (myController.CanStop)
{ }
else
{
   myController.Start();
}
//×¢ ÐèÒªÒýÓà System.ServiceProcess ÔÚÏîÄ¿->Ìí¼ÓÒýÓÃ->ÄÜÕÒµ½Õâ¸öÒýÓá£


Ïà¹ØÎĵµ£º

C#²Ù×÷¸÷ÖÖÖ´ÐÐsqlµÄ·½·¨º¬´æ´¢¹ý³Ì²Ù×÷

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Xml;
using System.Data;
namespace MyDbTest
{
class Program
{
static void Main(string[] args)
{
SqlConnection thisConnection = new SqlConnection(
@ ......

oracle10g SQL ¸ú×Ù

1.¼¤»îSQL¸ú×Ù
   ´Óoracle10gÒÔºóÌṩÁËÐµķ½·¨¼¤»îSQLµÄ¸ú×Ù£¬¼´ÊÇʹÓÃdbms_monitor°üÀ´¿ªÆô»ò¹Ø±ÕSQL¸ú×Ù¡£
   ֮ǰ¾É·½·¨ÊÇʹÓà alter session set events ..  »òÕßʹÓÃdbms_system.set_ev·½Ê½
   ʹÓÃdbms_monitor°ü¿ÉÒÔÔڻỰ£¬¿Í»§¶Ë£¬×é¼þÒÔ¼°Êý¾Ý¿âËĸö²ã¼¶¿ªÆôSQLµÄ¸ú×Ù¡ ......

LINQ to SQL ѧϰreference

http://weblogs.asp.net/scottgu/archive/2007/09/07/linq-to-sql-part-9-using-a-custom-linq-expression-with-the-lt-asp-linqdatasource-gt-control.aspx
1-9 parts are the most useful knowledge for you so far. ......

Sql ServerÊý¾Ý¿â´¥·¢Æ÷ʵÀý½²½â


´¥·¢Æ÷
     ¶¨Ò壺 ºÎΪ´¥·¢Æ÷£¿ÔÚSQL ServerÀïÃæÒ²¾ÍÊǶÔijһ¸ö±íµÄÒ»¶¨µÄ²Ù×÷£¬´¥·¢Ä³ÖÖÌõ¼þ£¬´Ó¶øÖ´ÐеÄÒ»¶Î³ÌÐò¡£´¥·¢Æ÷ÊÇÒ»¸öÌØÊâµÄ´æ´¢¹ý³Ì¡£
     ³£¼ûµÄ´¥·¢Æ÷ÓÐÈýÖÖ£º·Ö±ðÓ¦ÓÃÓÚInsert , Update , Delete Ê¼þ¡£(SQL& ......

SQL ServerÀïÃæÈçºÎµ¼³ö°üº¬Êý¾ÝµÄSQL½Å±¾

ͨ³£Çé¿öÏ£¬SQL ServerÀïÃæµÄÉú³ÉSQL½Å±¾£¬Ö»»á°üº¬Êý¾Ý¿â¼°±íµÄ×ֶνṹ£¬¶ø²»»á°üº¬±íµÄÊý¾Ý£¬Ò²¾ÍÊÇSQL½Å±¾ÀïÃæÖ»ÓÐCreate database£¬Create table ÕâÑùµÄÓï¾ä£¬Ã»ÓÐinsert into¡£
ÒòΪSQL Server²¢²»°üº¬Õâ¸ö¹¦ÄÜ£¬Ö»ÄÜ¿¿µÚÈý·½µÄ´úÂëÁË¡£
ÒÔÏ´洢¹ý³Ì¿ÉÒÔʵÏÖ£º
CREATE PROCEDURE dbo.UspOutputData
@tablenam ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ