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

MS SQL 2000/2005 Ð޸ıíËùÓÐÕß´æ´¢¹ý³Ì

Create PROCEDURE [dbo].[ChangeObjectOwner]
@OldOwner as NVARCHAR(128),
@NewOwner as NVARCHAR(128)
AS
DECLARE @Name   as NVARCHAR(128)
DECLARE @Owner  as NVARCHAR(128)
DECLARE @OwnerName as NVARCHAR(128)
DECLARE curObject CURSOR FOR
select 'Name' = name,
 'Owner'   = user_name(uid)
from sysobjects
where user_name(uid)=@OldOwner
order by name
OPEN  curObject
FETCH NEXT from curObject INTO @Name, @Owner
WHILE(@@FETCH_STATUS=0)
BEGIN   
if @Owner=@OldOwner
begin
  set @OwnerName = @OldOwner +'.' + rtrim(@Name)
  exec sp_changeobjectowner @OwnerName, @NewOwner
end
FETCH NEXT from curObject INTO @Name, @Owner
END
close curObject
deallocate curObject
------------------------
˵Ã÷£ºÒÔÉÏ´úÂëÖ»ÐèÒªÔÚ´æ´¢¹ý³ÌÖÐн¨Ö´Ðм´¿É£¬µ«ÊǵÚÒ»´ÎÖ´ÐлسöÏÖ¾¯¸æºÍ´íÎó˵Ã÷£¬
Èç¹ûÄãµÄasp.net³ÌÐòÖ´ÐгöÏÖÒÔÏÂÀàËÆ´íÎó£¬ÄÇ˵Ã÷ÄãµÄÏÖÓеÄÊÔͼ»ò´æ´¢¹ý³ÌÖеıí¶ÔÏóûÓиĹýÀ´£¬ÐèÒªÐÞ¸ÄÊÓͼ»òÕß´æ´¢¹ý³Ì£»
¶ÔÏóÃû  'wzuhll.HomeWork_List' ÎÞЧ¡£
ÓÉÓڰ󶨴íÎó£¬ÎÞ·¨Ê¹ÓÃÊÓͼ»òº¯Êý 'VIEW_hw_studentlist'¡£


Ïà¹ØÎĵµ£º

SQLÖÐ CAST Óë CONVERTת»¯º¯ÊýµÄÓ÷¨

 ½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£CAST ºÍ CONVERT ÌṩÏàËƵŦÄÜ¡£
Óï·¨
ʹÓà CAST£º
CAST ( expression AS data_type )
ʹÓà CONVERT£º
CONVERT (data_type[(length)], expression [, style])
²ÎÊý
expression
ÊÇÈκÎÓÐЧµÄ Microsoft® SQL Server™ ±í´ïʽ¡£Óйظü¶àÐÅÏ¢£¬Çë² ......

ת£ºsqlÓï¾äʵÏÖ·ÖÒ³»ã×Ü

Ó¦Ò»¸öÅóÓѵÄÒªÇó£¬ÌùÉÏÊղصÄSQL³£Ó÷ÖÒ³µÄ°ì·¨¡«¡«
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
Óï¾äÐÎʽ£º
SELECT TOP Ò³¼Ç¼ÊýÁ¿ *
from ±íÃû
WHERE (ID NOT IN
  (SELECT TOP (ÿҳÐÐÊý*(Ò³Êý-1)) ID
  from ±íÃû
  ORDER BY ID))
  O ......

sql server 2005 ÅäÖÃÔ¶³ÌÁ¬½Ó

ÒÔÏÂ˵Ã÷¾ùÕë¶ÔÆóÒµ°æ»òÕß¿ª·¢°æ£»
1.¿ªÆôsql server ʵÀýµÄÔ¶³ÌÁ¬½Ó£»
    “¿ªÊ¼”-->“³ÌÐò”-->“Microsoft SQL Server 2005”-->“ÅäÖù¤¾ß”-->“SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”-->“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”--> ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ