SQL Server

  Original question:   Dear teacher:   I have a field in a table to be encrypted, for example, the salary amount and name of an employee, these two fields need to be encrypted, let others go from Enterprise Manager

1. Create the following stored procedure on the data to be backed up: Create procedure [DBO]. [process name]Declare@ Filename nvarchar (100), -- file name@ Nowday int -- set the timeSet @ filename = 'f: \ jxxdata '+ Cast (Day (getdate () as varchar

Backup of server data is troublesome. manual backup is a pain point if you need to back up data on a daily or regular basis. Here I will introduce a method for creating automatic backup through SQL Server Job Scheduling: 1. Choose Enterprise Manager>

Example: If an employee table tb_user contains the field ID, name, and num (employee ID), the SQL statements of the former employee whose id = 20 is queried and the latter employee whose ID is 20 are: Previous employee: Select top 1 * From tb_user

Introduction Permission: one word, one power, and one restriction. In the software field, the common explanation is who can perform operations on which resources. In SQL Server, "who", "what resources", and "What operations" correspond to the three

Analysis: Due to Qifang Baiji software, database security adopts the most secure "hybrid mode". It is mainly used in Novell networks or peer networks, use the SPX/IP protocol and SQL Server Authentication mode. Advantages:Creates another

Microsoft SQL Server compact 4.0 is a free embedded database. Software developers can use it to build ASP. NET websites and Windows desktop applications. Program. SQL Server compact 4.0 has the following advantages: it occupies a small amount of

1. dateaddSyntaxDateadd (datepart, number, date)ParametersDatapart specifies the date component of the new value to be returned.Commonly used: Year, quarter, month, dayofyear, day, week, weekdayNumber is used to add a value to datepart. If a

I. Time Functions When using stored procedures and SQL functions, you may encounter time processing. For example, get and add or subtract time. The built-in Time Functions of SQL are used here. I will list these functions to facilitate

SQL Server blocks access to component \ 'ad hoc distributed queries \' An error occurred while querying the Excel file in SQL Server:Select * From OpenRowSet ('Microsoft. Jet. oledb.4.0 ', 'excel 8.0; IMEX = 1; HDR = yes; database = D: \ a.xls',

Ms SQL Server has two types of local temporary tables and global temporary tables: local temporary tables are only visible in the current session, starting with a symbol # (such as # tablename ); the global temporary table is visible in all sessions

This article reprinted: http://www.csframework.com/archive/2/arc-2-20130101-1971.htm   C # code: ///     /// Set local time ///     Public Class Localtimesync{[Dllimport ( " Kernel32.dll " )] Public Static Extern Bool

Known problems: Anything related to encryption involves the sqlserver server master key. Therefore, the issue of "error 15466 during decryption" is involved. You can reset the master key of the server. Note: This operation is computation-intensive

In many cases, we will use a sequential number with a specified length. If we generate an order encoding rule, we will set it to Warehouse encoding + year, month, and day (6 digits) + four sequential numbers for the current day, for example, the

Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> Declare   @   Nvarchar ( 20 ), @ B   Nvarchar ( 20 ), @ C   Nvarchar ( 20 ) Set   @   =   '

SQL functions for format conversionConvert (nvarchar (12), @ date, 111 ): The first parameter represents the length to be intercepted, the second parameter represents the database field, and the last parameter represents the date and time format

Recently, "primary school student" wrote a blog post about batch data import to the database. The experimental tool is. NET + SQL Server. Many netizens expressed their interest in this article, which is also a hot topic in 24 hours. At the same time,

Refer to the followingArticle Using SQL Server for Asp.net session state ASP. NET session state management using SQL Server   The installation process and brief description are as follows: 1. Installation and setting of ms SQL Server 1.

Let's take a simple look at how the SQL Server Index works. We will not talk about the index concepts. Clustered index: (Figure) Let's look at figure A, the structure of the clustered index. The data page is the place where the data is actually

The basic unit of data storage in SQL Server is page. Disk space allocated to data files (. mdf or. ndf) in the database can be logically divided into pages (from 0 to n consecutive numbers ). Disk I/O operations are performed on pages. That is, SQL