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

°²×°SQL Sever 2008ʱ ´íÎó´úÂë: 1605 µÄ½â¾ö·½·¨


TITLE: SQL Server °²×°³ÌÐòʧ°Ü¡£
------------------------------
SQL Server °²×°³ÌÐòÓöµ½ÒÔÏ´íÎó:
MsiGetProductInfo ÎÞ·¨¼ìË÷ Product Code Ϊ“{95120000-00B9-0409-0000-0000000FF1CE}”µÄ°üµÄ ProductVersion¡£´íÎó´úÂë: 1605¡£¡£
Óöµ½Õâ¸ö´íÎóʱ£¬½â¾ö·½·¨ÈçÏ£º
µ±ÏµÍ³ÌáʾÈç {95120000-00B9-0409-0000-0000000FF1CE}Õâ¸öGUIDʱ£¬£¨Ò²¿ÉÄÜÊDZðµÄGUID£¬·½·¨Ò²ºÍÕâ¸öÒ»Ñù£¬Èç¹ûÊDZðµÄID£¬ÕÕ×ű¾ÎÄGUID´¦ÀíÊDz»Ðеġ££©
Ê×ÏÈ°ÑÕâ¸öGUIDµÄÇ°¶Î“95120000” µ¹ÅÅ ³ÉΪ 00002159 ,È»ºóHKEY_Classes_Root\installer\UpgradeCodesÀï²éÕÒÕâ¸öµ¹ÅŵÄÖµ£¬
²éÕÒµ½ºó£¬É¾µô¡£
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UpgradeCodesÏÂÕâ¸öµ¹ÅÅÖµ£¬²éÕÒ£¬É¾µô¡£
µ½´Ë£¬Õâ¸ö»·½ÚÉϵݲװÎÊÌâ¾ÍÓ¦½â¾ö£¬²»¹ýÓÐʱϵͳ¿ÉÄÜ»áÌáʾ¶à¸öGuid£¬²»¹ýÄã²»Òªµ£ÐÄ£¬½Ó×Å°´ÉÏÊö·½·¨´¦Àí¡£


Ïà¹ØÎĵµ£º

C#²Ù×÷¸÷ÖÖÖ´ÐÐsqlµÄ·½·¨º¬´æ´¢¹ý³Ì²Ù×÷

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Xml;
using System.Data;
namespace MyDbTest
{
class Program
{
static void Main(string[] args)
{
SqlConnection thisConnection = new SqlConnection(
@ ......

oracle10g SQL ¸ú×Ù

1.¼¤»îSQL¸ú×Ù
   ´Óoracle10gÒÔºóÌṩÁËеķ½·¨¼¤»îSQLµÄ¸ú×Ù£¬¼´ÊÇʹÓÃdbms_monitor°üÀ´¿ªÆô»ò¹Ø±ÕSQL¸ú×Ù¡£
   ֮ǰ¾É·½·¨ÊÇʹÓà alter session set events ..  »òÕßʹÓÃdbms_system.set_ev·½Ê½
   ʹÓÃdbms_monitor°ü¿ÉÒÔÔڻỰ£¬¿Í»§¶Ë£¬×é¼þÒÔ¼°Êý¾Ý¿âËĸö²ã¼¶¿ªÆôSQLµÄ¸ú×Ù¡ ......

¡¾SQL SERVER2005Ò³Ãæ´æ´¢3Ö® ¾Û¼¯Ë÷ÒýµÄ´æ´¢¡¿


                                                 &nbs ......

SQLÈ¡ÈÕÆÚ

SQLÈ¡ÈÕÆÚ
SQL Server 2009-11-19 15:07:30 ÔĶÁ7 ÆÀÂÛ0 ×ֺţº´óÖÐС
·½·¨Ò»:
select CONVERT(varchar, getdate(), 120 )
2004-09-12 11:06:08
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),\'-\',\'\'),\' \',\'\'),\':\',\'\')
20040912110608
select CONVERT(varchar(12) , getdate( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ