about the databaseAs a "feeling" (b-grid higher). NET Development engineer, how much need to know some of these little stories.
Even if it's just a matter of some nonsense.
1. File TypeDatabase (Common) Access SQLite SqlServerCe
2. There are two types of SQL Server actually said that there are two types of SQL Server, namely MSSQLSERVER, and Sybasesqlserver. The relationship between the two is like this. SQL Server, a relational database management system (DBMS) developed and promoted by Microsoft, was originally developed by Microsoft, Sybase, and ashton-tate three companies, but later with the collaboration of the two companies, They have added different extensions to their own versions, respectively. And then there's theMSSQLServer, and Sybasesqlserver.
3. Batch start How do I use batch processing to start SQL Server services? start: net start MSSQLServer (service name) Close: net stopMSSQLServer (service name) Note: Windows 7 or later needs to run CMD as an administrator.
4. Login failed login failed solution 1) Log in with Windows Authentication mode to see if authentication is supported! 2) Login with Windows authentication, "security" → "login name" to see if it is disabled!
5. What types are included in
primary key primary key primary key? Business key similar to study number, work number, social security number and so on, the General university course will default to do this thing as the primary key! (not recommended) The logical primary key has no practical meaning, and numbering alone is not related to the business logic. (recommended) Combined primary key two fields together as a primary key! This is often done in college courses. But (strongly not recommended)
6. Data type   Data types commonly used in MSSQLSERVER 1) Images image 2) string char (Ten) varchar nchar (TEN) nvarchar (Ten) varchar (max) nvarchar (max) text (Ten) ntext (Ten) 2.1) The difference between char and varchar char is a fixed-length varchar is variable-length from the point of view of compressed space, the general use of varchar is better. 2.2) differences between nchar and char for an example char (10) can store 10 letters, 5 characters nchar (10) It is encoded using Unicode and can store 10 letters and 10 characters. 2.3) What type of lengthy text is stored?Server 2000 used Text/ntext now with varchar (max)/nvarchar (max)
. NET programmers need to know--about the database