difference

hello!
sorry, i don´t speak english.
hello again!
It what differs it is between these two sentence?
- exec (' exec sp_MShelpindexPru cliente,'+''+@.indexid+''+'output')
-exec sp_MShelpindexPru cliente,@.indexid output
Supposedly, they are equal , no?
None gives me mistake, but The first one does not give me a result And
the second one gives me the correct result. Which is the difference
between both?
I need to do it of the second form, because I need to insert one it
use @.dbname initially.
Thank you very much, and excuses me for my English. :-(Look into using sp_execute_sql instead. See if this helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;262499
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
<mani14@.begira.com> wrote in message
news:ca48b635.0308190221.9b9a596@.posting.google.com...
hello!
sorry, i don´t speak english.
hello again!
It what differs it is between these two sentence?
- exec (' exec sp_MShelpindexPru cliente,'+''+@.indexid+''+'output')
-exec sp_MShelpindexPru cliente,@.indexid output
Supposedly, they are equal , no?
None gives me mistake, but The first one does not give me a result And
the second one gives me the correct result. Which is the difference
between both?
I need to do it of the second form, because I need to insert one it
use @.dbname initially.
Thank you very much, and excuses me for my English. :-(|||Hello Mani !
But remeber that for SP_executesql the @.string followed to be executed must
be NVARCHAR !
Jens Süßmeyer.

Development Procedures

Hello,

Recently my partner in crime (so to speak) and I have been asked to develop procedures and/or methods for our software development group. Currently we're running SQL Server 8 with several Access apps and Crystal Reports. In a nutshell, I'm looking for resources.

We're supposed to develop a process (we're both DBA's) where our development team can formally submit new stored procedures, views, or whatever they've come up with to solve for buisiness requirements. It'll be our job to take thier scripts and execute them on the production database after ensuring someone has tested the logic and signed-off on it.

Unfortunately, I have been charged with developing this process (ie: development, sign-off, testing, etc..). Currently we have no procedures in place; until now my partner and I have been the primary deveopers (this is about to change). Are there any resources out there that could help me develop a formal process for our soon-comming developers?

Thanks,

Jason

Jason -

You can check out InformIT.com - they have lots of information there on a "professional" nature, not just technical info. I do the SQL Server "Guide", and I've got an article or two that might be useful.

Most of the Software Development articles will point towards a particular methodology or tool. I've found that most shops develop their own methods and call it an "SDLC" or Software Development Life Cycle. Also check out a book called "Code Complete".

Buck

Development Procedures

Hello,

Recently my partner in crime (so to speak) and I have been asked to develop procedures and/or methods for our software development group. Currently we're running SQL Server 8 with several Access apps and Crystal Reports. In a nutshell, I'm looking for resources.

We're supposed to develop a process (we're both DBA's) where our development team can formally submit new stored procedures, views, or whatever they've come up with to solve for buisiness requirements. It'll be our job to take thier scripts and execute them on the production database after ensuring someone has tested the logic and signed-off on it.

Unfortunately, I have been charged with developing this process (ie: development, sign-off, testing, etc..). Currently we have no procedures in place; until now my partner and I have been the primary deveopers (this is about to change). Are there any resources out there that could help me develop a formal process for our soon-comming developers?

Thanks,

Jason

Jason -

You can check out InformIT.com - they have lots of information there on a "professional" nature, not just technical info. I do the SQL Server "Guide", and I've got an article or two that might be useful.

Most of the Software Development articles will point towards a particular methodology or tool. I've found that most shops develop their own methods and call it an "SDLC" or Software Development Life Cycle. Also check out a book called "Code Complete".

Buck