| Thread | Last Post | Replies |
|
| Getdate()+ so many hours | 26 Jun 2008 15:55 GMT | 3 |
Hopefully this will be an easy one for someone. I am using SQL Server 2005. I am based in the UK and our users are in the UK. We have recently changed hosting providers and their server is located in the USA. Our database has a default value of getdate() when a record is added ...
|
| Error converting data type nvarchar to datetime | 11 Jun 2008 19:01 GMT | 1 |
Good morning :) * Using QL Server 2005 I have created a stored procedure (first time I have done this). It worked fine when I only had 1 variable (the ProjectCode variable).
|
| update querie multiple tables | 10 Jun 2008 21:12 GMT | 1 |
Hi I wish to create a stored procedure that updates multiple tables. I have a table called User CREATE TABLE [dbo].[Users]( [UserId] [int] NULL,
|
| COUNT command rejected in SQL Query | 04 Jun 2008 03:03 GMT | 1 |
My C# Windows program does not recognize the COUNT command in a SQL query string using SQL Server 2005. I can use the command when I code the query manually against the data base. It rejects the command SELECT COUNT(*) FROM EARNDED. Does anyone know how to get around this ...
|