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

vcÖÐsqlserverÄ£ºý²éѯÎÊÌ⣡ - VC/MFC / Êý¾Ý¿â

C/C++ code:

GetDlgItem(IDC_EDIT_SEARCH)->GetWindowText(m_ipsearch);
CoInitialize(NULL);
_ConnectionPtr tempConn(__uuidof(Connection));
_RecordsetPtr tempRst(__uuidof(Recordset));

tempConn->ConnectionString="Provider=SQLOLEDB;driver=SQL Server;Server=10.11.1.166;Database=tongxue;uid=sa;Password=321456";
tempConn->Open("","","",adConnectUnspecified);
CString sql;
sql.Format("select servip from serviceip where instr(servip, '%s') > 0",m_ipsearch);
//sql.Format("select servip from serviceip where servip ='%s'",m_ipsearch);
tempRst = tempConn->Execute((_bstr_t)sql,0,adCmdText);
if(!tempRst->rsEOF)
{
m_servip=(TCHAR*)(_bstr_t)tempRst->GetFields()->GetItem("servip")->Value;
((CComboBox*)GetDlgItem(IDC_COMBO_IP))->AddString(m_servip);
tempRst->MoveNext();
}
else MessageBox("¸ù±¾Ã»ÕâÕâºÅIP£¡");




m_ipsearchÊÇÒ»¸öCStringÀàÐÍÊý¾Ý£¨´ÓÒ»¸öedit ¿Ø¼þÖлñµÃ£©,serviceipÊÇÊý¾Ý¿âÖеÄÒ»¸ö´æ´¢IP±íÃû£¬
servipÊǾßÌåIP×Ö¶ÎÃû£»È»ºó´Ó±íserviceipµÄservipÖÐÄ£ºý²éѯm_ipsearch£¬²¢½«²éѯµ½µÄ½á¹ûÌí¼Óµ½
Ò»¸öcombo¿Ø¼þÖС£
  µ«³ÌÐòÔÚÔËÐе½tempRst = tempConn->Execute((_bstr_t)sql,0,adCmdText); ʱ±¨´í£º

  Runtime Error!


Ïà¹ØÎÊ´ð£º

sqlserverÌí¼ÓÊý¾ÝµÄÎÊÌâ - Java / Java EE


ÒÔÏ´úÂëÊÇÌí¼ÓÊý¾Ý°´Å¥µÄ´úÂ룬Ïë°Ñtestid£¬ºÍtestnameÁ½¸ötxt´«µÝµ½Êý¾Ý¿âÖÐ
Êý¾Ý¿âÁ¬½Ó¿Ï¶¨Ã»ÎÊÌâ
¾ÍÊǺìÉ«²¿·ÖÀϱ¨´í
²»ÖªµÀΪʲô-£¬-
Çë¸÷λ¸ßÈ˰ïæ¿´¿´£¡
лл£¡
Java code:

private void new ......

¼±¼±¼±,SqlServerµÄÎÊÌâ

ÎÒÍùSqlServerÖмÓÊý¾ÝµÄʱºò,Ëû¸øÎÒ±¨Á˸ö´í
˵:"µ± IDENTITY_INSERT ÉèÖÃΪ OFF ʱ£¬²»ÄÜÏò±í 'O_TRAIN_CATEGORY' ÖеıêʶÁвåÈëÏÔʽֵ¡£"
ÒòΪÎÒÕâ¸ö±íµÄÖ÷¼üÉèÖõÄÊÇ×ÔÔöµÄ!ÊDz»ÊÇ×ÔÔöû¿ª°¡?Ôõô¸ ......

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

sqlserver Êý¾Ý¿â±¸·ÝÎÊÌâ

ÎÒÔÚ±¾µØÓÃMicrsosoft sql server managementÁ¬½Ó·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÎÒÏë°Ñ·þÎñÆ÷ÉϵÄÊý¾Ý¿â ±¸·Ýµ½ÎÒ±¾µØ¡£¿ÉÒÔÔõôҲ²»³É¹¦¡£
µÚÒ»ÖÖ·½·¨ÊÇÓÃsql£º
Backup Database test_database
To disk='C:\test_database ......

sqlserver ´æ´¢¹ý³ÌÖе÷ÓÃ×Ô¶¨Ò庯Êý

º¯ÊýʵÏÖÈçÏ£º
GO
CREATE FUNCTION dbo.fn_Sum(@code varchar(50))
RETURNS varchar(8000)
AS
BEGIN
DECLARE @values varchar(8000)
SET @values = ''
SELECT @values = @values + ',' + values from test ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ