Solved

SQL2008 Time datatype - 00:00:00 throws syntax error

Posted on 2013-01-29
2
298 Views
Last Modified: 2013-01-29
Hi Experts,

Bit baffled, I'm testing a stored procedure on SQL2008 which is a very simple insert, one of the datacolumns is set to Time so I am entering a value in the format 00:00:00 - but I get a syntax error on the first colon...am I missing something here?!
0
Comment
Question by:forsters
2 Comments
 
LVL 1

Accepted Solution

by:
DoutorApedeuta earned 500 total points
ID: 38830590
Didn,t you forget the quote characters? '00:00:00'
Is the data type of the table you are inserting into the same as the SP parameter?
0
 

Author Comment

by:forsters
ID: 38830607
Hi,
Apologies, you're right - would help if I read the reply properly!

I didn't realise Time had to be in quotes.

Many thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question