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

SQL²éѯ - .NET¼¼Êõ / ASP.NET

Êý¾Ý¿âÓÐÁ½¸ö×ֶΣºÌû×ÓÊýºÍÖ÷ÌâÊý
ÏëÒª²éѯ£º½ñÌìµÄÌû×ÓÊýºÍÖ÷ÌâÊýµÄ×ܺͣ¬ÈÕÆÚÊǽñÌ죬ÇëÎÊSQLÓï¾äÔõôд£¿

select ×ܺÍ=Ìû×ÓÊý+Ö÷ÌâÊý from table where ÈÕÆÚ=½ñÌì

ÒýÓÃ
select ×ܺÍ=Ìû×ÓÊý+Ö÷ÌâÊý from table where ÈÕÆÚ=½ñÌì


Õâ»Ø¸´Ì«Ç¿ÁË£¬¶¥

ÒýÓÃ
select sum(Ìû×ÓÊý£©+sum(Ö÷ÌâÊý) as ºÏ¼Æ from table where datediff(day,createdate,getdate())=0


Õý½â

ÒýÓÃ
Êý¾Ý¿âÓÐÁ½¸ö×ֶΣºÌû×ÓÊýºÍÖ÷ÌâÊý
ÏëÒª²éѯ£º½ñÌìµÄÌû×ÓÊýºÍÖ÷ÌâÊýµÄ×ܺͣ¬ÈÕÆÚÊǽñÌ죬ÇëÎÊSQLÓï¾äÔõôд£¿


Õý½â


Ïà¹ØÎÊ´ð£º

ÔÚasp.netÀïÃæ½Å±¾³ö´í - .NET¼¼Êõ / ASP.NET

function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;

var div1=document.getElementById("divPwd");

if (pwd.value=="")
{
......

WapµÄÒ»¸ö¾ÞÍ·ÌÛµÄÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......

asp.net·¢²¼Ê±£¬Oracle±¨´í - .NET¼¼Êõ / ASP.NET

1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£
2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£
3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££»
  vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......

Çóһʱ¼ä±È½ÏµÄSQL Ö¸Áî - MS-SQL Server / »ù´¡Àà

±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ