Questions & Answers

  • Altering a column in SQL Server 2000 (Not Null)

    I have a table in SQL Server 2000 that has several null-able integer columns. These are not working for me so I'm trying to update all nulls to 0 and then set the columns as "NOT NULL" (But the data must be preserved). Is there a specific SQL Syntax that could set the columns this way?

    ITKE342,985 pointsBadges:
  • Removing duplicate rows in SQL Server?

    I’m working with a large table (450,000+ rows). Many of the rows contain duplicate data and I’d like to be able to pull the dupes out. What is the best way to do this knowing that the rows are not fully duplicates due to the RowID identity field.MyTable ----------- RowID int not null...

    ITKE342,985 pointsBadges:
  • What is the most efficient way to implement pagination in SQL Server 2008?

    I am trying to find the most efficient way to implement paging within SQL Server 2008, using ASP.NET MVC and LINQ. Should I use LINQ's Skip() and Take()or implement my own pagination with a SQL query?

    Chris Leonard4,300 pointsBadges:
  • We have one AS/400 printer of HP model

    We have one AS/400 printer of HP model, its printing first print and then stopping, every time we have to start the printer. Can you please suggest why this is happening, and how can we fix this.

    anusuiyasingh5 pointsBadges:
  • Exchange 2010 ABQ affect on 2007

    I have a coexistence of 2007 and 2010. As we migrate people to 2010, we are planning to make them enroll their phones with us and we want to whitelist them. It looks to me like we need to set the organazation default to quarantine and then add them by allowing user to use certain device IDs. 1) If...

    DraconianBillly25 pointsBadges:
  • Old questions keep coming up on the top of the stack

    I cannot find new questions .. I suspect you've cleaned up some junk and it's reset the last change date..

    philpl1jb49,600 pointsBadges:
  • Color is different in SQL Server 2012 ReportViewer

    A friend of mine recently installed SQL Server 2012 with Reporting Services. When he actually selects a report, the filter/input bar (which is connected to the report) has a blueish look. But, when he's using the ReportViewer server control version, he gets the old beige look (as in previous...

    ITKE342,985 pointsBadges:
  • Function internet call

    What is the function internet callback? I really don't understand the concept.

    fauzi1235 pointsBadges:
  • iOS7 Mail Volume

    How do I control the volume of mail in my iPhone mailbox?  I have recently downloaded IOS7.

    Artist705 pointsBadges:
  • Looking to create and populate a numbers table in SQL Server 2005

    Now in SQL Server 2005, I know there are different ways to create and populate a numbers table. But, what's the best way? I'm looking for the best way to optimize these characteristics:Table created with optimal indexingrows generated fastestsimple code used to create and populate

    ITKE342,985 pointsBadges:
  • What does this controller error mean?

    I have an HP Pavilion Laptop running Windows 7. I recently discovered an error in the Event Viewer: The driver detected a controller error on DeviceIdeIdePort1. (more details): - System - Provider [ Name] atapi - EventID 11 [ Qualifiers] 49156 Level 2 Task 0 Keywords 0x80000000000000 - TimeCreated...

    ITKE342,985 pointsBadges:
  • How to initialize Catalyst 2950 cisco witch to be a normal witch

    Hello !! I'm Savon I want to make my cisco switch Catalyst 2950 to be a normal switch . But I don't know how to...Please show a video or menu guide to make it ....Thank you somuch !!!

    savon0075 pointsBadges:
  • FLOWCHART Generator for COBOL

    Does anyone know of a product for generating a flowchart for existing COBOL code on the AS/400?

    RPGCRAZY30 pointsBadges:
  • Wireless Restriction

    Hello all, I need to restrict wireless inside one conference room only so that no other user outside the conference room receives a wireless signal in any private device he/she is carrying. The wireless connection can be used only on AD authentication, so not all users can use it, nut still the...

    dcbaef20 pointsBadges:
  • How to split a string in SQL Server 2005?

    While in SQL Server 2005, how do I split a string so I can access item x? Let’s say I have a string “Peyton Manning”. Is there a way to split the string by adding a space and accessing the item at index 1 so that it reads "Peyton"?

    ITKE342,985 pointsBadges:
  • Delete pages

    How do you delete pages from a saved .pdf files?

    Houd265 pointsBadges:
  • Changing/disabling foreign key constraints in SQL?

    Is it possible to enable and disable foreign key constraints in SQL Server? I’d prefer to avoid using 'drop and re-'create' to manage the constraints.

    ITKE342,985 pointsBadges:
  • How can we add a column (with a default value) to a table in SQL Server 2005?

    Our business is using an older version of SQL Server (2005 in fact) and all we're trying to do is add a column, with a default value, to an existing table. Can someone point us in the right direction?

    ITKE342,985 pointsBadges:
  • Create Excel from AS/400 with multiple sheets

    I have a requirement to generate an excel from 2 different PF as 2 sheets in a single Excel file. I have created single sheet excel using CrtCsvDta command. Please help me to figure out to generate multi-sheet Excel from AS400.

    RamvishakRamesh2,505 pointsBadges:
  • OBIEEP NUP Minimums

    Does anyone know and can reference a current Oracle document on OBIEE NUP Minimums per core/processor?

    tmccool5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following