sql server common criteria compliance

As we know, the SQL Server transaction log is used primarily to record changes made to the database by all transactions, and if the system fails, it becomes the only source of the latest data. Log operations often have the following applications: One, the transaction log file LDF lost When we do not delete or LDF file loss, the database only left MDF files, at this time directly through the additional MDF

Common Data Types in SQL Server: BinaryA fixed-length binary data with a maximum length of 8,000 bytes. VarbinaryA variable-length binary data with a maximum length of 8,000 bytes. ImageA variable-length binary data with a maximum length of 2G +-1 (2,147,483,647) bytes TextServerCodeThe maximum length of non-Unicode data in the Variable Length page is 2G +

Common Data Types in SQL server:BinaryA fixed-length binary data with a maximum length of 8,000 bytes.VarbinaryA variable-length binary data with a maximum length of 8,000 bytes.ImageA variable-length binary data with a maximum length of 2G +-1 (2,147,483,647) bytesTextThe variable length of non-Unicode data in the server code page cannot exceed 2G + (2,147,483,6

Tags: SQL Server update SELECT * Into A--automatically generate table A, and table A's structure data is the same as table BFrom BINSERT into A--a to be created in advanceSELECT * FROM B Insert into A (field 1, Field 2,...) Values (value 1, value 2,...) INSERT INTO A Values (value 1, value 2,...) Insert into A (field 1, Field 2,...) Select field A, field B,... from B Correct update: Update Ut_syhh_ C

date intervalsDECLARE @begin_dateDate= '2014-12-31',@end_dateDate= '2016-12-31'; withGeneratehelpdata as( Select 1 asID,CAST( Case when Right(@begin_date,5)='12-30' Then DATEADD( Day,1,@begin_date) ELSE @begin_date END asDATE) asEndingDateUNION All SELECTId+1 asID, Case when Right(DATEADD(QQ,1, EndingDate),5)='12-30' Then DATEADD( Day,1,DATEADD(QQ,1, EndingDate)) ELSE DATEADD(QQ,1, EndingDate)END a

If you need to manage sqlserver, you can add them to your favorites for future use. If you need to manage SQL server, you can add it to your favorites for future use. 1. view the database version Select @ version 2. view the operating system parameters of the machine where the database is located Exec master .. xp_msver 3. view database startup parameters Sp_configure 4. view the database startup time Sele

Now the main use of the building station or ASP and PHP, the two languages commonly used in the database for SQL Server and MySQL, the two databases have their own strengths, but also say who good who bad, look at personal habits. The purpose of the SQL Server Import and Export Wizard is to copy data from the source t

1. view the database version Select @ version 2. view the operating system parameters of the machine where the database is located Exec master .. xp_msver 3. view database startup parameters Sp_configure 4. view the database startup time Select convert (varchar (30), login_time, 120) from Master .. sysprocesses where spid = 1 View database server name and Instance name Print 'server name ...... + convert (v

constraint nameDEFAULT(The default Dongdong) forexample of a column name:ALTER TABLEStudbADD CONSTRAINTDf_ssexDEFAULT('male') forSsex 5. Check the constraints------you, you're the one that's stopping me from checking. (check) Effect: Stop check, pass before you can enter the table Usage:1when you build a table, add it directly behind the type.CREATE TABLEStudb (SIDCHAR( A), SnameVARCHAR( A), StunoVARCHAR( A), SsexCHAR(2), SageINT CHECK(age>= - andAge -) ) 2after the table