ÔõôÁ¬½Ó°²×°Ê±Ã»ÓÐʹÓÃĬÈÏʵÀýµÄSQL Server2000?
A»úÆ÷£¨XP£©£¨10.10.6.65£©ÍêÕûµÄ¼ÆËã»úÃûÊÇ: DZD·þÎñÆ÷
ÎÒ×°ÁËÒ»¸ö¸öÈ˰棺 SQLServer2000,´´½¨ÁËÒ»¸öʵÀýÃûΪ£ºMYINSTANCE
×°ÁË£ºdotNetFx35setup.exe
²¢´òºÃÁËSP4²¹¶¡£ºSQL2000-KB884525-SP4-x86-CHS.EXE£¬
ÔÚ±¾»úÓòéѯ·ÖÎöÆ÷,ÔÚSQL Server(s)ÖÐÊäÈ룺 DZD·þÎñÆ÷\MYINSTANCE
ÓÃSQL ServerÉí·ÝÑéÖ¤£º Óû§Ãûsa ÃÜÂë123 ¿ÉµÇ¼½øÐвéѯ
µ«ÎªÊ²Ã´ÎÒÔÚ¾ÖÓòÍøÄÚB»úÆ÷£¨10.10.6.114£©£¬Óòéѯ·ÖÎöÆ÷,ÔÚSQL Server(s)ÖÐÊäÈ룺 DZD·þÎñÆ÷\MYINSTANCE
ÓÃSQL ServerÉí·ÝÑéÖ¤£º Óû§Ãûsa ÃÜÂë123 µÇ¼²»ÁË£¬
ÔÚSQL Server(s)ÖÐÊäÈ룺10.10.6.65 Ò²µÇ¼²»ÁË£¬ÎªÊ²Ã´°¡?
1433¶Ë¿Ú´ò¿ª
·À»ðǽ
ÄѵÀÒªÅähost
ÔÚÆäËû»úÆ÷Éϲéѯ·ÖÎöÆ÷Äܵǽ±¾»úµÄ²éѯ·ÖÎöÆ÷°¡???·Â·ðÖ»ÄÜ×¢²á
¾ÖÓòÍøÄÚ ·þÎñÆ÷Ãûд :DZD·þÎñÆ÷,¶Ë¿ÚºÅ£¬¶ø²»ÊÇ:DZD·þÎñÆ÷\MYINSTANCE
ÎÒд³É£º'DZD·þÎñÆ÷,1433' ÔõôҲÁ¬²»Éϰ¡£¿
DZD·þÎñÆ÷\MYINSTANCE
DZD·þÎñÆ÷,1433
¶¼ÐУ¡
ÊÇ·À»ðǽû¹Ø£¬Ð»Ð»£¡
´óˮţ£¬ÌìÌì¼û°¡£¡
´ó½ÇÅ£
Ïà¹ØÎÊ´ð£º
listidÊÇintÊý¾Ý
declare @listid nvarchar(100)
set @listid='(1,2,3,7,9,10)'
select * from forums where listid in(@listid)ʱÌáʾÈçÏ´íÎó£º
ÔÚ½« nvarchar Öµ '(1,2,3,7,9,10)' × ......
create trigger TR_Delete_pm_WorkCard
on pm_WorkCard
for delete
as
if @@rowcount=0 return
begin tran
update pm_PlanEntry
set FDispatchQty=t4.FDispatchQty - t1.FDispat ......
Êý¾Ý¿âij±í£¬Ï뽫ÆäÖÐf1,f2Á½¸ö×ֶεÄÄÚÈÝ·10±¶£¬Çë½ÌÈçºÎд·¨£¿
update tbl set f1= f1*10£¬f2= f2*10 where id=10451
ÕâÖÖд·¨»áÔì³Éplsql¿¨ËÀ
²»»á°É£¬ÄǸöid=10451 µÄÊý¾ÝÓжàÉÙ°¡~~~~
ÎÒ¹À¼ÆsqlÊDz» ......
ÎÒµÄÊý¾Ý¿âµÄ±íÊǶ¯Ì¬µÄ±í,ÔÚÌí¼ÓÊý¾ÝµÄʱºòÓÐÒ»¸ö×Ö¶ÎÊÇDATETIMEÊý¾ÝÀàÐ͵Ä,ÏÂÃæÊÇ´æ´¢¹ý³Ì
if exists (select * from sysobjects where name='proc_ADD_Order')
drop proc proc_ADD_Order
go
......