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

SqlServerÖвéѯ10µ½20ÌõÖ®¼äµÄÊý¾Ý

 ²éѯnorthwindÊý¾Ý¿âÖÐordersÖеÄ10µ½20Ìõ¼Ç¼
select   top   10   *   from   orders
 where   orderid > ( select  max(orderid)  from  (select top 10 orderid  from  orders order by orderid) as t  )
orders±íÖÐÒÑÓÐ×ÔÔö³¤µÄ±êʶÁÐorderid,
ÏȲé³ö±íÖÐǰʮÌõ¼Ç¼ÖеÄ×î´óorderid£¬
10ÌõÒÔºóµÄorderid¿Ï¶¨´óÓÚǰʮÌõµÄ×î´óid£¬ËùÒÔÔÙwhereÅжϼ´¿É¡£
ÁíÍ⣬Èç¹ûÒª²éѯµÄ±íûÓбêʶÁУ¬Ò²¿ÉÒÔʹÓÃÏÂÃæÕâÖÖ·½·¨£º
select   top 20 identity(int ,1,1) as id *   into  #temp  from  table
select  *  from   #temp  where  id>10


Ïà¹ØÎĵµ£º

SQLServerÖжÔËùÓеÄÓû§±íÉú³É´¥·¢Æ÷

²âÊÔµÄʱºò±È½ÏÖØÒª£¬ÎÒÃÇ¿ÉÒÔÖªµÀµ±Ç°½»Ò×Ó°ÏìÁËÄÄЩ±í
--ÓÃÓڼǼÓû§ÔÚµ±Ç°±íÉÏʲôʱºò¡¢×öµÄʲô²Ù×÷£ºupdate¡¢insert¡¢delete
create table TriggerRecord
(
 operdt datetime, --´¥·¢Ê±¼ä
 opertp varchar(10), --²Ù×÷ÀàÐÍ£ºupdate¡¢insert¡¢delete
 opertb varchar(50) --±íÃû ......

Óû§"sa "µÇ½ʧ°Ü SQLServer ´íÎó18456

 ÓÃwindowsÕ˺ݹÊÇ¿ÉÒԵǼµÄ¡£
²éÕÒÎÊÌâµÄ¹ý³Ì£º
µÚÒ»²½£º Æô¶¯ËùÓÐÓëSQLÓйصķþÎñ£¬ÎÊÌâÒÀ¾É£»
µÚ¶þ²½£º ²é¿´windows·À»ðǽ£¬±»Ä¬ÈÏÆô¶¯ÁË£¬²»Æô¶¯Ñ¡ÔñÏî±»Disabled¡£Á½¸öÌáʾ“ÓÉÓÚ°²È«¿¼ÂÇ,ijЩÉèÖÃÓÉ×é²ßÂÔ¿ØÖÆ”“Windows·À»ðǽÕýÔÚʹÓÃÄúµÄÓòÉèÖÔ£¬ÏÈÓÃgpedit.msc´ò×é²ßÂԱ༭Æ÷£¬» ......

sqlserver ¿ç¿â¿½±´Êý¾Ý


Create Procedure up_InsertData2
@ID INT
AS
BEGIN
Declare @Name NVARCHAR(30)
Declare @c1 NVARCHAR(30)
Declare @c2 NVARCHAR(30)
Declare @c3 NVARCHAR(30)
Declare @c4 NVARCHAR(30)
Declare tmpCur Cursor For Select a,b,c,d from  table1
Open tmpCur;
Fetch Next from tmpCur Into @c1,@c2,@c3 ......

.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ÖÐ×Ô¶¨ÒåÀàËÆSplit½ØÈ¡×ֶκ¯Êý

if exists (select * from dbo.sysobjects where name='SplitStr' )
drop FUNCTION SplitStr
go
CREATE   FUNCTION   SplitStr   (@splitString   varchar(8000),   @separate   varchar(10))  
RETURNS   @returnTable   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ