• date functions using Oracle

    Hi, I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in 'yyyymm' format. ex, select year_mnth,benefits_paid from tablename where year_mnth in ('200603','200602','200601') note:it is in...

    Maha15 pointsBadges:
  • to write code

    i have created a table "stu" in which the following record exists. stu_id,stu_name,stu_course,stu_marks the stu_marks column output is as follows 822 758 789 658 822 879 598 825 589 785 795 795 658 789 988 what i want is to write query or code (function,procedure or anything) that when i execute it...

    Daudkhan5 pointsBadges:
  • my question

    How to find the repeating charactar or letter in a string like 'information' in pl/sql or sql .

    Maneswar15 pointsBadges:
  • AR server

    we r using the AR server 7.0 the backend database is sql 2000 under window platform, so now if I need to change the database table format to CLOB then, any one could tell me what is the format of changing the database format, I mean the table format to In-row and Out-row method. Could any one...

    Jiji5 pointsBadges:
  • Maintaining a company table in SQL

    I am not sure if I should mix budget data and sales data in one table in SQL or separate it. Also, if I add descriptors into the table, this will only increase record sizes and reduce the value of caching by padding each record out with repeated data. Is using small descriptor tables at run time...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error inserting data in table

    hi plz help me ,i want to insert some data in a table but some error ocurred. --------------------------------------------------------------- using System; using System.Data.SqlClient; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI;...

    Amitshukla60 pointsBadges:
  • Writing a query in SQL for use in SQL Server 2005

    I’d like to write a query that would allow me to view items with a characteristic of my choosing and filter out the others. Is it possible to write something like this in SQL and use it in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Oracle Reference to Table_Name, Column_Name, etc by reference to variable

    Does Oracle prohibit reference to Table_Name, Column_Name, etc by reference to a declared variable? I am trying to create a simple routine to print documentation whenever any changes are made to the database using the following routine: DECLARE CURSOR Table_cursor is SELECT * FROM TABS WHERE...

    Sweetpea0 pointsBadges:
  • Writing a specific query involving primary keys in SQL

    I need to write a query in SQL that will get the fifth-from-last record from my database when either a primary key is defined or no primary at all is defined. How would this query look?

    SQL Server Ask the Experts2,585 pointsBadges:
  • T-sql date question

    Does anyone know how I can convert 2005-09-14 09:49:13.873 to 2005-09-14 00:00:00.000 in a query?

    Kritchard0 pointsBadges:
  • how to view data in gridview with a sqldatasource

    hi , i m amit i want a help to view datasource and grideview,when i make connection in datasourse and use this connection in gridview and run it page can not display gridview structure. plz help me

    Amitshukla60 pointsBadges:
  • Unable to open a SQL application on two different machines

    If someone in our office opens a SQL application, no one else is able to open it. We all receive the message: “Another application is using this file.” How can we solve this problem?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL File Member Can SQL on i allows users to select a specific member to be processed without using a OVRDBF command

    Cqn SQL on i allows users to select a specific member to be processed without using a OVRDBF command

    Cragrat5 pointsBadges:
  • Definition of the withGrant parameter in SQL

    When giving permissions to database users in SQL, what does the withGrant parameter do?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Duplicate Sql

    Hi, I want to know in a given PL/SQL Procedure or PL/SQL Function How to find the duplicate(i.e., Repeated) SQL Statements. regards, aditya.

    Garimella5 pointsBadges:
  • Access databases

    I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?

    Michaelrdowney10 pointsBadges:
  • can a file be loaded from an embedded sql statement?

    can a file be loaded from an embedded sql statement? I want to use the file that was loaded to display the data in a subfile.

    Cansler50 pointsBadges:
  • Backup/Restore a DB from Microsoft SQL Enterprise Manager to SQL Server Management Studio Express

    Hi Is it possible to copy a DB from a server that has a genuin SQL Enterprise Manager to a server that has SQL Server Management Studio Express installed? Both servers are on the same net. I get following error when trying: Restore failed for Server 'PROGTST\SQLEXPRESS'....

    Lissy5 pointsBadges:
  • how to get database name?

    hi i am using th sql statement "SELECT * FROM MASTER..SYSDATABASES" but i want for perticular username and password

    Shwetha20 pointsBadges:
  • SQP file members

    Does SQL on AS400/iSeries allow selecting a specific member to be prcesssed without using a OVRDBF command?

    DMinNC10 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