°²×°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£¬²»¹ýÄã²»Òªµ£ÐÄ£¬½Ó×Å°´ÉÏÊö·½·¨´¦Àí¡£
Ïà¹ØÎĵµ£º
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(
@ ......
1.¼¤»îSQL¸ú×Ù
´Óoracle10gÒÔºóÌṩÁËеķ½·¨¼¤»îSQLµÄ¸ú×Ù£¬¼´ÊÇʹÓÃdbms_monitor°üÀ´¿ªÆô»ò¹Ø±ÕSQL¸ú×Ù¡£
֮ǰ¾É·½·¨ÊÇʹÓà alter session set events .. »òÕßʹÓÃdbms_system.set_ev·½Ê½
ʹÓÃdbms_monitor°ü¿ÉÒÔÔڻỰ£¬¿Í»§¶Ë£¬×é¼þÒÔ¼°Êý¾Ý¿âËĸö²ã¼¶¿ªÆôSQLµÄ¸ú×Ù¡ ......
&nbs ......
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( ......