On Mon, 15 May 2006 07:58:02 -0700, DavidBsaibes wrote:
i am trying to write a query in sql server 2000 that returns the list of days
between two dates.
it should return something similar to
for i = 1 to 100
select getdate() + i
next i
Re: How accurate is GetDate() ? ...Hugo Kornelis wrote: ...Getdate() is ... it is as accurate as the system clock of the server - if an admin ... David Portas, SQL Server MVP... (comp.databases.ms-sqlserver)
Re: Index View ... I also have Ent.... Indexed views are supported by SQL Server 2000. ... can't use this for your query....GETDATE()" prohibits this view from being indexed. ... (microsoft.public.sqlserver.programming)
Re: How to initialice a default value for a column in a typed DataSet ... my approach has always been to create a DEFAULT in SQL Server and bind ... The DEFAULT can be an expression like GETDATE().... > save (the client app sees a "nothing" while the database has a datetime). ... >> I have a typed dataset that corresponds to a SQL Server database model. ... (microsoft.public.dotnet.framework.adonet)
Re: getdate() in UDF ... > But the same problem would exist if getdate() was replaced by an input ... that is data in the database and input parameters. ... Here noofyears is a computed column which tells us how long a person ...SQL Server must materialize the values. ... (microsoft.public.sqlserver.programming)
Re: Index View ... >>performance problem.... I also have Ent.... > GETDATE()" prohibits this view from being indexed. ... what indexes get used by SQL Server?... (microsoft.public.sqlserver.programming)
