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

SQlÓαê

declare @CausName as char(20) declare @causenameid as int declare
@Description as varchar(200) declare @Caus_Id as int
declare @sign as char(20)
create table #tb ( Caus_Id int,CausName varchar(20),causNameid int,Caus_Description varchar(200),±êÖ¾ varchar(20))
 
DECLARE myCursor1 CURSOR FOR
 select Caus_Id,Caus_PersonId,Caus_Description from tbObjection_Causer where Obje_Id=25
OPEN myCursor1
FETCH NEXT from myCursor1 INTO @Caus_Id,@causenameid,@Description
WHILE @@FETCH_STATUS =0
BEGIN
select @CausName=ÈËÔ±ÐÕÃû from zgong_xxi where id=@causenameid
insert into #tb
 select Caus_Id=@Caus_Id,CausName=@CausName,causNameid=@causenameid,
 Caus_Description=@Description,±êÖ¾=@sign where @Caus_Id is not null
FETCH NEXT from myCursor1 INTO @Caus_Id,@causenameid,@Description
END
CLOSE myCursor1
Deallocate myCursor1
select * from #tb
drop table #tb


Ïà¹ØÎĵµ£º

Excel±íÊý¾Ýµ¼ÈëSql ServerÊý¾Ý¿âÖÐ

C#¡¢ASP.NETÖн«Excel±íÖеÄÊý¾Ýµ¼Èëµ½Sql ServerÊý¾Ý¿âÖжÔÓ¦µÄ±íÖС£
ÕâÀïÎÒÃǽ«E:\test.xls
ÖÐSheet1
±íÖеÄÊý¾Ýµ¼Èëµ½testÊý¾Ý¿âÖеÄmy_test
±íÖС£
Èí¼þ£ºVS2005£¬SQL Server2000,
test.xlsÖÐSheet1±íÖÐÓÐÈý¸ö×ֶΣ¬±àºÅ¡¢Ãû³Æ¡¢±¸×¢¡£¾ßÌåÄÚÈÝÈçÏÂͼ¡£




1¡¢
Ê×ÏÈ£¬ÎÒÃÇÒ ......

Excelµ¼ÈëSQLÊý¾Ý¿â³öÏÖµÄÎÊÌ⡾½â¾ö¡¿

¡¾ÎÊÌâÒ»
¡¿£ºÒѾܾø¶Ô OLE DB Ìṩ³ÌÐò 'MICROSOFT.JET.OLEDB.4.0' µÄÌØÊâ·ÃÎÊ¡£±ØÐëͨ¹ýÁ´½Ó·þÎñÆ÷À´·ÃÎÊ´ËÌṩ³ÌÐò¡£
¡¾·ÖÎö
¡¿£ºÕâÊÇÒòΪÄúµ±Ç°ÓÃÀ´·ÃÎÊÊý¾Ý¿âµÄµÇ¼µÄȨÏÞ²»¹»£¨È¨ÏÞÌ«µÍ£©¡£
¡¾½â¾ö
¡¿£ºÒªÃ´Äú»¹ÓÃsaµÇ¼£¬ÒªÃ´Ð޸ĵ±Ç°µÇ¼µÄȨÏÞ£¬²½ÖèÈçÏ£ºÆóÒµ¹ÜÀíÆ÷→°²È«ÐÔ→µÇ¼→ÕÒµ½ÄãËùÓõ ......

ÈçºÎ¼ì²éSQL Server tempdbÆ¿¾±

---È·ÈÏ·ÖÅäÆ¿¾±
SELECT session_id,wait_duration_ms,resource_description
from sys.dm_os_waiting_tasks
WHERE wait_type LIKE 'PAGE%LATCH_%' AND
 resource_description LIKE '2:%'
 
 --²éѯtempdbÖе±Ç°Òý·¢×î¶à·ÖÅäºÍ»ØÊÕ²Ù×÷
 
 SELECT TOP 10
 t1.session_id
 ,t1. ......

SQl Êý¾Ý¿âÏà¹Ø²Ù×÷

1£º
Sql server 2005ÈÕÖ¾ÎļþÌ«´ó,ʹÆä¼õСµÄ·½·¨
ÔËÐÐÏÂÃæµÄÈýÐÐ PMDataCenter  ΪÊý¾Ý¿âÃû:
backup log PMDataCenter with NO_LOG
backup log PMDataCenter with TRUNCATE_ONLY
DBCC SHRINKDATABASE(PMDataCenter) ......

SQL Server 2005 (MSSQLSERVER) ·þÎñ²»ÄÜÆô¶¯

SQL Server 2005 (MSSQLSERVER) ·þÎñ²»ÄÜÆô¶¯
Ô­Òò:VIAЭÒ锸øÆôÓÃÁË£¬Í£ÓÓVIAЭÒé”ÎÊÌâ½â¾ö¡£
"VIAЭÒé"Í£Ó÷½·¨£º¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server Configuration Manager ->´ò¿ªºóÕÒµ½"SQL Server 2005 ÍøÂçÅäÖÃ"->MSSQLSERVER ÊôÐÔµÄЭÒé &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ