sqlones
1. 调试sql查询语句mysql_fetch_row时，浏览器总是显示worning：。。。。请大师看下哪里错了
写错了 $sql="SELECT * FROM 'onetb'";
这个 换成
$sql="SELECT * FROM `onetb`";
或者
$sql="SELECT * FROM onetb";
这里 数据表名字 两边用的不是单引号( ' ) 是 ( ` ) 符号 也可以省略
2. [SQL Server]从字符串转换为 datetime 时发生语法错误
sql="select
count(id)
as
ones
from
[data]
where
emdate>'2009-01-01'
backtime
is
not
null
and
DATEADD(day,1,backtime))<=arrivetime
如果varchar中存储的字串与日期格式相符，进行datetime运算时可以显示转换
3. 请问怎么用sql筛选互斥事务
select * from sheet4 AS A
where not exists (select * from sheet4 where 对应的事务代码<A.对应的事务代码 and 对应的事务代码=A.互斥的事务代码 and 互斥的事务代码=A.对应的事务代码)
4. sql2005的数据库还原到sql2000
一老外文章，按步骤做就可以了
As you may all know, SQL Server 2005 request a minimum of 8GB RAM to work… let’s say satisfactorily. I first didn’t know that and after a while from the upgrade I did from SQL Server 2000 to 2005 my SQL Services were starting to crash three or four times per DAY!!!
At first I thought I was being attacked, but soon I realized it was nothing like that. I then decided to downgrade to a SQL Server 2000 edition. Though I looked around the internet to find some information on how to do that, I got very disappointed when I realized that no actual documentation of any kind could be found for that. So I am posting this thread to inform you on the proceres I had to follow for this action.
Before beginning I must assume, firstly that the user, who will attempt such thing, has a basic knowledge of SQL Environment, secondly that he has the two versions already installed (both 2000 and 2005), that a basic backup of the databases has been created and finally that all the 2005 SQL Server Users have been created at the SQL Server 2000 environment as well.
Step 1: Generating Scripts for the Database Elements and Structures
1. Right-click over the desired Database at 2005, Choose Tasks and the Generate Scripts (Option).
2. At the pop-up Dialog Box click at the Script All Objects in the selected Databases check box, to activate it and then Click the Next Button.
3. Set the following Elements to the following Values
1. Script Collation , set to TRUE
2. Script Database Create, set to TRUE
3. Script of SQL Version, set to SQL SERVER 2000
4. Script foreign keys, set to FALSE
5. Script Triggers, set to FALSE Then Hit the Next button
4. Select the way the generated scripts should be saved (There are different selections. The most common one is Clipboard). Finally click the Next button till you reach the end.
5. Click Finish
After completing this procere, we have to move to the SQL SERVER 2000 environment. Here, by using the Query Analyzer, we will have to run the scripts that were generated using the master database. Copy and Paste the script at the Query Analyzer and run it. After that the Structure of the Database will be created.
Be careful, the SQL Server 2005 Edition inserts the Views in a random place through the script. Therefore, all the scripts that are referred to the Views MUST be moved to the end of the script. If the Query Analyzer shows some errors do not be bothered. Delete all the elements created from the script and after you fix the code run it again.
Step 2: Moving the data from 2005 to 2000
1. After completing the previous step successfully, moving the data follows. Right-click at the 2005 database you used to run the previous step and select Tasks and then choose the Export Data (option).
2. From the pop-up Dialog Box, select the Source Db and Click at the Next Button.
3. At the next step you will have to choose the destination server and the destination Database for the Data to be exported. Then Click Next.
4. A List of all the Source Database’s Elements will appear in the screen. Select one by one all the Elements you wish to move and for each one click at the button Edit Mappings (Located at the bottom right corner of the Dialog Box just under the Elements list). A new Dialog box will pop-up. Select the Delete rows in Destination Tables option and activate the Enable Identity Insert Option. (Remember to repeat this action for each of the selected Element from the list that will be moved.
CAUTION!!! A malfunction of the SQL Server 2005 has been found. Not sure why, after multiple tries I have observed that when I tried to move more than twelve Elements at once, the Export Data Wizard of SQL Server 2005 seemed to disable the Enable Identity Insert Option that was activated over the Edit Mappings Dialog Box. But if the number of the selected Elements is smaller than 12 no problem seemed to appear.
Step 3: Generating Scripts for the Database Foreign Keys and Triggers
Finally, to successfully finish the downgrade of the Database, the Triggers and the Foreign Keys of the DB must be proced. The procere that should be followed is the one stated next:
1. Right-Click at the SQL 2005 Database and Select from Tasks Menu the Generate Scripts Option.
2. Using the pop-up Dialog Box make sure that the check box Script All Objects in the selected Databases is not enabled and hit the Next Button.
3. Set all the Elements on the List to a False Value except the ones that follow:
1. Include IF NOT EXISTS , set to TRUE
2. Script Owner, set to TRUE
3. Script of SQL Version, set to SQL SERVER 2000
4. Script foreign keys, set to TRUE
5. Script Triggers, set to TRUE
6. Then Hit the Next button
4. After finishing reading the Elements of the Database, a new list will appear at the Dialog Box. Make sure that you select ONLY THE TABLES of the Database and hit the Next Button.
5. At the screen that follows hit the Select All button and the Next.
6. Select the way the generated scripts should be saved (There are different selections. The most common one is Clipboard). Finally click the Next button till you reach the end.
7. Click Finish Button.
After completing this procere, we have to move to the SQL SERVER 2000 environment. Here, by using the Query Analyzer, we will have to run the scripts that were generated using the master database. Copy and Paste the script at the Query Analyzer and run it. After that the Foreign Keys and the Triggers of the Database will be created.
After these steps the database should be fully functional under the SQL Server 2000 edition.
5. .net关于数据库连接字符串|DataDirectory|是什么意思
|DataDirectory| 是指 App_Data目录
这个目录是专门用来放数据库的，更安全，建议你放在这个目录，
放在其它目录，如果别人知道你的数据库具体路径，可以直接下载，而放在|DataDirectory| 就算别人知道具体路径也是无法下载的
如果你想放在其它路径！可以直接填完整地址
比如 Data Source=C:\data\Data.accdb;
6. sql函数调用返回值为空
CREATE FUNCTION GetPayedMoneyByCard(@paysequence varchar(10))
RETURNS numeric
AS
BEGIN
DECLARE @TempMoney numeric
select @TempMoney = sum(isnull(payedmoney,0)) from tbpayaddones where paysequence=@paysequence
return @TempMoney
END
7. 电脑维护软件（工具）
你得有一套系统盘。
桌面极的，winxp、win7、win8。win2000、win vista;
服务器极的，win nt、win 2000、win 2003、win 2008;
有可能还要知道:linux、unix、mac等系统。
数据库:sql server、mysql、oracle;
杀毒：瑞星、卡巴斯基、金山、kv、360等。我说的都是网络版本不是单版本。
办公软件：wps、office 2003、2007、2012；
输入法：QQ五笔、搜狗输入法。
驱动：驱动精灵
winpe光盘版本，U盘版本。
系统备份软件：ghost
硬件：防火墙、路由器、二层交换机、三层交换机、无线路由器、UTM。
线路上要了解：双绞线、光纤、无线。
不间断供电：UPS。
对服务器要了解：塔式服务器，机架式服务器，刀片式服务器，小型机。
有些公司还要求：电话交换机、监控器、门禁、考勤。
还有一些系统：如OA、邮件、财务、人力资源、固定资产。公司网站等。
终端电脑及周边设备：台式机、笔记本、扫描仪、打印机、复印机、传真机。
还有些公司会有会议系统：比如投影、音响、mic、录音、录像。
8. 如何把my sql中数据库还原到sql server 2000中
一老外文章，按步骤做就可以了
As you may all know, SQL Server 2005 request a minimum of 8GB RAM to work… let’s say satisfactorily. I first didn’t know that and after a while from the upgrade I did from SQL Server 2000 to 2005 my SQL Services were starting to crash three or four times per DAY!!!
At first I thought I was being attacked, but soon I realized it was nothing like that. I then decided to downgrade to a SQL Server 2000 edition. Though I looked around the internet to find some information on how to do that, I got very disappointed when I realized that no actual documentation of any kind could be found for that. So I am posting this thread to inform you on the proceres I had to follow for this action.
Before beginning I must assume, firstly that the user, who will attempt such thing, has a basic knowledge of SQL Environment, secondly that he has the two versions already installed (both 2000 and 2005), that a basic backup of the databases has been created and finally that all the 2005 SQL Server Users have been created at the SQL Server 2000 environment as well.
Step 1: Generating Scripts for the Database Elements and Structures
1. Right-click over the desired Database at 2005, Choose Tasks and the Generate Scripts (Option).
2. At the pop-up Dialog Box click at the Script All Objects in the selected Databases check box, to activate it and then Click the Next Button.
3. Set the following Elements to the following Values
1. Script Collation , set to TRUE
2. Script Database Create, set to TRUE
3. Script of SQL Version, set to SQL SERVER 2000
4. Script foreign keys, set to FALSE
5. Script Triggers, set to FALSE Then Hit the Next button
4. Select the way the generated scripts should be saved (There are different selections. The most common one is Clipboard). Finally click the Next button till you reach the end.
5. Click Finish
After completing this procere, we have to move to the SQL SERVER 2000 environment. Here, by using the Query Analyzer, we will have to run the scripts that were generated using the master database. Copy and Paste the script at the Query Analyzer and run it. After that the Structure of the Database will be created.
Be careful, the SQL Server 2005 Edition inserts the Views in a random place through the script. Therefore, all the scripts that are referred to the Views MUST be moved to the end of the script. If the Query Analyzer shows some errors do not be bothered. Delete all the elements created from the script and after you fix the code run it again.
Step 2: Moving the data from 2005 to 2000
1. After completing the previous step successfully, moving the data follows. Right-click at the 2005 database you used to run the previous step and select Tasks and then choose the Export Data (option).
2. From the pop-up Dialog Box, select the Source Db and Click at the Next Button.
3. At the next step you will have to choose the destination server and the destination Database for the Data to be exported. Then Click Next.
4. A List of all the Source Database’s Elements will appear in the screen. Select one by one all the Elements you wish to move and for each one click at the button Edit Mappings (Located at the bottom right corner of the Dialog Box just under the Elements list). A new Dialog box will pop-up. Select the Delete rows in Destination Tables option and activate the Enable Identity Insert Option. (Remember to repeat this action for each of the selected Element from the list that will be moved.
CAUTION!!! A malfunction of the SQL Server 2005 has been found. Not sure why, after multiple tries I have observed that when I tried to move more than twelve Elements at once, the Export Data Wizard of SQL Server 2005 seemed to disable the Enable Identity Insert Option that was activated over the Edit Mappings Dialog Box. But if the number of the selected Elements is smaller than 12 no problem seemed to appear.
Step 3: Generating Scripts for the Database Foreign Keys and Triggers
Finally, to successfully finish the downgrade of the Database, the Triggers and the Foreign Keys of the DB must be proced. The procere that should be followed is the one stated next:
1. Right-Click at the SQL 2005 Database and Select from Tasks Menu the Generate Scripts Option.
2. Using the pop-up Dialog Box make sure that the check box Script All Objects in the selected Databases is not enabled and hit the Next Button.
3. Set all the Elements on the List to a False Value except the ones that follow:
1. Include IF NOT EXISTS , set to TRUE
2. Script Owner, set to TRUE
3. Script of SQL Version, set to SQL SERVER 2000
4. Script foreign keys, set to TRUE
5. Script Triggers, set to TRUE
6. Then Hit the Next button
4. After finishing reading the Elements of the Database, a new list will appear at the Dialog Box. Make sure that you select ONLY THE TABLES of the Database and hit the Next Button.
5. At the screen that follows hit the Select All button and the Next.
6. Select the way the generated scripts should be saved (There are different selections. The most common one is Clipboard). Finally click the Next button till you reach the end.
7. Click Finish Button.
After completing this procere, we have to move to the SQL SERVER 2000 environment. Here, by using the Query Analyzer, we will have to run the scripts that were generated using the master database. Copy and Paste the script at the Query Analyzer and run it. After that the Foreign Keys and the Triggers of the Database will be created.
After these steps the database should be fully functional under the SQL Server 2000 edition.
9. @读音是什么
“@”读音是ài tè。在我国，@的读音也出现了多个读法，比较流行的有两种：一是“圈a”，二是“花a”。实际上，在电子邮箱的表示形式中，@有着at的含义，即“某用户”在“某服务器”。在电子邮箱的表示形式中，应该根据此处@的具体含义，将其读作at的读音——“艾特”。
“@”是一个符号，电邮应用中意义为“at”，即“某用户”在“某服务器”。它在社交应用如微博中也有广泛应用。在英文状态下输入键是上档键（shift）+2，或者使用 Alt+64（按住Alt并在小键盘上输入64，然后松开Alt）。
(9)sqlones扩展阅读
来历：
就职于美国国防部发展军用网络阿帕网BBN电脑公司的电脑工程师雷·汤姆林森带来了这场划时代的变革。1971年，汤姆林森奉命寻找一种电子邮箱地址的表现格式。他编写了一个小程序：
可以把程序的文件转移协议与另外一个程序的发信和收信能力结合起来，使一封信能够从一台主机发送达到另外一台。于是，第一封电子邮件就诞生了。汤姆林森把程序最后搞定时，给工作人员发了一封邮件，告诉他们可以给其它电脑发信了。汤姆林森说：“所以，电子邮件是自己宣布问世。”
10. SQL查询重复以及删除重复的命令
您好，删除2条完全一样的数据
http://hi..com/wangqing999/blog/item/e90c4012ae8b5d0c962b4357.html
至于 删除包含中文数据, 条件就是 LEN( 字段1 ) <> DATALENGTH (字段1)
参考下面这样的 SQL 语句：
SELECT
LEN('中文') AS [字符的长度],
DATALENGTH('中文') AS [字符所占字节数];
字符的长度 字符所占字节数
----------- -----------
2 4
(1 行受影响)
SELECT
LEN('English') AS [字符的长度],
DATALENGTH('English') AS [字符所占字节数]
字符的长度 字符所占字节数
----------- -----------
7 7
(1 行受影响)