Shranjena procedura lastnosti strani (ADP)

Pomembno : Besedilo članka je prevedeno strojno. Glejte zavrnitev odgovornosti. Angleško različico tega članka najdete tukaj .

(Microsoft SQL Server 2000 only.) Contains options for controlling the behavior of the single-statement stored procedure you are building or modifying.

Procedure

Displays the name for the current stored procedure. If you have not yet saved the procedure, the default name is displayed. You cannot change the name in this box. To assign a name, choose Save or Save As from the File menu.

Output all columns

Specifies that all columns from all tables currently displayed will be in the procedure’s output. Choosing this option is equivalent to specifying an asterisk (*) in place of individual column names in the SQL pane.

DISTINCT values

Specifies that the query will filter out duplicates rows from the procedure’s output. This option is useful when you are using only some of the columns from a table and those columns might contain duplicate values, or when the process of joining two or more tables produces duplicate rows in the result set. Choosing this option is equivalent to inserting the word DISTINCT into the statement in the SQL pane.

Set NOCOUNT on

Prevents SQL Server from including in the query result a message indicating the number of rows affected by the Transact-SQL statement in the body of the stored procedure. To see the message, clear this check box.

GROUP BY extension

Specifies that additional options for stored procedures based on aggregate queries are available.

  • WITH CUBE

Specifies that the aggregate query should produce summary values for groups specified in the GROUP BY clause. The groups are created by cross-referencing columns included in the GROUP BY clause, and then applying the query's aggregate function to produce summary values for the additional super-aggregate rows. The WITH CUBE option is multidimensional, creating summaries from all combinations of aggregate functions and columns in the query.

  • WITH ROLLUP

Specifies that the aggregate query should produce summary values for the groups specified in the GROUP BY clause. The WITH ROLLUP option is similar to the WITH CUBE option, but creates only one type of summary for each combination of column and aggregate function.

  • ALL

Specifies that the aggregate query will include any duplicate rows in the summary.

Owner

Shows the name of the procedure’s owner. The owner name is either a SQL Server role or SQL Server user. The drop-down list contains all the users and roles defined in the database. Within the drop-down list, the users and roles have different icons; the role icon shows two faces, the user icon shows only one.

TOP

(Za SQL Server 7.0 ali višjo zbirke podatkov.) Določa, da bo shranjena procedura vključuje ZGORNJI stavek, ki vrne le prvih n vrstic ali prvi odstotek n vrstic v naboru rezultatov. Privzeto je, da postopek vrne prvih 10 vrstic v naboru rezultatov.

Use this box to specify a different number of rows to return or to specify a percentage.

  • PERCENT

(Za SQL Server 7.0 ali višjo zbirke podatkov.) Določa, da bo postopek vključuje ZGORNJI stavek, vračajo samo prvi n odstotek vrstic v naboru rezultatov.

  • WITH TIES

(For SQL Server 7.0 or higher databases.) Specifies that the procedure will include a WITH TIES clause. WITH TIES is useful if a procedure includes an ORDER BY clause and a TOP clause based on percentage. If this option is set, and if the percentage cutoff falls in the middle of a set of rows with identical values in the ORDER BY clause, the view is extended to include all such rows.

SQL Comment

To enter text in this field, you can type directly into it, or you can enter a comment in the SQL pane. When you enter text directly into this field, you simply type the text. But when you enter comment text in the SQL pane, you must use the comment delimiter characters. For example:

/* This is comment text entered in the SQL pane */
This is comment text entered directly in the SQL Comment field.

Opis

(SQL Server 2000 only.)

This field is distinguished from the SQL Comment field in two ways. First, values of Description are stored in SQL Server as extended properties. Second, you cannot enter values of the Description from the SQL pane.

Opomba : Strojni prevod – zavrnitev odgovornosti: Ta članek je bil preveden z računalniškim programom brez človeškega posredovanja. Microsoft skuša s strojno prevedenimi članki vsebino o Microsoftovih izdelkih, storitvah in tehnologijah približati osebam, ki ne razumejo angleščine. Ker je bil članek strojno preveden, so lahko v njem jezikovne, slovnične in pravopisne napake.

Razširite svoja znanja
Oglejte si izobraževanje
Prvi dobite nove funkcije
Pridružite se programu Office Insider

Vam je bila informacija v pomoč?

Zahvaljujemo se vam za povratne informacije.

Zahvaljujemo se vam za povratne informacije. Videti je, da bi vam prišla prav pomoč enega od naših Officeovih agentov za podporo.

×