• Export SQL Server database to SQL script

    For my SQL Server database, is there a way to export it to an SQL script? I need something like mysqldump. It would take the database's name, and create a script that will remake the tables, data, stored procedures, etc. Does anyone know of anything like this?

    ITKE376,395 pointsBadges:
  • SQL: Loading data into server at real time

    How can I load date into server at real time in SQL?

    latha1705 pointsBadges:
  • Where should I start my entry-level IT career?

    How do I start career in IT industry when I have got bachelor's degree a long time back. I do not have an experience in IT but in HR. I do not have an experience in Canada where I have migrated 9 months back. There are very few females in IT industry. Where should I start. I even thought of...

    rinkyyy35 pointsBadges:
  • SQL stored procedure is taking too much time to execute

    One store procedure is working fine at one location. But the same store procedure is taking too much time to execute in different location on same network. What would be reason for this and how to reduce response time?

    mukeshkumar1230 pointsBadges:
  • How to get data in DB2 based on index like (LIMIT 2,9) in SQL and other databases.

    In other databases we get data based on index using LIMIT. Example: SELECT * FROM ZEMPLOYEE LIMIT 2,9. I tried using native SQL it works fine if we give LIMIT 3, it will fetch the records from 1-3 but when I give LIMIT 2,9. Then it should fetch the data from 2nd record to 9th record but It through...

    arshadshaikh5 pointsBadges:
  • SQL query: Find out the count of employee whose name is more than one time

    In SQL, how do I find out the count of employee whose name is more than one time in a table?

    meghanap5 pointsBadges:
  • SQL: Adding a new column to an existing table

    What are the questions from a BA standpoint? Shall I need to ask the business?

    ashishonweb15 pointsBadges:
  • Find the list of SQL statements run by a particular user on iSeries server

    How can I find the list of SQL statements run by a particular user on iSeries server?

    JohnsonMumbai1,280 pointsBadges:
  • Get all table names by SQL

    Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

    Oli0015 pointsBadges:
  • SQL statement Token error

    I keep getting a token error in my SQL statement.

    RateWatchProgrammer5 pointsBadges:
  • ORA-01445: cannot select ROWID from a join view without a key-preserved table

    Hello, For the first time in my IT-life I've encountered following error message when I try to run query using ROWID on a view: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table I found something about key-preserved tables, but I'm not sure that my...

    LukyFox25 pointsBadges:
  • Rookie using DSNTEP2 and IBM JCL – Need Help with JCL

    I'd appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I'm having problems creating a JCL - my brain can't remember command syntax's from that long ago. I need to create a JCL that will accept an input file of...

    Jonty Walker105 pointsBadges:
  • Create a sequence called Store_seq with the following values: increment by 10, start with 500

    Create a sequence called Store_seq with the following values: increment by 10, start with 500

    VB RD45 pointsBadges:
  • Regarding datetime function

    How we get output as (weekday date) eg: monday may5 1996?

    rbccollege285 pointsBadges:
  • Oracle SQL query

    How do I list the mid-western vendors (Illinois, Indiana, Iowa, Minnesota, Wisconsin)? Also display the vendor ID, name, contact name (first & last), city, and state. Use formatting and concatenation to reduce the space required for the contact and city (30 characters should be fine). Order the...

    kmoses5 pointsBadges:
  • SQL query for employees in my department

    We need to find 50% of employee from each department, who is getting max salary. And every department have different employee count. ex. finance may have 100 employees and sale may have 40 employee. How do I write a query for this?

    mukeshkumar1230 pointsBadges:
  • Oracle 11g KEEP buffer pool

    What is the SQL to determine what table objects are in the KEEP buffer pool?

    jmarsh5 pointsBadges:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 pointsBadges:
  • Retrieve SQL messages from Joblog

    Hi, I'm on 6.1 and I have RUNSQL in a CL program. The statement is 'UPDATE ...' and run's okay but I need to get the SQL MSG SQL7957 with the number of rows updated or the SQL0100 (row not found). I can get this with RCVMSG but only in debug mode. Can anyone help me? Rui

    RuiFerr15 pointsBadges:
  • How do we work with SQL?

    How do we work with SQL and what does it help in DBMS?

    veronicahmungai20 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.