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 - 2006-05-23 : 08:57:33
|
| ARUN writes "1.Can we pass table type parameter in stored procedure?2.We create procedure (suppose in DB1 database). Does sql server first check this procedure in Master database ?I want to know the logic to execute procedure (actual process)?????" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-05-23 : 08:59:30
|
| 1. No, table variables cannot be passed, but you can create a temp table that the procedure can access.2. SQL Server checks for objects in the current database unless you specify the database in a 3-part name (exec mydb.dbo.myproc). The ONLY exception are stored procedures beginning with "sp_", these are a special case and are only resolved to the master database. Do not prefix your procedures with sp_ if they are not in master, they will not execute. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-23 : 09:00:21
|
| 1 No. 2 Yes if sp name starts with sp_MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
My Question