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

SQL²åÈëÎÊÌâ¡£ - MS-SQL Server / »ù´¡Àà

Òª²åÈëÒ»¸öÖµ£¬µ«ÊÇÌõ¼þÔÚÁíÍâÒ»¸ö±íÇëÎÊÔõôдSQL °¡£¿

ÎÒÊÇÕâÑùдµÄ
SQL code:

insert into A(xc) values('123')select name from B where name='ÕÅÈý'


¿Ï¶¨²»¶Ô

ÎÒÏë °ÑÒ»¸öÖµ²åÈëA±íµÄ xc×ֶΣ¬Ìõ¼þÊÇB±í Ãû×ÖΪÕÅÈý ²Å¿ÉÒÔ
ÇëÎÊÔõôд°¡£¿
SQL code:
insert A(XC) SELECT ×Ö¶Î from B where name='ÕÅÈý'


ÒýÓÃ
SQL code
insert A(XC) SELECT ×Ö¶Î from B where name='ÕÅÈý'


ÖµÔõô²å°¡£¿

A±íÖ»ÓÐÒ»¸ö×ֶεÄÇé¿öÏ¿ÉÒÔÔËÐеÄ
insert into A select name from B where name='ÕÅÈý' 


ÒýÓÃ
A±íÖ»ÓÐÒ»¸ö×ֶεÄÇé¿öÏ¿ÉÒÔÔËÐеÄ
insert into A select name from B where name='ÕÅÈý'


A±íÓкܶà×ֶΣ¡ Öµ¶¼Ã»ÓÐдÔõô²å°¡£¡

SQL code:
insert into A(xc) select '123' from B where name='ÕÅÈý'


SQL code:
insert into A(XC)
select name from B
where name='ÕÅÈý'


ÒýÓÃ
Òª²åÈëÒ»¸öÖµ£¬µ«ÊÇÌõ¼þÔÚÁí


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ