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 - 2000-09-16 : 20:40:44
|
bilal writes "When I want to create a procedure like this
Create Procedure [MyFriends](
@Name varchar(50) = null,
@Age tinyint = null,
@InterviewTime datetime = current_timestamp
)
the error is close to the word 'current_timestamp'
i have tried to use getdate() in the same syntax
but didn't help.
what's wrong?
all i want is that the @InterviewTime should be
an optional parameter, which if omitted should
have the current system time.
can you help???"
|
|
|
|
|
|
SQL Stored Procedures -> Parameters -> Default Values