Question about Microsoft SQL Server 2000 Standard Edition for PC

**How to Update the rows which are divisible by 10, given a set of numbers in column****If we have multiple AFTER Triggers on table how can we define the sequence of the triggers**

Re: I need solution for those questions

Here are the answers:

1. Use the MOD operator

DECLARE @i AS INT; SET @i = 0

WHILE true BEGIN

SET @i = @i + 1

IF @i % 10 BEGIN -- This is the MOD operator

UPDATE table SET Fields FROM table WHERE clause

END

END

% This is the MOD operator to find the remainder, which when @i is divisible by 10, the remainder (MODULAS) is 0.

2. You can't. Only the first and last can be defined. Any other AFTER triggers besides the first and last will fire in undetermined order.

Please rate FixYa! ThankYa! Happy db'ing.

Posted on Dec 15, 2007

I am assuming you are using Office version 2003 or newer.

Towards the left border of the sheet there are row numbers; Left click on any number selects the entire row.

Once selected, right click on the row number or anywhere on the selected row and delete from the menu.

To select multiple rows:

1. Hold down the left mouse button and drag till you reach the desired end row. (row selection to be done by clicking on row numbers and not the actual rows)

2. Select a cell (left click), then the combination ctrl+shift+rightArrow. This will select the entire row (only if it is empty). Now use shift+downArrow to select one row at a time or ctrl+shift+downArrow to select all adjacent blank/non-blank rows.

If row number are not visible:

In Office 2007 goto "View" tab. Select "Headings" from the "Show/Hide" group. In other Office versions, use the menu navigation to reach this point.

Towards the left border of the sheet there are row numbers; Left click on any number selects the entire row.

Once selected, right click on the row number or anywhere on the selected row and delete from the menu.

To select multiple rows:

1. Hold down the left mouse button and drag till you reach the desired end row. (row selection to be done by clicking on row numbers and not the actual rows)

2. Select a cell (left click), then the combination ctrl+shift+rightArrow. This will select the entire row (only if it is empty). Now use shift+downArrow to select one row at a time or ctrl+shift+downArrow to select all adjacent blank/non-blank rows.

If row number are not visible:

In Office 2007 goto "View" tab. Select "Headings" from the "Show/Hide" group. In other Office versions, use the menu navigation to reach this point.

Jul 11, 2014 | Microsoft Office Business & Productivity...

Microsoft Excel 2010 can freeze, or lock, a top row as you scroll down the worksheet.

For example, you may need to keep the top row of column titles visible at all times.

The "View" tab on the command ribbon contains the "Freeze Panes" button in the "Window" group.

A single row or a range of rows can lock through the "Freeze Top Row" or "Freeze Panes" options.

Open the Excel worksheet.

Click the top row heading.

The row heading displays a number just left of the first column of cells. The selected row appears shaded.

Click the "View" tab on the command ribbon.

Click the "Freeze Panes" button in the "Window" group.

A list of options appears.

Click the "Freeze Top Row" option.

A black horizontal line appears on the worksheet.

This line indicates the locked row that stays on the screen as you scroll down the worksheet.

http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx?CTT=1

Freeze or lock rows and columns

also

Scrolling down to look at a number and then scrolling up to make sure the number you looked at is under the header you expected is not an efficient way to view a spreadsheet.

The Freeze Panes feature of Excel allows you to freeze the labels of your data in place while you review the data.

Follow the instructions in Section 1 to freeze the top row or the left column.

Freeze multiple rows, multiple columns, or rows and columns, by following the instructions in Section 2.

1

Open the Excel spreadsheet.

2

Navigate to the "View" tab on the top menu.

3 Click on "View," then click on "Freeze Panes." A drop-down menu opens.

4

Select the "Freeze Top Row" option to freeze the top row.

5

Select the "Freeze Left Column" or "Freeze First Column" option to freeze the left column.

6

Freeze the top row by using the keyboard and sequentially pressing the keys "ALT, W, F, R." Ignore Steps 3 through 7 if using this choice.

7

Freeze the left column using the keyboard by sequentially pressing the keys "ALT, W, F, C." Ignore Steps 3 through 7 if using this choice.

8

Unfreeze panes by repeating Steps 3 through 5 and selecting "Unfreeze Panes" or sequentially press the keys "ALT, W, F, F."

9

Open the Excel spreadsheet.

10

Freeze column(s) and row(s) at the same time by selecting the cell to the right of and below the location you want to freeze.

11

Freeze multiple rows only by selecting the cell in the left (first) column below the rows you want to freeze.

12

Freeze multiple columns only by selecting the cell in the top row to the right of the columns you want to freeze.

13

Navigate to the "View" tab on the top menu.

14

Click on "View," then click on "Freeze Panes." A drop-down menu opens.

15

Select the "Freeze Panes" option. You have now frozen the columns or rows, or columns and rows you designated.

16

Freeze panes using the keyboard by sequentially pressing the keys, "ALT, W, F, F." Ignore Steps 5 through 8 if using this choice.

17

Unfreeze panes by repeating Steps 5 through 7 and selecting "Unfreeze Panes" or sequentially press the keys, "ALT, W, F, F."

http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx

Freeze or lock rows and columns

Hide or show rows and columns

Aug 14, 2013 | Microsoft Office Business & Productivity...

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

1. Make sure you have entered the numbers you'll need in necessary columns

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

Aug 03, 2010 | Microsoft Excel for PC

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Business & Productivity Software

Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Business & Productivity Software

Do you mean the numbers down the left side? If you are missing a row number, it may be hidden. Get it back with these steps:

Push Ctrl + A (selects everything)

Click Format, then Rows, then Unhide. The row number should be back now.

Hope that helps.

Push Ctrl + A (selects everything)

Click Format, then Rows, then Unhide. The row number should be back now.

Hope that helps.

Feb 18, 2008 | Microsoft Excel for PC

Here's one way to do it. Your formulas would look like this:

B1:

=IF(OR(J1=1, J2=1, J3=1, J4=1, J5=1),1,0)

B2:

=IF(OR(J1=2, J2=2, J3=2, J4=2, J5=2),2,0)

B3:

=IF(OR(J1=3, J2=3, J3=3, J4=3, J5=3),3,0)

etc.

If you don't want the zeroes to display, format the cells with a custom number format--type: 0;-0;;@

B1:

=IF(OR(J1=1, J2=1, J3=1, J4=1, J5=1),1,0)

B2:

=IF(OR(J1=2, J2=2, J3=2, J4=2, J5=2),2,0)

B3:

=IF(OR(J1=3, J2=3, J3=3, J4=3, J5=3),3,0)

etc.

If you don't want the zeroes to display, format the cells with a custom number format--type: 0;-0;;@

Nov 14, 2007 | Business & Productivity Software

Use the =COUNTIF function

For example if column a has the letters in it:

=COUNTIF(a1:a100,"a")

or

@COUNTIF(a1..a100,"a")

This will count all of the letter 'a' s in

column a from row 1 to row 100.

Mike

For example if column a has the letters in it:

=COUNTIF(a1:a100,"a")

or

@COUNTIF(a1..a100,"a")

This will count all of the letter 'a' s in

column a from row 1 to row 100.

Mike

Oct 31, 2007 | Microsoft Excel for PC

When pasting data between tables, you have to make certain to select the exact number of rows and columns that you are going to paste into. For example, if you are pasting ten rows and ten columns of data, select (highlight in) from source table, Control C to copy, then go to destination table, select (highlight) ten rows and ten columns, then paste, either by right click and paste, or Control V.

This should solve your issue, but if not please post back. Thanks for rating FixYa!

This should solve your issue, but if not please post back. Thanks for rating FixYa!

Oct 03, 2007 | Microsoft Office Standard for PC

Jul 24, 2012 | Microsoft SQL Server 2000 Standard Edition...

100 people viewed this question

Usually answered in minutes!

×