SQL ÔÚ´æ´¢¹ý³ÌÖÐ EXEC('CREATE TABLE ¡¡')
ΪʲôÎҵĴ洢¹ý³ÌÖÐµÄ EXEC(@SQL)
ÆäÖÐ@SQL = 'CREATE TABLE #TEMPZJXM(¡¡)'
SELECT * from #TEMPZJXM --Õâ¾ä´íÎóÌáʾ
ÏûÏ¢ 208£¬¼¶±ð 16£¬×´Ì¬ 0£¬µÚ 88 ÐÐ
¶ÔÏóÃû '#TEMPZJXM' ÎÞЧ¡£
ÇëÄÄλ´óϺ°ïÒ»ÏÂæ£¬ÏÈллÁË
'CREATE TABLE #TEMPZJXM(¡¡) go SELECT * from #TEMPZJXM '
Óï¾äдȫ°¡
×÷ÓÃÓò²»Í¬£¬EXECÖеÄÁÙʱ±í²»ÄÜÔÚÍâÃæÓÃ
SQL code:
EXEC('CREATE TABLE #TEMPZJXM(¡¡);SELECT * from #TEMPZJXM')
Òª·Ö¿ªÖ´ÐÐ,Á½ÌõÒ»Æð²»ÐеÄ
ËٶȰ¡,
execÖÐÖ´ÐеIJúÉúµÄÁÙʱ±í£¬ÔÚÍâÃæÊÇ·ÃÎʲ»µ½µÄ;¿ÉÒÔÉú³ÉÒ»¸öʵ¼ÊµÄ±í£¬¾Í¿ÉÒÔ·ÃÎÊÁË
exec('create table tb(...)')
select * from tb
EXEC('CREATE TABLE #T(NUM INT);SELECT * from #T')
²âÊÔͨ¹ý
CREATE TABLE
Ö±½Óд£¬
²»ÐèÒªÓñäÁ¿£¬È»ºóÔÙ EXEC(±äÁ¿)£¬ÕâÊǶàÓà!
Ïà¹ØÎÊ´ð£º
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
Ö¸µ ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ
ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN
¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª
ÐÕÃû ¿ÆÄ¿ ³É¼¨
ÕÅÈý Ó¢Óï 90
ÀîËÄ Ó¢Óï&nb ......