SQL
lk5423968
Everything will be better, and better, just clam down do my best to accumulate
展开
-
IF- ELSE Conditon sql code
<br />select*<br /> from tblproject, tblprojecttype<br /> Where<br /> wwprojectid=casewhen @projecttype=-2 then ttprojectid endand<br /> serviceid=casewhen @projecttype=-2 then 15 else<br /> @projecttype<br />原创 2010-08-08 21:03:00 · 693 阅读 · 0 评论 -
MySql导入导出数据库(含远程导入导出)
http://blog.csdn.net/fengfeng444333/article/details/27081877一、导入导出本地数据库 导出: 1、先运行cmd,cd 到mysql安装目录中的bin文件夹 2、mysqldump -u root -p 数据库名 > 导出文件名.sql 其他情况下: 1.导出整个数据库转载 2015-12-16 14:12:11 · 526 阅读 · 0 评论 -
年终巨献 史上最全 ——LINQ to SQL语句
http://www.cnblogs.com/jara/p/3473996.htmlLINQ to SQL语句(1)之Where适用场景:实现过滤,查询等功能。说明:与SQL命令中的Where作用相似,都是起到范围限定也就是过滤作用的,而判断条件就是它后面所接的子句。Where操作包括3种形式,分别为简单形式、关系条件形式、First()形式。下面分别用实例举例下:1.转载 2015-09-21 22:45:53 · 1081 阅读 · 0 评论 -
通过SQL Server 2008 访问MySQL
http://www.cnblogs.com/gnielee/archive/2010/04/02/access-mysql-from-sqlserver.html 在公司中经常会遇到部署多种数据库环境的情况,对于开发人员来说经常在不同数据库之间转换确实有些繁琐,本篇将介绍从SQL Server 操作MySQL 数据库的方法。数据库测试环境1. SQL Serve转载 2014-12-01 10:10:43 · 497 阅读 · 0 评论 -
Is there a way to loop through a table variable in TSQL without using a cursor?
First of all you should be absolutely sure you need to iterate through each row - set based operations will perform faster in every case I can think of and will normally use simpler code.Depending原创 2014-09-14 14:24:32 · 529 阅读 · 0 评论 -
SQL Server 2008 R2 序列号 key 产品密钥
SQL Server 2008 R2 序列号 key 产品密钥SQL ServerSQLWeb SQL Server 2008 R2 序列号 ========================================= SQL.Server.2008.R2_Sn ========================================= 数据中原创 2014-08-04 11:53:41 · 8150 阅读 · 0 评论 -
101 LINQ Samples
Learn how to use LINQ in your applications with these code samples, covering the entire range of LINQ functionality and demonstrating LINQ with SQL, DataSets, and XML.Browse all 101 LINQ S原创 2014-04-26 23:21:35 · 1224 阅读 · 0 评论 -
How to enable remote connections in SQL Server 2008?
You experience the following error message:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Veri原创 2014-04-04 15:07:27 · 1055 阅读 · 0 评论 -
Improving SQL Server Performance
http://msdn.microsoft.com/en-us/library/ff647793.aspxImproving .NET Application Performance and ScalabilityJ.D. Meier, Srinath Vasireddy, Ashish Babbar, Sharon Bjeletich and Alex Mackm转载 2013-12-29 14:23:58 · 1569 阅读 · 0 评论 -
How to troubleshoot SQL Server performance issues
http://support.microsoft.com/kb/298475SummaryBlocker script outputSQL Profiler trace logSQL Server Performance Monitor logsqldiag utilityMicrosoft Windows NT System and Application Event转载 2013-10-21 19:43:43 · 946 阅读 · 0 评论 -
How to recover SA password on Microsoft SQL Server 2008 R2
When you are using MS SQL Server in mixed mode, it is very important that you know your SA password.There can be different reasons you lost the passwordPerson who installed the SQL Server knows原创 2013-10-14 16:26:17 · 912 阅读 · 0 评论 -
3 Methods to Change SQL Server Password
"I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, I don't want to reinstall the SQL server, Th原创 2013-10-14 16:12:48 · 1114 阅读 · 0 评论 -
Dynamic Sql Order by
ORDERBY --locationcodeCASE@sortSetting WHEN'DESC'THEN CASE @columnNameWHEN'locationcode'THEN fam_nmEND ENDDE原创 2011-09-13 17:12:57 · 668 阅读 · 0 评论 -
Deleting large number of rows
<br /><br />do it in batches.. use SET ROWCOUNT to limit the rows...<br /><br /><br />原创 2011-01-10 11:12:00 · 854 阅读 · 0 评论 -
Linux C连接Mysql数据库
http://blog.csdn.net/hustspy1990/article/details/7414572注:编译时加-lmysqlclient1. 连接数据库[cpp] view plaincopy/*练习mysql数据库的连接*/ #include #include int main()转载 2015-12-08 11:01:55 · 455 阅读 · 0 评论