sql 2000 ¸öÈ˰氲װÎÊÌâ
###############################################################################
ÕýÔÚÆô¶¯?
Chinese_PRC_CI_AS
-m -Q -T4022 -T3659
ÕýÔÚÓë·þÎñ?
driver={sql server};server=;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server Éϲ»Ö§
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (PreLoginHandshake()).
driver={sql server};server=;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server Éϲ»Ö§
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (PreLoginHandshake()).
driver={sql server};server=;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server Éϲ»Ö§
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (PreLoginHandshake()).
SQL Server ÅäÖÃ?
###############################################################################
15:51:16 Process Exit Code: (-1)
15:52:47 °²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü¡£²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍ C:\WINDOWS\sqlstp.log Á˽â¸ü¶àÐÅÏ¢¡£
15:52:47 Action CleanUpInstall:
15:52:47 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
15:52:47 Process Exit Code: (1060) Ö¸¶¨µÄ·þÎñ²¢Î´ÒÔÒѰ²×°µÄ·þÎñ´æÔÚ¡£
15:52:47 C:\W
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......