Tag：sqlserver
-
Time：2020-1-17
Sqlserver English word full word matching Environment: vs2013 + SQL server2012 Problem: now the database records are as follows: The sentence column stores English sentences. Now I want to find out all sentences containing “I” (word). If I use sentence like ‘% I’ as a condition, then the word “it” (case insensitive) selected as […]
-
Time：2020-1-10
Dear database administrators and engineersHello, everyone. Thank you for your support for dbask. Dbask is an open, mutual aid and convenient database Q & a community. You can ask questions on dbask if you encounter any database problems. The platform certified technical experts can answer them online for free, and finally file them into an […]
-
Time：2020-1-3
1、 Function:There are three custom functions in sqlserver2008: scalar function / inline table valued function / multi statement table valued function. First, summarize their syntax similarities and differences: Same point:1. The creation definition is the same: A, create function f [name (the type of the parameter passed in) B, returns return value type C, as […]
-
Time：2019-12-30
In order to find these stored procedures, you can spend time searching on the Internet, looking at some stored procedures that you have not yet known. Maybe in an hour or two, you may find that you want to… Maybe you are very lucky to find them. Others list all the stored procedures, functions and […]
-
Time：2019-12-28
There are three kinds of commonTimer ： System.Windows.Forms.Timer System.Timers.Timer System.Threading.Timer Zero, system.windows.forms.timer thisTimerIt is single threaded, that is, as long as it runs, other threads will wait. This timer has the following characteristics: Based on the UI thread, when the timer is triggered, the operating system inserts the timer message into the thread message queue, […]
-
Time：2019-12-27
Relationship mapping is also a key content in EF. Like attribute mapping, relationship mapping is also based onOnModelCreatingConfigure mapping in. There are three kinds of relationship mapping in EF: One to many relationship Many to many relationship One to one relationship Let’s talk about it todayOne to many relationship Zero. Create the required class Abstract […]
-
Time：2019-12-27
Article series [introduction from zero – 0] Hello world of sprint boot [introduction series-1] program structure design description of sprint boot Preface This article starts with the code practice, and the system design starts from the bottom up. Therefore, this article first introduces how to realize the design and implementation of database table entity class. […]
-
Time：2019-12-27
Because SQL Server 2000 is still widely used, many companies want to use the new SQL server, so that they can directly separate / attach or backup / restore databases and store them between different versions. Often will encounter version incompatibility. A few days ago, I encountered an error when restoring a database backed up […]
-
Time：2019-12-26
IOC is an important design idea in OO. This article will lead you to quickly master inversion of control and dependency injection. Note: Code Based on C# Zero, Ioc IOC is inversion of control in English and inversion of control in Chinese. The so-called inversion of control is that there is a call to class […]
-
Time：2019-12-26
1、 SQL Server Advantage Easy to use, scalable for distributed organizations; Data warehouse function for decision support, integration closely related to many other server software, good cost performance, etc; It brings flexibility to data management and analysis, and allows units to respond calmly in a rapidly changing environment, so as to gain a competitive advantage. […]
-
Time：2019-12-26
In fact, my computer has a database of 2000. Last year, I installed a new database of 2005 on that computer. Not long ago, I bought a new computer and installed database 2008 to attach a database on the old computer to 2008. When the project is finished and the database is transferred to the […]
-
Time：2019-12-25
1. First, open SMS, right-click any database, and start database image monitor. 2. Click Register image database, select the instance name of image database in the server instance drop-down menu, if not, you can directly click Connect, and then set it in the link to server window, as shown in the following figure: 3. […]
