Question about Microsoft SQL Server Standard Edition for PC

1 Answer

To delete a column from a table working /as sysdba

Hi.
can u tell me that if i'm workin under sysdba',how cn i delete a column from a table.
if i use "set unused" funda,its showing an error tht you can't delete a column from sysdba.
reply soon

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 2,794 Answers

If your password is setup for admin, you should be able to bring up the table structure and delete the field. You may need to disable SQL server to do this if your table is opened on another computer.

Posted on Nov 17, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How can I create a bulleted two column list within a resume document?


This requires you to create a table. Look for a Table menu or menu item in the Format menu. You'll need to tell it you want two columns and five rows in the table. After you've inserted the items you can then highlight everything in the table and right click to choose bullets from bullets and numbering from the format option.

Oct 04, 2015 | Business & Productivity Software

Tip

Getting the highest value in a column less than some other value


This is good really for SQL Server, Oracle, or anything that can handle SQL.

Most hacks know about MAX(), as in:

SELECT MAX(col_name) FROM table

So if the column has a max value in it of 10, you get 10 back. But what if you want the highest value in the column that is less than a certain amt.? This for example is good for getting back the next most recent record when col_name is an incrementing key column and you want to exclude the most recent record (ID'd by it having the current maximum value key) in the column. Now you are faced with writing an SP or egad, traversing a recordset client-side. Ugh.

Here's the fix:

SELECT MAX(col_name) FROM table WHERE col_name < {some_value}

This works. It works even when the key column is not guaranteed to have continuous sequential values, such as when records are added and deleted over time and the key values assigned all stay the same (which is what happens in 99.9999999+% of all cases).

Have fun.

Homework: Haven't tried it but I am betting you can also do this:

SELECT MAX(col_name) FROM table WHERE col_name < MAX(col_name)

Whoa... well, try it and see if it works. Some SQL interpreters don't like aggregation/sub-computational functions on the right side of the comparator. In that case, you'd get MAX(col_name) first with a simple SELECT stmt., assign it to a variable, then use that variable as the right hand side modifier for the '<' comparitor.

Seems simple, right? But oh, the pain these kinds of situations cause. Hope this helps some of y'alls.

on Mar 26, 2008 | Microsoft SQL Server Enterprise Edition...

1 Answer

Sum numbers in a column down until you come to a blank, then start again


Sounds like your issue can be solved readily with a pivot table.
If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.
Insert the Pivot table into a new worksheet.
A new sheet will open with a strange-looking control panel on the right of the window.
Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Sep 03, 2014 | Microsoft Excel for PC

1 Answer

How to make columns in microsoft works


In the INSERT menu of the document Writer choose a table. In the worksheet part of Works, open new page and you have columns galore.

Feb 25, 2012 | Microsoft Works 8.0 for PC

3 Answers

What is vlook up & what is hlook up?


The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table

I have posted below link to know more .Please have a look..

http://www.howtodothings.com/computers-internet/how-to-use-the-vlookup-and-hlookup-functions-in-microsoft-excel
http://support.microsoft.com/kb/181213

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

Please rate & vote if you like soution..

Thanks
Sandeep

Mar 14, 2011 | Microsoft Excel for PC

1 Answer

Application and example of relationship in access


Relationships

After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.

A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, teachers can be associated with the students they're responsible for by creating a relationship between the teacher's table and the student's table using the TeacherID fields.

Having met the criteria above, follow these steps for creating relationships between tables.
  1. In the database window view, at the top, click on Tools ---> Relationships
  2. Select the Tables you want to link together, by clicking on them and selecting the Add Button
  3. Drag the primary key of the Parent table (Teacher in this case), and drop it into the same field in the Child table (Student in this case.)
    relationshipdrag.jpg
  4. Select Enforce Referential Integrity
    refintegrity.jpg
    • When the Cascade Update Related Fields check box is set, changing a primary key value in the primary table automatically updates the matching value in all related records.
    • When the Cascade Delete Related Records check box is set, deleting a record in the primary table deletes any related records in the related table
  5. Click Create and Save the Relationship

Apr 09, 2009 | Microsoft Business & Productivity Software

2 Answers

I have been trying to get this formula or function to work all day


You might try looking/posting on forum sites like http://www.mrexcel.com/archive/index.html
That has helped me with different things, especially correct syntax.

MM85

Jul 27, 2008 | Microsoft Business & Productivity Software

2 Answers

MS DATA DUPLICATE Problems


You will need to state your problem Taru with a bit more explanation but to try to point you in the right direction....right clicking and clearing the contents of a cell, row or column works if I remember correctly.

Jan 19, 2008 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

Access Pasting Multiple data in the table


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!

Oct 03, 2007 | Microsoft Office Standard for PC

1 Answer

Vlookup


Hi Ralph, On the first table If the name is in column A and dept is in B. Suppose the new names are in column D here's the formula =vlookup(D1,A:B,2,0) Note a few things - 1. You will only receive the 1st departament. 2. In case that the name in D doesn't appear in A you'll get N/A. This can be solved using the following formula: =if(type(vlookup(D1,A:B,2,0))=16,"",vlookup(D1,A:B,2,0)) Let me know if there's anything else. D.

Aug 27, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft SQL Server Standard Edition for PC Logo

Related Topics:

60 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...