Posts Categorized: SQLSERVER
1. A query is written in the SQL language and is a request for information from data in a database.
2. Microsoft SQL Server uses the Transact Structured Query Language (T-SQL)
3. The percent % symbol is the most common …
include , checksum, full-text index
重新安装了sql server 2008，发现sa账户无法登录，错误是233。
ALTER LOGIN sa WITH PASSWORD=’新密码’，
Recursive relationships: relationships exist between entity instances of the same type.
One-to-one: If we were to track which employees were married to other employees, we would expect each to be married to either zero or one other employee at any …
如班级和教师的关系由三张表来表示：班级表，教师 及 班级教师表
In particular, the logical model does not contain any many-to-many relationships. There is a simple rationale for this difference – relational databases do not directly support many-to-many relationships, so they must be transformed using an intersection entity.…
select count(*) FROM [AdventureWorks].[Person].[Contact]
select COUNT(MiddleName) from [AdventureWorks].[Person].[Contact]
select COUNT(distinct MiddleName) from [AdventureWorks].[Person].[Contact]
SQL was designed as a set-oriented processing language. Some business rules( or poor physical design) require performing actions on row-by-row basis. Consider the following example:
. Increase the price of books <=$15 by 15%
. Decrease the price of books …
Creating a view using With Check Option will restrict the queries to only those rows directly visible by the view.
It prevents row from dissappearing from the view implementing this option.
drop table T100
drop view VT100