We migrated recently from a database that had a DATE type (4 byte) and and TIME type (also 4 byte). We got hooked on this since so many of our queries were simple...
SELECT * FROM tblTable ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20107994.html
I have the following WHERE:
WHERE liabhist.logtime = '4/23/02'
liabhist.logtime is a SMALLDATETIME and the WHERE does not work. How do code the where so it will pick up all records fr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20295834.html
Dynamic SQL Statement not working - strange problem because if I PRINT the dynamic SQL and run it Query Analyser (or another sp) it works fine.
Please help, should be extremely easy for an experie...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20796487.html
Zones:
DatabasesDate Answered: 11/16/2003 Grade: A Views: 0
Here is my stored procedure:
CREATE PROCEDURE summary
@startdate varchar(20),
@enddate varchar(20)
AS
select * from SanderGroup
where Entrydate between CONVERT(varchar, CONVERT(smalld...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20821510.html
teams table
CREATE TABLE [dbo].[Databaseteams] (
[DIV] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[id] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TeamNam...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21212427.htm...
Zones:
ASPDate Answered: 11/19/2004 Grade: A Views: 0
I'm haveing a problem updateing the smalldatetime column in SQL server 2000.
i'm using C# asp.net
The command string looks like
string UpdateString= "INSERT INTO RISK_SCR (DateSCR, IMP, PROB) ...
http://www.experts-exchange.com/Programming/Misc/Q_21214676.html
Zones:
ProgrammingDate Answered: 11/20/2004 Grade: A Views: 214
Hi, this is a rehash of an old propblem, I have a problem with the query below
@surname varchar(150), @enddate smalldatetime
AS
SELECT job.jobid, job.estimate, job.location1 + job.location...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21388393.html
hello,
I have a smalldatetime field and I would like to use CONVERT to convert it to time
please help
thanks
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21607516.html
I'm currently working on my company's intranet site that I recently took over from a developer that left us, the problem is that, he uses stored procedures in Microsoft SQL 7.0 to do his updates, t...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21629984.htm...
Zones:
ASPDate Answered: 11/29/2005 Grade: A Views: 8
I have a database which contains a field of type SMALLDATETIME. This field is filled with various dates. I need to subtract one day from each date. I thought I should be able to do something lik...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21645649.html
