Quick reference to sp_??

Hi:
Does anyone know of a quick reference guide to MSSQL stored procedures
(sp_?) where there is a 'one line' description of what the procedure
actually does?
I have seen the complete reference in the online books, but want a
quick-and-dirty guide.
TIA,
Martin.
Hi,
Procedure:-
A set of precompiled TSQL commands stored under a single name and processed
as a unit.
See the below link for the informations and egs: for stored procedures.
http://www.awprofessional.com/articl...le.asp?p=25288
Thanks
Hari
MCDBA
"Martin Hart - Memory Soft, S.L." <memorysoftsl _at_ infotelecom _dot_ es>
wrote in message news:#uKvxNgeEHA.3520@.TK2MSFTNGP10.phx.gbl...
> Hi:
> Does anyone know of a quick reference guide to MSSQL stored procedures
> (sp_?) where there is a 'one line' description of what the procedure
> actually does?
> I have seen the complete reference in the online books, but want a
> quick-and-dirty guide.
> TIA,
> Martin.
>
|||Hmm, I believe we've just witnessed the effects of a rift in the spoken
language continuum. When such rifts are visible, it's possible for
unsuspecting questions to get sucked into a sort of linguistics black hole,
and I fear that is exactly what has happened here.
There are those who believe that if we were able to travel faster than the
speed of light, we could navigate these rifts to our advantage, and thereby
gain access to The Supreme Knowledge Of All Ages... not that I'm one of
them, of course, it's just something I overheard while killing time at a
sleazy dive bar, in a back-water space port about half a light-year and
change from... or wait, did I dream it? :-) No matter...
I gather from your question that you already know what a stored procedure
is, in generic terms. What you're looking for instead is a quick reference
that covers the *system* stored procedures that ship with SQL Server, right?
I agree this level of reference would be useful, at one point I was trying
to generate one from info_schema. Got it to the point that I needed a
scripting environment or cursors on steroids to make it look like I wanted.
I was hoping to extract a one-line mission statement from a good percentage
of them by loosely parsing the sources for comments -- god forbid they
follow any sort of prevalent convention. In the end I found myself wishing
that all the replication-specific SPs could be easily isolated/filtered from
view, as I found myself not caring quite so much if they were represented in
my little reference...
Then I decided just the names and order of the parameters for each would be
nominally useful. Then I decided to cut my losses and work on things that
made me money
Sadly, after all that, I'm not aware of any such reference. A book by
Kalen Delaney has a chapter that somewhat approaches it, but packing around
1000 pages of paper defeats the premise of a quick ref.
Author Kalen Delaney Based on the first edition by Ron Soukup
Pages 1088
Disk 2 Companion CD(s)
Level Intermediate
Published 11/15/2000
ISBN 0-7356-0998-5
Sorry I don't have anything more worthwhile for you.. but at least I got
your question. :-)
-Mark
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uiIW5BheEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Procedure:-
> A set of precompiled TSQL commands stored under a single name and
processed
> as a unit.
>
> See the below link for the informations and egs: for stored procedures.
> http://www.awprofessional.com/articl...le.asp?p=25288
> Thanks
> Hari
> MCDBA
>
> "Martin Hart - Memory Soft, S.L." <memorysoftsl _at_ infotelecom _dot_ es>
> wrote in message news:#uKvxNgeEHA.3520@.TK2MSFTNGP10.phx.gbl...
>
begin 666 1pxt.gif
L1TE&.#EA`0`!`( ``/___P```"'Y! $`````+ `````!``$`0 ("A%$`.P``
`
end
|||Hi Mark:
"Mark J. McGinty" <mmcginty@.spamfromyou.com> escribi en el mensaje
news:uSRVpoqeEHA.2812@.tk2msftngp13.phx.gbl...
[snip]
> Hmm, I believe we've just witnessed the effects of a rift in the spoken
> language continuum.

> I gather from your question that you already know what a stored procedure
> is, in generic terms. What you're looking for instead is a quick
reference
> that covers the *system* stored procedures that ship with SQL Server,
right?
[snip]
Yes, you are correct. I know what they are and how to use them, I just want
to have a list (which I can extract from the meta data) and a quick
description of what the procedure does, and maybe a brief rsum of the
parameters.
Indeed language is a strange medium and not easily interpreted. In
programming terms I'm looking for the XML documentation equivalent provided
in the .NET environment to document methods and properties!!
Thanks,
Martin.
|||Martin,

> Does anyone know of a quick reference guide to MSSQL stored
> procedures (sp_?) where there is a 'one line' description of
> what the procedure actually does?
> I have seen the complete reference in the online books, but want a
> quick-and-dirty guide.
The closest thing to quick reference would be this page from Books
Online that lists the documented stored procedures grouped by
category.
http://msdn.microsoft.com/library/de...sp_00_519s.asp
Linda

Quick and Easy SQL Question . . .

I don't have much experience with writing Sql, which is why i'm not sure.

But basically, I have a MSSQL 2005 Database that a person can list a property with,

and if the property listing expires by date, the user can relist the listing.

The records on the search function are automatically sorted by date, and I want the relisted records to update the datecreated.

I added "DateCreated" to the relisting storedprocedure to change DateCreated to todays date, but I am guessing.

Specials = @.Specials,

ExpirationDate = @.ExpirationDate ,

DateCreated =GetDate(),

DateApproved = @.DateApproved,

This seems to work, but I just wanted to check to make sure it's in the proper format.

Thank you

Daniel Meis

darkknight187:

DateCreated =GetDate()

That is the right way to do it.

|||

Thank you for your reply, just wanted to be sure.

Quick and easy question, Sql update method . . .

I am new to Sql, so I think this is a really easy question.

But I am working on a 2005 MSSQL database.

When I add columns to an existing application with data and tables already being used, and the new column will be set to Database Null.

What is an easy way to quickly add the data to all the rows in the table.

For example if I am adding a checkbox, I've been doing it manually, add the column, change all the rows to False, one by one.

And then I can change it to Disallow DBNull.

As I get more and more users this could be a very time consuming process.

So the name of the Table is classifeds_Ads and let's say the column I want to add is Bonus and it needs to be filled with False.

How do I do this?

Thank you in advance

Daniel Meis

You can create a new query and then just run this:

UPDATE classifieds_Ads Set Bonus = 0

Or an easier approach is to use the Column Properties pane to set the initial properties for the column - Allow Nulls: No, Default Value or Binding: 0

|||

Works great, Thank you.