随笔分类 -  IT技术--SQL Server

摘要：SQL Server .NET Data Provider 连接字符串包含一个由一些属性名/值对组成的集合。每一个属性/值对都由分号隔开。PropertyName1=Value1;PropertyName2=Value2;PropertyName3=Value3;.....同样，连接字符串必须包含SQL Server实例名称:Data Source=ServerName;使用本地的SQL Server(localhost)，如果想要使用远程服务器运行，应该在示例对象中把正确的服务器赋给Data Source 属性。此外，还必须指定所支持的两种身份验证方法(即Windows身份验证和SQL Se 阅读全文

摘要：1.用一条SQL语句 查询出每门课都大于80分的学生姓名（原表数据如下图所示）查询结果如下图所示：实现该功能的SQL语句代码为：View Code use db2011createtable NameOfScoreOver80(StudentName nvarchar(10),ClassName nvarchar(10),Score smallint)insertinto NameOfScoreOver80 values('张三','语文',81)insertinto NameOfScoreOver80 values('张三','数学&# 阅读全文

摘要：Database is theasset of most online or internet based company. Everyone looks at how to improve and secure their databases to protect or improve their company. While everyone is searching for remedies or enhancement pills for their company, there are often simple mistakes made by some companies (esp 阅读全文

摘要：Previous article was on 10 Ways To Destroy A SQL Database that sort of teaches you what mistakes many company might make on their database that will eventually lead to a database destroy. In this article, you will get to know 15 ways to optimize your SQL queries. Many ways are common to optimize a q 阅读全文