sql server common criteria compliance

TimeS: can go directly or select cast (' 2004-09-08 ' as datetime) valueO:select to_date (' 2004-01-05 22:09:38 ', ' yyyy-mm-dd hh24-mi-ss ') Vaule from DUAL;43. Find the difference between a part of two dates (e.g. seconds)S:select DateDiff (Ss,getdate (), GETDATE () +12.3) valueO: Subtract directly from two dates (e.g. d1-d2=12.3)SELECT (D1-D2) *24*60*60 vaule from DUAL;44. Date of novelty based on difference (e.g. minutes)S:select DateAdd (Mi,8,getdate ()) valueO:select sysdate+8/60/24 vaule

, containing the number of rows in the table, not including the number of data entries in the index From Sys.dm_db_partition_stats P INNER JOIN sys.objects o On p.object_id = o.object_id where p.object_id= object_id (' Table name ') GROUP BY O.name --by page or district statistics, have performance impact, accurate --Displays space information for the data and indexes of all tables or views in the current database --Include: logical fragmentation, zone fragmentation (fragmentatio

, but to understand that there is no substitute for whereSelect age,count (*) as from the person group by age have age>15---Group statistics according to age, and select groups older than 15--Removing duplicate dataSelect from person--federated result set (combining query results into 1 query results) Note: The top and bottom two query statement fields must be consistent (name, type, number must be the same)Select from personunion Select from StudentNote: The difference between Union and unio

There are two types of SQL Server authentication, one is Windows authentication, and the other is SQL Server authenticationWindows Authentication Connection string:string connectionString = "data source=localhost;database= database name; Integrated security=true ; User Instance=false; ";Integrated securi

') --Return 10 Datepart (): returns the integer of the part of the specified date for the specified date. The Datepart () method works similarly to Datename (), except that the Datename () method returns a string, and the Datepart () method returns an integer value. The method has two parameters: Parameter 1: Specifies a string that returns the specified part of the specified date. Can be a date part or an abbreviation in. Parameter 2: Specifies the date string to manipulate. Select DATEPA

(50), -- password@ Email nvarchar (200) -- email address)AsDeclare @ userID int -- User ID-- The Logon account has been registeredIf exists (select loginID from tableName where loginID = @ loginID)BeginReturn-1;End-- The email address has been registered.Else if exists (select email from tableName where email = @ email)BeginReturn-2;End-- Registration successfulElseBeginSelect @ userID = isnull (max (userID), 100000) + 1 from tableNameInsert into tableName(UserID, loginID, [password], userName,

) ODBC specification (with milliseconds) Yyyy-mm-dd hh:mi:ss.mmm (24h) 126 (4) ISO8601 Yyyy-mm-ddthh:mi:ss.mmm (no spaces) 127 (6, 7) The ISO8601 with time zone Z. Yyyy-mm-ddthh:mi:ss.mmmz (no spaces) 130 (+) Hijri (5) DD Mon yyyy hh:mi:ss:mmmAM 131 (2) Hijri (5) Dd/mm/yy Hh:mi:ss:mmmAM Select CONVERT (varchar), GETDATE (), 8): 10:57:46Select CONVERT (varchar

_ table_name ', 'new _ table_name'-Modify the data table nameEXEC sp_rename 'table _ name. [old_column_name] ', 'new _ column_name', 'column '-Modify the field name4. Get the Stored Procedure content by specifying the stored procedure nameCopy codeThe Code is as follows:Exec sp_helptext sp_nameThe following is about Database Control* The following are security-controlled system stored procedures or SQL statements. For more information about the synta

database entity that you want to fix DECLARE @dbname varchar (255) Set @dbname = ' Name of the database entity that needs to be repaired ' exec sp_dboption @dbname, ' Single user ', ' true ' DBCC CHECKTABLE (' name of the data table to be repaired ', repair_allow_data_loss) DBCC CHECKTABLE (' name of the data table to be repaired ', repair_rebuild) ------Change the name of the ' data table to be repaired ' to the name of the data table that executes the DBCC CHECKDB times error exec sp_d

ELSEStatement_end_offsetEND -Statement_start_offset)/ 2) fromSys.dm_exec_sql_text (sql_handle)) asQuery_text--, Plan_handle,db_name(qp.dbid), Qp.query_plan fromsys.dm_exec_query_stats Crossapply Sys.dm_exec_query_plan (plan_handle) QPORDER by(total_logical_reads+Total_logical_writes)/Execution_countDESC--indexes that have not been usedSELECTO.nameobject_name --Table name, I.name index_name--Index name, I.type_desc--whether the clustered index, S.user

A stored procedure in Transact-SQL, very similar to a method in the Java language, can be called repeatedly. After the stored procedure executes once, the statement can be cached so that the statements in the cache are used directly at the next execution. This can improve the performance of your stored procedures.? The concept of stored proceduresStored procedure procedure is a set of SQL statements that ar