Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-05 : 09:41:13
|
| milind writes "i'm executing stored procedure spu_generate_event from my machine query analyser. gives me this error Server: Msg 8114, Level 16, State 1, Procedure spu_generate_event, Line 0Error converting data type nvarchar to datetime.sql server is on a seperate machine . column timeraised is datetime type . looks so simple but not able to find the answer. please help . my stored procedure == CREATE PROCEDURE spu_generate_event @eventtype int , @eventtime datetime , @audiable char(1) , @raisedby varchar(40), @desc varchar(800) AS INSERT INTO tblCurrentEvents (EventType, TimeRaised, Audible, RaiseUserId, [Description]) VALUES ( @eventtype, getdate() , @audiable , @raisedby , @desc )GO===== this is what i execute from query analyser =========>exec spu_generate_event 1, getdate,'N','System','Trend data could not be generated'" |
|
|
|
|
|
|
|
Error converting data type nvarchar to datetime ??