Tài liệu Using Functions phần 1 pptx

... mathematical functions. You use the ABS() function to get the absolute value. The following example returns 10 and 15 : SELECT ABS( -10 ), ABS (15 ); You use the ACOS(), ASIN(), and ATAN() functions ... truncates the number. SIGN(expression) Returns 1, 0, or -1 depending on the sign of expression. Returns 1 for a positive number, 0 for zero, or -1 for a negative number. SIN(...

Ngày tải lên: 14/12/2013, 13:15

... system date as UTC time. The following example returns 2002-07 -16 20:02 :18 .12 3: SELECT GETUTCDATE(); Using System Functions The system functions allow you to manipulate and obtain information about ... returns 16 .0: SELECT SQUARE(4); You use the SQRT() function to get the square root of a number. The following example returns 4.0: SELECT SQRT (16 ); Using String Functio...

Ngày tải lên: 14/12/2013, 13:15

... 10 : SELECT ProductID, ProductName, QuantityPerUnit, UnitPrice FROM Products WHERE ProductID = 10 ; The equal operator (=) is not the only operator you can use in a WHERE clause. Table 3 .1 ... you've connected to SQL Server using Query Analyzer, you can use the Object Browser to view the parts of a database, and you enter and run SQL statements using a Query window. Figure...

Ngày tải lên: 14/12/2013, 13:15

... Offline Files tab, and set the Encrypt offline files to secure data checkbox (Fig. 13 .11 ). Figure 13 .11 : Options for encrypting the Offline Files database Note Administrative privileges ... Configuration | Administrative Templates | System | System Restore (Fig. 13 .10 ). Figure 13 .10 : Configuring System Restore using Group Policy Editor 3. Double-click Turn off Syst...

Ngày tải lên: 14/12/2013, 10:15

... Figure 1- 18. Click the triangle again to collapse the folder listing. You're saved the trouble and clutter of opening a new window just to view the folder's contents. Figure 1- 17. You ... for the different columns of information Mac OS X can show you, as illustrated in Figure 1- 19 . Figure 1- 18. Click a "flippy triangle" (left) to see the list of the folders an...

Ngày tải lên: 14/12/2013, 10:15

... ReorderLevel <= 20; Figure 3 .11 shows the results of this SELECT statement. Figure 3 .11 : Using the AND operator to retrieve products where UnitsInStock is less than 10 and ReorderLevel is less ... retrieve products with a ProductID between 1 and 12 : SELECT ProductID, ProductName, QuantityPerUnit, UnitPrice FROM Products WHERE ProductID BETWEEN 1 AND 12 ; Here's...

Ngày tải lên: 14/12/2013, 13:15

... shows this: SELECT UnitPrice * 1. 20 FROM Products WHERE ProductID = 1; This example returns 21. 600000. The new unit price is calculated using UnitPrice * 1. 20. This is an increase of 20 ... SupplierID; Figure 3 .18 shows the results of this SELECT statement. Figure 3 .18 : Using the GROUP BY clause to divide rows into blocks You'll learn more about the various SQL Se...

Ngày tải lên: 14/12/2013, 13:15

... 'Jason Price', 'Owner', &apos ;1 Main Street', 'New York', NULL, &apos ;12 345', 'USA', '(800)-555 -12 12', NULL ); If you attempt to run ... two new rows. Figure 3.25: Using a transaction The next transaction consists of similar INSERT statements, except this time the transaction is rolled back using a ROLLBACK stat...

Ngày tải lên: 14/12/2013, 13:15

... 13 .8).  Xem xét và xử lý chứng cứ của assembly (mục 13 .9 và 13 .10 ).  Xử lý bảo mật bộ thực thi bằng miền ứng dụng (mục 13 .11 và 13 .12 ). RBS cho phép bạn thực hiện các quyết định lúc thực ... mã lệnh của bạn (mục 13 .4, 13 .5, 13 .6, và 13 .7).                                                                 Kiểm soát sự thừa kế và chép đè thành viên bằng CAS (mục 13...

Ngày tải lên: 23/12/2013, 19:15

... different control over computers or users. Table 11 .1 summarizes the most common per-computer and per-user nodes available in GPOs. Table 11 .1: Available Functionality Nodes in Group Policy ... corresponding to Group Policy Objects existing within your domain (Fig. 11 .8 ). Figure 11 .8: Viewing Group Policy Containers using the Active Directory Users and Computers MMC snap...

Ngày tải lên: 14/12/2013, 10:15