• SQL Server’s statement category database normal form system database composition


    Preface Finally, on this day, I will start to learn the database system again. If there is no accident about the database, I will update one article regularly every day, and the content will not contain too much, short content and in-depth understanding. SQL statement category SQL statements include the following three categories (1)Data definition […]

  • Explain SQL Server database architecture and objects, define data integrity


    Preface In this section, we will continue our journey of SQL. In this section, we will talk about some basic knowledge and what we need to pay attention to. If there is something wrong, please point out the short content and in-depth understanding. Database schema and objects The database contains the schema, and the schema […]

  • Using scom to monitor SQL Server Service


    please find “Microsoft SQL Server -> SQL server 2005/8/12/14 -> Database Engines-> Database Engines View. And one you will enable it you can check its data via SQL 2005/8/12/14 DB Engine > Entity Health > Performance > Blocking Sessions

  • Writing stored procedures in SQL Server 2005


    However, in SQL Server 2005, we can write stored procedures (as well as methods, triggers, and other components) in the. Net family language, mainly vb.net and C ා. Let’s familiarize ourselves with five common questions about writing new methods of stored procedures. They are very worthy of our discussion.1. Why do we have to use […]

  • Entity Framework one-to-one relationship mapping


    One to one relationship is a very complex relationship in the Entity Framework, involvingHasOptional 、WithRequired 、 WithOptionalPrincipal 、 WithOptionalDependent。 In this article, we will explain the usage of these. We take members and orders as an example. A member may or may not have orders, but an order absolutely belongs to a member. We first […]

  • Entity Framework many to many mapping


    In the previous article, we explained the one to many relationship mapping in EF. In this article, we explained the many to many relationship mapping in EF. In this article, we also use a simple example to explain many to many relationship mapping. Zero, automatically generate relation table Story: in a student course selection system, […]

  • Entity Framework entity status


    Starting from today, we will start to explain entity state and data operation in EF. This article first introduces entity state.Through the previous learning, we know that EF is responsible for tracking the status of entities through the upper and lower positions, and the location of entity status is in the namespaceSystem.Dat.EntityLiEntityStateThere are 5 specific […]

  • Entity Framework (5)


    stayMany to many relationship mappingThe association table in is generated automatically by EF. But sometimes we need to show the definition association table. We can define it as follows (continue to use many to many relationship mapping this article code): Define the association table class: public class StudentCourses : BaseEntity { public int StudentId { […]

  • Easy to understand difference between ref and out


    refandoutIt’s the two keywords that are often used in C ා development, but many people don’t know the specific difference between the two keywords. Let’s talk about the two key differences. Similarities and differences between zero, ref and out Same: All by address; The values of the original parameters will be changed after use; Compile […]

  • Six methods of SQL server using SSMS to run SQL script


    Abstract: Here are five ways to run SQL scripts, as follows: Experimental environment: SQL Server 2008 R2 In a meeting discussion, you asked me how to use SSMS to run SQL scripts. In the following, I will give examples of how to run SQL scripts, as follows: 1. Select the SQL script to be run […]

  • Implementing object synchronization lightweight in SQL Server database based on Python


    Reason A similar problem is often encountered in daily work: synchronizing some specified tables on one server to another server. Similar requirements can be easily implemented by SSIS or other ETL work. For example, if SSIS is used, there will be a considerable number of repeated manual operations. Build the database information of source and […]

  • Official description of SQL Server 2005 system configuration requirements


    SQL Server 2005 (32-bit) system requirementsminimum requirementsprocessor500 MHz or faster processor (1 GHz or faster recommended)operating system• SQL Server 2005 Enterprise Edition and standard edition can run on the following operating systems:• Windows Server 2003,Standard Edition1 • Windows Server 2003,Enterprise Edition2 • Windows Server 2003,Datacenter Edition3 • Windows Small Business Server 2003 Standard Edition • […]