When a Function is indeed a Constant

Andrew Kelly : When GETDATE() is not a constant

Andrew Kelly : When GETDATE() is not a constant — Sat, 01 Mar 2008 16:25:40 GMT

PingBack from http://sqlblog.com/blogs/andrew_kelly/archive/2008/02/27/when-getdate-is-not-a-constant.aspx

re: When a Function is indeed a Constant

EdVassie — Mon, 03 Mar 2008 09:39:27 GMT

I found that Getdate() returned multiple values in a INSERT .. SELECT statement for a number of fix levels in SQL Server 2000. As I needed a consistant time on all rows that were inserted, I just did SET @var = Getdate() before the INSERT, and used @var to provide the required time in the main query.

re: When a Function is indeed a Constant

jerryhung — Mon, 03 Mar 2008 20:28:58 GMT

I never thought about this issue until your last blog post

Luckily, my recent insert of 300,000+ records all share the exact same getdate() value, EVERY TIME (RevisionDate = getdate() inside a transaction)

However, I have changed my insert code to use a variable instead, to make sure I don't get surprises.

re: When a Function is indeed a Constant

Seraph2047@hotmail.com — Mon, 24 Mar 2008 07:35:15 GMT

How To Use MYSQL's "limit" function in Microsoft Sql server?

for expmple:

a database have 1,000,000 record,

I want to read record at order 1000 - 1100.

in MySQL:

"Select * from Table1 limit 1000,100" ;

I serach some blog and technic webpage how to read at mssql,

in MsSQL:

"Select * from (Select top 1100 * form Table1 order by DESC) as T1 order by ASC"

Bnt this expression is too slowly!!! Question: how to optimize? thanks.

re: When a Function is indeed a Constant

JRStern — Thu, 29 Apr 2010 01:31:30 GMT

Yup. Just ran into the non-consistent getdate() today my own self, on a (now) retro version of SQL 2005 32-bit:

Microsoft SQL Server 2005 - 9.00.3282.00 (Intel X86)

Aug 5 2008 01:01:05

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Thanks for confirminng I'm not crazy - or at least keeping me company!

Compute Scalars, Expressions and Execution Plan Performance

Paul White: Page Free Space — Tue, 04 Sep 2012 22:22:29 GMT

The humble Compute Scalar is one of the least well-understood of the execution plan operators, and usually