• about oracle with Java

    What is future of Oracle with Java regarding jobs for freshers and distance learners. Why I am asking this because I am learning oracle from SQL star tutorial in delhi and doing MCA from Sikkim Manipal University in distance learning.

    Qqqq10 pointsBadges:
  • varchar(max) size limit

    I have defined a table field with datatype of varchar(max) but it only stores upto 8k characters, I thought (max) upped this limit to 2g character. How can I get it to store more than 8k characters?

    Niranjan5635 pointsBadges:
  • Adding and removing disk space for SQL2000

    The scenario:SQL_SVR_A (2000)has x amount 'too much' SAN disk space that they want to reclaim/use to allocate to SQL_SVR_B (2000)- which doesn't have enough space. What is the best method to 1)remove the disk space and keep all db's in-tact (backup/recovery?, or another way??) and 2)how to add the...

    Jclarcher15 pointsBadges:
  • Procedure cache ratio calculation in SQL Server?

    Hi, Does anyone know how to calculate the procedure cache ratio in SQL Server 2005 by selecting specific table in SQL Server? Thanks.

    Db23290 pointsBadges:
  • Query paging per second in SQL Server

    Hi, Just wondering if there is anyway to query the number of paging per second through SQL Server, some kind of system tables, etc. Thanks

    Db23290 pointsBadges:
  • difference between t- and pl sql lang

    in both t-sql and pl/sql we can use if/else condition and jump into other statements..then actually what makes the difference between t- and pl sql lang?

    NidheeshPV5 pointsBadges:
  • Linking Visual Basics and SQL database

    I wish to know a code that can enable me to link visual basis and SQL database in an organisation.

    131113115 pointsBadges:
  • Alter Column Drop Identity in T/SQL?

    Is it possible to alter a column definition to remove its identity property?

    Jagoodie60 pointsBadges:
  • The IT Blog Top 10: Feb. 4, 2010

    Here are the most popular blog posts on the ITKnowledgeExchange network this week. Read the rest of the top 10 on the Community Blog, or apply for your own blog by e-mailing me at Michael@ITKnowledgeExchange.com. 1. How to allow the root user to log in to VMware ESX Server with SSH David Davis’...

    Michael Morisy8,323 pointsBadges:
  • AS/400 to SQL Server Data Migration

    What are the steps involved in migrating data from AS/400 to SQL Server. Could you please elaborate as I'm pretty new to such migration work?

    Datamig5 pointsBadges:
  • Difficult Select Statement in SQL

    I have a table with columns, to wit: FieldA FieldB A U B V C A C A C B D A D A D A E B E B E B I can get the records that are multiple in FieldA but whose values in FieldB are repeating with: Select FieldA, FieldB from table  group by FieldA, FieldB  having count(*) > 1 And the result will be:...

    bogeybetsy560 pointsBadges:
  • two dimentional output

    I have a table. The structure looks like this: id(pk) year col1 col2 date 1 2008 50 60 feb09 2 2008 40 70 feb10 3 2009 60 80 feb23 4 2009 50 70 feb24 5 2008 40 80 feb26 I have no idea how to write a sql query to output a table which includes the latest of record of 2008, and the latest record of...

    Zhao5 pointsBadges:
  • sql server 2000 in server

    Hi, We have a server in which windows 2003 is installed and we have created users in the domain (eg - aaa). The server is installed with sql server 2000 and data is stored in the database. The user name for the server is administrator. The problem is when we login from the user computer as the same...

    Radhaisgoodenough5 pointsBadges:
  • SAP UPGRADATION PROJECT PHASES ?

    Hi, Pl give some idea regarding the phases in sap upgradation project . For sap implementation there are 5 phases involved in it ,on similar basis is there any such phases involved during the upgradation of project .what are the pain areas & what are basic requirements from functional side to go...

    Sappsmm55 pointsBadges:
  • The most-watched IT questions this week: Feb. 2, 2010

    Tick tock, tick tock. What’s that sound?  The countdown for the Nexus One Challenge. What? You’ve moved on? Well

    Michael Morisy8,323 pointsBadges:
  • controlling page breaks in a spooled SQL report

    I have written a SQL report that validates many of our tables.  Only when there is an error on a table will a report of that table print.  The script contains 32 different select statements each one associated with a different table.  I need to have a page break between the reports because the...

    Sherryborden85 pointsBadges:
  • problem in my pb11 application and sql2008

    this message apper to me on the client machine "ADO,net is not supported in your current installation"

    Nonosmm5 pointsBadges:
  • differences between SQL server 2000 & SQL server 2005

    Hai  Can any one tell me What are the Main differences between SQL server 2000 & SQL server 2005. Thanks and Regards

    Sukumardba5 pointsBadges:
  • Query Calculation Part of Select Criteria

    This query works great except I need to add one thing. There are two district codes that need to be included in the query. These codes just need the MC_Tax_Amount field totaled - no dividing by two. How do I add this to my query? Thank you, SELECT "T16.CPRP".CP_DISTRICT_CODE,...

    lorit365 pointsBadges:
  • Need help executing MULTIPLE SQL extracts from a JCL

    GREYBEARD52: Thanks again for the info, BUT I'm not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won't help - it doesn't support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command to 1. Run...

    Jonty Walker105 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