English 中文(简体)
服务器:由GETDATE(GETD)标明
原标题:SQL Server: intrigued by GETDATE()
最佳回答
问题回答

<>GetDate(>从来不是决定性的。 决定性意味着,在通过相同的参数时,它总是会恢复同样的结果。

同<代码>rand( 评价一次是per栏,但经过评价后,所有各行各行各有相同之处。

比较容易地以<代码>rand(>>查询。

select top 4 rand(), rand()
from sys.objects

回返

---------------------- ----------------------
0.0566172633850772     0.431111195699363
0.0566172633850772     0.431111195699363
0.0566172633850772     0.431111195699363
0.0566172633850772     0.431111195699363

如果你尝试:

select top 10 getdate(), getdate()
from sys.objects

在实际执行计划中,将研究商法操作员的特性。

NB:在2000年之后,每栏而不是每盘点的这种评价行为可能发生改变(我不知道),但这正是BAOL的定义是决定性的意思。





相关问题
How to write this T-SQL WHERE condition?

I ve got two tables: TableA Col1 Col2 TableB Col3 Col4 I want to join them together: SELECT * from TableA join TableB ON (...) Now, in place of ... I need to write an expression ...

Customer and Order Sql Statement

TSQL query to select all records from Customer that has an Order and also select all records from customer that does not have an Order. The table Customer contains a primary key of CustomerID. The ...

Recommended way of querying multiple Versioned tables

Have a win 2003 box with MSSQL 2005 running on it. There is a database which is populated every morning with new/modified SalesOrder made the previous day. The database has several tables: SalesOrder, ...

update duplicate record

I have a table with the following fields Id Name IsPublic i need to write a sql query that updates IsPublic to false where name has a duplicate. Only one of the duplicates should have IsPublic = ...

Define variable to use with IN operator (T-SQL)

I have a Transact-SQL query that uses the IN operator. Something like this: select * from myTable where myColumn in (1,2,3,4) Is there a way to define a variable to hold the entire list "(1,2,3,4)"? ...

Selecting records during recursive stored procedure

I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...

热门标签