SQL Server

Partial reference from: https://www.cnblogs.com/knowledgesea/p/3699851.htmlFirst, what is a cursorA cursor is a method that takes a set of data and can interact with a single record at once, and can navigate to a row in the result set, read and

1 PackageDatabase;2 ImportJava.sql.*;3 Public classDbutil {4 //Here you can set the database name5 Private Final StaticString URL = "Jdbc:sqlserver://127.0.0.1:1433;databasename=mythree"; 6 Private Static FinalString user= "SA"; 7

Database Knowledge points1. Database operations:Add: INSERT into Table name values (value 1, value 2, value 3)Delete: Delete column name from table name whereConditionsChange: Update table Name set = value whereTable name = valueCheck: SELECT * FROM

IP and ConfigurationInstalling AD and DNSTo upgrade a server to a domain control serverClick Promote this server to a domain controller, as followsSelect Add a new forest,root domain name to fill in the sql.com (you can define it yourself: such as

In the daily management of the maintenance of SQL Server, we need to pay attention to a lot of places, and then sometimes do things do not work, now on the basic principles and solutions to common problems, here to share with you.Let's start by

A recent new job is to archive SQL Server for four or five years of aging data (contracts, payments, reimbursements, etc.) because of the large daily data increment, and the fact that historical data is infrequently used, affecting data query

One, uninstall SQL Server (R2)1, find the Control Panel, WIN8 and Win7 can directly point to the "Start" button to find.(Tip:win10 system's small pot friends can click "All Apps" under "Start" menu, find Windows System, click Open Sub-menu, you can

Database design is a relatively important part of database knowledge, we need to understand the basic steps of database design, e-r drawing.A basic overview of database designThe standard of testing a database design is to see if he can easily

1 Enter the following command to start, stop, or pause services from the SQL Server command line.The SQL Server command line is as follows:Start SQL ServerNET START MSSQLSERVERPausing SQL ServerNET PAUSE MSSQLSERVERRestarting a paused SQL ServerNET

SQL Server detects data that is not digital (two methods)Detection is not a digital type of data, two methods1. IsNumeric ( expression )2. PATINDEX ( '%pattern%' , expression )1. IsNumeric ( expression )Returns 1 if it is a numeric type, or 0 if

　　If exists (select * from sys.objects where object_id = object_id (n ' dbo.nvl ') and type = N ' FN ' ) Begin Drop function [dbo].[ nvl];endgocreate function Dbo.nvl (@check_value sql_variant, @replace_value

1. Create a customer sheet1 IF object_id('dbo. Employees','U') is not NULL2 DROP TABLEdbo. Employees;3 4 CREATE TABLEdbo. Employees5 (6EmpidINT not NULL,7FirstNameVARCHAR( -) not NULL,8LastNameVARCHAR( -) not NULL,9HireDate DATE not NULL,

Reference:1. After the SQL query statement group BY, the string merge2. SQL FOR XML Path usage#需求: Merge the column value table structure with the following data: ID value----- ------ 1AA1BB2AAA2BBB2CCC needs to get results: IDValues ----- --------

Brief introductionA transaction is a single unit of work, which means that there are multiple operations within the unit and that the transaction is a consolidation of multiple operations. If a transaction executes successfully, all data operations

1. CursorsPurpose: In the case of a lot of data, if the Java code in the loop after the update data, will cause frequent database connection, cost performance, so you can use the cursorRole: Queries come out of the collection directly in SQL to

1. Modify the field name:ALTER TABLE name rename column A to B2. Modify the field type:ALTER TABLE name ALTER COLUMN field name type NOT NULL3. Modify the field default valueALTER TABLE name add default (0) for field name with valuesIf the field has

SQL Server 2008 DatabaseThe database is the core of SQL Server 2008, which can be used to store user information for subsequent retrieval operations, or as a temporary storage area for SQL Server operations. The previous chapters describe the

1. Create a WinForm program and add a button control2.Button EventsPrivate void button1_click (object sender, EventArgs e) { new OpenFileDialog (); if (FD. ShowDialog () = = DialogResult.OK )

A paging problem, DTCms3.0, paging is based on the time page, if the Add Time (add_time) is the same value, regardless of the number of pages clicked, the data displayed is the same content, so there is a need to change the same time to specify a

The Confluence Installation Wizard will guide you step-by-stage in configuring the SQL Server database to be installed in confluence.Using a JDBC connection (default)JDBC is the recommended way to connect your confluence to the database.The