SQL¸½¼ÓÊý¾Ý¿âºó,Êý¾Ý¿âÊÇÖ»¶ÁµÄ
·½·¨Ò»
1.н¨Ò»¸öͬÃûµÄÊý¾Ý¿â
2.ÔÙÍ£µôsql server(×¢Òâ²»Òª·ÖÀëÊý¾Ý¿â)
3.ÓÃÔÊý¾Ý¿âµÄÊý¾ÝÎļþ¸²¸ÇµôÕâ¸öн¨µÄÊý¾Ý¿â
4.ÔÙÖØÆôsql server
5.´Ëʱ´ò¿ªÆóÒµ¹ÜÀíÆ÷ʱ»á³öÏÖÖÃÒÉ£¬ÏȲ»¹Ü£¬Ö´ÐÐÏÂÃæµÄÓï¾ä£¨×¢ÒâÐÞ¸ÄÆäÖеÄÊý¾Ý¿âÃû)
6.Íê³ÉºóÒ»°ã¾Í¿ÉÒÔ·ÃÎÊÊý¾Ý¿âÖеÄÊý¾ÝÁË,Õâʱ,Êý¾Ý¿â±¾ÉíÒ»°ã»¹ÒªÎÊÌâ,½â¾ö°ì·¨ÊÇ,ÀûÓÃ
Êý¾Ý¿âµÄ½Å±¾´´½¨Ò»¸öеÄÊý¾Ý¿â,²¢½«Êý¾Ýµ¼½øÈ¥¾ÍÐÐÁË.
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO
UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='ÖÃÒɵÄÊý¾Ý¿âÃû'
Go
sp_dboption 'ÖÃÒɵÄÊý¾Ý¿âÃû', 'single user', 'true'
Go
DBCC CHECKDB('ÖÃÒɵÄÊý¾Ý¿âÃû')
Go
update sysdatabases set status =28 where name='ÖÃÒɵÄÊý¾Ý¿âÃû'
Go
sp_configure 'allow updates', 0 reconfigure with override
Go
sp_dboption 'ÖÃÒɵÄÊý¾Ý¿âÃû', 'single user', 'false'
Go
 
Ïà¹ØÎĵµ£º
µÚÒ»ÖÖ£º
SELECT
CASE
WHEN
price IS NULL THEN
'Not yet priced'
WHEN
price < 10 THEN
'Very Reasonable Title'
WHEN
price >= 10 AND
price < 20 THEN
'Coffee Table Title'
EL ......
º¯ÊýÒÀÀµ
==========================================
Ò»¡¢º¯ÊýÒÀÀµ¸ÅÄî
¡¡¡¡º¯ÊýÒÀÀµÊÇ´ÓÊýѧ½Ç¶ÈÀ´¶¨ÒåµÄ£¬ÔÚ¹ØÏµÖÐÓÃÀ´¿Ì»¹ØÏµ¸÷ÊôÐÔÖ®¼äÏà»¥ÖÆÔ¼¶øÓÖÏ໥ÒÀÀµµÄÇé¿ö¡£º¯ÊýÒÀÀµÆÕ±é´æÔÚÓÚÏÖʵÉú»îÖУ¬±ÈÈ磬ÃèÊöÒ»¸öѧÉúµÄ¹ØÏµ£¬¿ÉÒÔÓÐѧºÅ¡¢ÐÕÃû¡¢ËùÔÚϵµÈ¶à¸öÊôÐÔ£ ......
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient; //ÒýÓÃÃüÃû¿Õ¼ä
namespace DAL
{
/*******************************************************************************
&n ......
SQL ServerȨÏÞ¹ÜÀí²ßÂÔ
Êý¾Ý¿â½¨Á¢Ö®ºó£¬Êý¾ÝµÄ°²È«¾ÍÏÔµÃÓÈÎªÖØÒª£¬¶ÔÓÚÒ»¸öÊý¾Ý¿â¹ÜÀíÔ±À´Ëµ£¬°²È«ÐÔ¾ÍÒâζ×ÅËû±ØÐë±£Ö¤ÄÇЩ¾ßÓÐÌØÊâÊý¾Ý·ÃÎÊȨÏÞµÄÓû§Äܹ»µÇ¼µ½SQL Server£¬²¢ÇÒÄܹ»·ÃÎÊÊý¾ÝÒÔ¼°¶ÔÊý¾Ý¿â¶ÔÏóʵʩ¸÷ÖÖȨÏÞ·¶Î§ÄڵIJÙ×÷£»Í¬Ê±£¬Ëû»¹Òª·ÀÖ¹ËùÓеķÇÊÚȨÓû§µÄ·Ç·¨²Ù×÷¡£Õý»ùÓÚ´Ë£¬SQL Server 2000ÌṩÁ ......