2498.html
来自「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题」· HTML 代码 · 共 22 行
HTML
22 行
<html>
<head>
<title>Re: sql</title>
</head>
<BODY BACKGROUND="" BGCOLOR="white" TEXT="black" LINK="red" VLINK="#808080" ALINK="">
<center>
<h1>Re: sql</h1>
</center>
<HR><p>
Posted by <a href="mailto:fann@tccm.edu.tw">刘柏泛</a> on April 05, 1998 at 01:12:32:<p>
In Reply to: <a href="2494.html"><b>sql</b></a> posted by san on April 03, 1998 at 23:27:38:<p>
newtable = Trim(Str(Mid(Date, 3, 2) - 11)) & Trim(Str(Mid(Date, 6, 1)))<br>这一行应是要取民国年加上月份的字串吧!不过这样写会有问题哦!<br>改成这样比较短 newtable = Year(Date) - 1911 & Month(Date)<p>SQL = "select * into [" & newtable & "] from [范本]"
<br>
<p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 2498-->
</ul><!--end: 2498-->
<br><HR><p>
</body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?