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 |
|
trento
Starting Member
13 Posts |
 Posted - 2009-09-02 : 13:29:49
|
| Hi,I need you help, I have sql that I have to transport to some third party dba group to create sp, I just want to prepare before shipping my sql to them, what min set of requirements I need to creat sp?does it alwayse need to be <CREATE PROCEDURE AS...> or actual code could be imported from other DB?Let say I have valid SELECT.... and I have teamDB database name, is it enough to create SP?TxTrent |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-02 : 13:31:51
|
| you want to transport query as a procedure? |
 |
|
|
trento
Starting Member
13 Posts |
Posted - 2009-09-02 : 14:12:30
|
| I'm complete dummy about sp, I have select and I need (or dba need to create) sp on specific db.So probably it sounds like transport query.Tx |
|
|
|
eralper
Yak Posting Veteran
66 Posts |
Posted - 2009-09-02 : 14:13:55
|
| You can pass parameters to stored procedures.If you have where conditions within you select statements, you can pass those where clause criterias as sp parameter and within the sp code place the params as the accurate column conditionsSo you might need to identify the where clause parameters and parameter types.-------------Eralperhttp://www.kodyaz.com |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
|
|
|
|
|
Create SP from select