SQL Server

1. First, open SMS and right-click on any database to start the database image monitor. 2. Click "register Image Database" and select the Instance name of the image database from the server instance drop-down menu. If not, click "Connect" and set

-- Function: Provides replacement Aggregate functions for strings.-- Note: for example, convert the following data-- Test_id test_value--------------------'A' 01, 03,04''A' 02, 04''B' 03, 04, 08''B' 06, 08,09''C' '09''C' '10'-- Convert to the

Generally, we all like to use the UI of the Database Manager to change the structure of the data table, and then naturally place the "save" button to save, but when the data volume is large, in this case, you will often see "you cannot create an

For database applications, database security is crucial. SQL Server's security function can protect data from unauthorized leaks and tampering! Below is a summary of the security chapter! The first is a summary of the security object! Let's take a

A view is a common database object that stores query results in a virtual table. The view has many advantages: 1. It can simplify operations, 2. It can set up front-end and back-end buffering, 3. It can combine and split data, 4, the most important

In the database, tables are very important. Most of the data is stored in tables. Operations on tables directly affect the data in the database! Below is my summary in this chapter! Summary of this chapter! You can directly operate a table, or

Start:--------------------------------------------------------------------------------On the network, we can see how SQL Server 2000 and SQL Server 2005 encrypt and decrypt stored procedures. Later, we analyzed the code and found that they work in

Wowexec.exe is an operating system program that supports 16-bit processes.Prepared by: Microsoft Corp.Microsoft Windows On Windows Execution ProcessSystem Process: YesBackground Program: NoNetwork used: NoHardware related: NoCommon error: Unknown

How to Use Case in SQL Case has two formats. Simple Case functions and Case search functions.Copy codeThe Code is as follows:-- Simple Case Function CASE sex WHEN '1' THEN 'male' WHEN '2' THEN 'female' ELSE 'others' END -- Case search function Case

Import an excel file with the same structure in a directory (including sub-Directories) to sql2005 in batches. You can use ssis to customize the task. A large number of images are used below to describe the entire process.1. Create a test excel file.

Copy codeThe Code is as follows:-- FunctionCREATE function fn_GetPy (@ str nvarchar (4000 ))Returns nvarchar (4000)-- WITH ENCRYPTIONAsBeginDeclare @ intLenintDeclare @ strRetnvarchar (4000)Declare @ temp nvarchar (100)Set @ intLen = len (@ str)Set @

Copy codeThe Code is as follows:USE TestDBDeclare @ conversation uniqueidentifierWhile exists (select 1 from sys. transmission_queue)BeginSet @ conversation = (select top 1 conversation_handle from sys. transmission_queue)End conversation @

As Zhou Niu has a lot of JS knowledge, I will share with you the preliminary stages of writing the stored procedure in SQL.In the database field, in the SQL, DB, and Oracle databases, it is a means to enhance or change the business functions by

Mssql update from SyntaxCopy codeThe Code is as follows:Update a set a. columnname = B. columnname from a, B where B. id = 11. System Table sysobjects Each object (such as constraints, default values, logs, rules, and stored procedures) created in

Example: display the names and salaries of all employees in the emp table: Copy codeThe Code is as follows:DeclareCursor emp_cursor is select ename, sal from emp;BeginFor emp_record in emp_cursor loopDbms_output.put_line ('name: '| emp_record.ename

For general string fields in the program, SQL Server has char, varchar, nchar, and nvarchar types. What are the differences between these four types? Here we will make a comparison. 1. Fixed Length or variable length The so-called fixed length is

In some cases, the following table value functions may be used. Table value functions are mainly used for data calculation and return result sets, which can contain parameters (a big difference with views ), if the function does not have much

StatementSELECT * FROM database A. dbo. Table A, database B. dbo. Table B B WHERE a. field = B. field"DBO" can be omitted, as shown inSELECT * FROM database A... table A, database B... table B B WHERE a. field = B. fieldSqlServer database:-- This

The Code is as follows:Copy codeThe Code is as follows:/// /// Combine two different able columns into a new DataTable/// /// source table /// tables to be merged /// list of required duplicates (empty) /// maximum number of rows in the merged

1. @ rowcount: obtain the number of affected rowsCopy codeThe Code is as follows:Update SNS_TopicData set TopicCount = TopicCount + 1 where Topic = '1'If @ rowcount> 0BeginPrint 'successfully'EndElseBeginPrint 'failed'End 2. Call stored