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 |
|
Danny4003
Starting Member
40 Posts |
 Posted - 2006-10-27 : 15:22:10
|
| What is Possible for Stored Procedure? meaning can you put anything inside a stored procedure or is there a limit. Plz bear with me just a questionDanny D |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-27 : 15:35:29
|
Take a look at the help for CREATE PROCEDURE in Books Online, in particular note quote:
sql_statement LimitationsAny SET statement can be specified inside a stored procedure except SET SHOWPLAN_TEXT and SET SHOWPLAN_ALL, which must be the only statements in the batch. The SET option chosen remains in effect during the execution of the stored procedure and then reverts to its former setting. Inside a stored procedure, object names used with certain statements must be qualified with the name of the object owner if other users are to use the stored procedure. The statements are: ALTER TABLECREATE INDEXCREATE TABLEAll DBCC statementsDROP TABLEDROP INDEXTRUNCATE TABLEUPDATE STATISTICS
|
 |
|
|
Danny4003
Starting Member
40 Posts |
Posted - 2006-10-27 : 16:12:14
|
| CAN I Put an Insert or a Join inside a Stored Procedure? |
|
|
|
sql_noob
Starting Member
9 Posts |
Posted - 2006-10-27 : 16:46:02
|
| yes |
|
|
|
|
|
|
Join inside Stored Procedure