MSSQLÊý¾Ý¿âÀïµÄ¼Ç¼ת³ÉJSONµÄÎÊÌâ
ÎÒ·¢ÏÖÎÒ°ÑÊý¾Ý¼Ç¼ת³ÉJSONÒ»¸öÎÊÌâ¡£
Èç¹ûÔÚÊý¾Ý¿âÀïÃæÊÇûÓл»ÐеļǼ£¬ÊÇ¿ÉÒÔ˳Àûת»»³ÉJSONµÄ
Èç¹û»»ÐУ¬¾ÍתµÄ²»³É¹¦¡£
ÄÄÃÇÐÖµÜÖªµÀÊÇÕ¦¸ãµÄ£¿
ÎÒµÄÎÊÌâ½â¾öÁË
ÒòΪÎÒÓõÄÊÇMSSQL £¬Ï뽫ÀïÃæµÄÊý¾Ýת³ÉJSON£¬È»ºó×°³ÉExtJsµÄGridPanelÖÐ
ºó¾¹ýÎÒ×Ô¼º×ÐϸµÄÅŲ飬·¢ÏÖ²»ÊÇJSONµÄÎÊÌ⣬¶øÊÇExtJsµÄGridPanel²»Ö§³Ö»»ÐС£
ºóÀ´ÎÒÔÚC#¶ËÓÃ.Replace("\r\n","")´¦Àíһϣ¬¾Í¿ÉÒÔÁË¡£
½Ó·Ö°É
jf
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬²éѯÓï¾ä²ÎÊýÓ¦¸ÃÔõôд°¡£¿
¸ø²ÎÊý¸³Öµ¡¡ÔõôŪ°¡£¿
with Query do begin
tempParam=parameters.addparameter;
tempParam.name='@begindate';
tempParam.Da ......
ÆäÖÐÒ»¸öoracleÊý¾Ý¿âÖÐÆäÖÐÒ»¸ö±íÓжà¸öʱ¼ä´Á×Ö¶Î,mssqlÖ»ÄÜÔÊÐíÒ»¸öµÄ.
ʵÔÚÓÐÎÊÌâµÄ»°£¬ ¿ÉÒÔÏȽ¨Á¢ÁíÍâµÄÒ»ÕÅ±í£¬È»ºó°Ñtimestamp¸ÄΪdate£¬°ÑÊý¾Ý¸´ÖÆÒÔºó£¬ÔÚÒÆÖ²Ò»´Î
oracleµÄʱ¼ä´ÁºÏ²¢ÎªÒ»¸ö×ֶα ......
Ò»¸öÊý¾Ý¿â±í ÀïÃæµÄ×Ö¶ÎÓÐ VIPÓû§AÀà VIPÓû§bÀà VIPÓû§cÀà VIPÓû§dÀà VIPÓû§eÀà VIPÓû§fÀà ¡£¡£¡£
ÀïÃæµÄÊý¾Ý¶¼Êǵ绰ºÅÂë ......
sql 2005ÀïÓÐЩ2000ÀïûÓеÄÓû§£¬²»ÖªµÀ·Ö±ðÓÐʲô¹¦ÄÜ£¿
³öÓÚ°²È«¿¼ÂÇ£¬ÄÄЩӦ¸Ãɾ³ýÄÄЩӦ¸Ã¾Ü¾ø·ÃÎÊ£¿
лл£¡
BUILTIN\Administrators
BUILTIN\Users
NT AUTHORITY\SYSTEM
xxxx\SQLServer ......