sql server common criteria compliance

Label:The following are common: --E- mails should be used very often. execMsdb.dbo.sp_send_dbmail@profile_name = @mail_profile,--Mail configuration main file, generated through the Database Mail Configuration Wizard, generally called ' dba_profile ', detailed look @recipients = @email_recipients,--address, multiple comma-separated @copy_recipients = @mail_copy_recipient,--cc Address @blind_copy_recipient

A faulty statement: SQL = "select PWD, answer from [member] Where userid = '" userid "' and answer = '" Answer "'" You can also make such a low-level error. At this time, you only need to construct a special user name and password based on SQL, such as 'or '1' =' 1, a faulty statement: SQL = "select PWD, answer from [member] Where userid = '" userid "' an

Global variable format: @@***These variables are system-maintained and do not require our own definition, and are generally used to view information. The most used @ @error in the stored procedure to determine if there is an error message. One, @ @version: View version informationTwo, @ @identity: View the current identity, followed by the INSERT statement6 of the last face with the largest ID. After an INSERT statement is executedInsert into Sdetail (Sname,sscore,sgender) VALUES (' da Vinci ',0

Tags: SQL Server -New Create TABLE [dbo]. [Bi_dim_date] (--YYMMDD [DATEF] [nvarchar] (a) null,--French date format [DateKey] [nvarchar] () null, [dim_year] [int] NULL, [Dim_month] [INT] NULL, [dim_day] [int] NULL,--quarter [Qu] [int] null, [QUCN] [varchar] (+) NULL, [Quen] [varchar] (20) NULL,--month [MONTHCN] [varchar] () NULL, [Monthen] [varchar] (a) NULL,--1 early 2 mid 3 [Ten] [int] NULL, [TE

server| Error Three of the most common errors in SQL Server connections: One. " SQL Server does not exist or access is denied " This is the most complex, the cause of the error is more, need to check the aspect also more. Gener

Common SQL Server Functions 1. Statistical functions AVG, Count, Max, Min, Sum For most Parties, null rows are not counted. It can be used with distinct to remove duplicate rows. Can be grouped with group 2. mathematical functions SQRTCeiling (n) returns the smallest integer greater than or equal to n.Floor (N), returns the largest integer less than or

Comparison of common functions of SQL Server and Oracle --------- Mathematical functions1. Absolute ValueS: select abs (-1) valueO: select abs (-1) value from dual2. INTEGER (large)S: select ceiling (-1.001) valueO: select ceil (-1.001) value from dual3. Round (small)S: select floor (-1.001) valueO: select floor (-1.001) value from dual4. Round (truncation)S: sel

1. Get the current timeSELECT GetDate ();2. Get time in separate years, months, days and hours, minutes, secondsYear (GetDate ()) part of the current timeMonth (GetDate ()) monthly part of the current timeDay part of the current time (GetDate ())The above function, in turn, returns the value of type int, which returns nvarcharDatename (year, GetDate ())Datename (MONTH, GetDate ())Datename (Day, GetDate ())3. Calculate a time interval of two date typesDATEDIFF (year, ' 2013-01-01 ', ' 2014-01-01

--modifies the Functionno node value, @OperateFunctionNo the parameter set @DataXml. Modify (' Replace value of ' (/cruddata/functionno/text ()) [1] With Sql:variable ("@OperateFunctionNo")　　--delete node set @DataXml. Modify (' Delete (/cruddata/datakey) [1] ')　　--Insert node set @DataXml. Modify (' Insert 　　--Insert text set @DataXml. Modify (' Insert Text{sql:variable (@DataKey)} as first into (/cruddata/datakey) [1] ')　　The--datakeylist value gets the set @DataKeyList = @DataXml. Value (' (/

point--String intercept SUBSTRINGSelect substring (' ABCDEFG ', 2, 3); Intercept 3 bits starting from 2nd, index starting from 13. Time-Date function:--Get current system time GetDate ()Select GETDATE ();Sysdatetime () Gets the timestamp of the database service--Get Month daySelect year (' 1999-1-1 ');--Determine if the date is correct, isdate return bitSelect IsDate (' 2000-2-31 ') returns the bit type, False is 0,true is 1--Add Time DateAddSelect DATEADD (year,5, ' 2000-1-1 '); Add what type,

('helloworld! ','o','e') Result: hellewerld! Returns the inverse value of a string valueReverse (string_expression) Select Reverse ('abc') Result: CBA Deletes a specified length of character and inserts another set of characters at the specified starting pointStuff (character_expression, start, length, character_expression)Start an integer value that specifies the start position of the delete and insert.Length An integer that specifies the number of characters to delete. Select Stuff ('abcdefg'

Label: --The easiest way is to use the SSM client, report view --querying the spatial status of data files DBCCShowfilestats--Querying the space of log files DBCCsqlperf (logspace)--querying the space situation in tempdb Select * fromSys.dm_db_file_space_usage--space usage for query tables execSys_viewtablespace--use caution and have an impact on performance--DBCC Showconfig () --Log Diagnostic Methods SelectName,recovery_model_desc, Log_reuse_wait,log_reuse_wait_desc fromsys.databaseswhereNam

The LIKE keyword searches for the string, date, or time value that matches the specified pattern. The LIKE keyword uses the regular expression to include the pattern to be matched by the value. The mode contains the string to be searched. A string can contain any combination of four wildcard characters. The LIKE keyword searches for the string, date, or time value that matches the specified pattern. The LIKE keyword uses the regular expression to include the pattern to be matched by the value. T

SQL Server risks: Danger: no firewall protection, exposed to the public network.Consequence: SQL worms and hackers conduct denial-of-service attacks, cache overflow, SQL blind injection, and other attacks.Remedy: Install a firewall, even if the funds are limited, there will be a large number of free products on the In

Many friends asked me how to use the PHP program to connect the SQL Server database generic class, in fact this is not difficult, the key is a little bit careful, a little patience, with passion to understand ? Class DB { var $Host = "192.168.0.199"; Hostname of our MySQL server var $Database = "Test"; Logical database name on this

Database environment: SQL Server 2005 + 1. Replication. We often use transactional replication. Supports one-way and two-way data synchronization. Work at table level. Because it is based on transaction (the method similar to snapshot chain is used internally), the synchronization unit is small. In practice, it usually takes several minutes to get the latest data. Disadvantage: Although replication schema

One: C # connect to SQL database Datasource=myserveraddress;initial catalog=mydatabase; Userid=myusername; Password=mypassword; datasource=190.190.200.100,1433; Network library=dbmssocn;initialcatalog=mydatabase; User Id=myusername; Password=mypassword; Server=myserveraddress;database=mydatabase; Userid=myusername; Password=mypassword; Trusted_connection=false; Ser