• SQL Text Match on Character Stream (wildcards)

    I need to match a text field on zero or more characters. If available, the 'or more' characters need to be in a specific sequence. The % wildcard doesn't quite cut it. For instance, I need to match the name with 'm', 'ma' or 'mar' (but no other character combinations). Is this possible?

    Ohreallyus5 pointsBadges:
  • Designing a report in SQL from an Excel worksheet

    I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to import this specific information?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Questions about a SQL database with hourly transaction log backups

    We have a SQL database with a full recovery model that backs up the database once a day, along with hourly backups for the transaction logs. However, we only have one transaction log backup file, and it is overwritten every time. Are transaction log backups cumulative, and if so, does that one file...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL DATABASE SERVER

    Hi, Please how can I access a client SQL database server remotely to update date therein. My client have this MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. and I will need to update the data. I have to update the database. I have downloaded SQLEXPR and installed in...

    Chukbillo20 pointsBadges:
  • enterprise service bus

    What are the advantages and disadvantages of the enterprise service bus

    Peter7245 pointsBadges:
  • create .csv file from table

    how to create a .csv file which will contain data in 2 or more tables

    Cpp5 pointsBadges:
  • 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:
  • Can I do create dynamic table while bulk insert ?

    Hi, I am Software Engineer, I am using SQL-SERVER, I have a issue with it. I want to write a query to dynamically create a table when using BULK Insert. No of Column is dependent upon no of fields available in first row. Assume that in each row no of column is same.Column name can be any string,...

    ARUNKUMAR1125 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:
  • Unable to Restore Backup in SQL Server 2005

    I am unable to RESTORE Backup through code in SQL Server 2005 from VB.Net, even though that code is running fine in SQL Server 2000. The code is: "restore database [" + databasename + "] from disk ='" + Me.lblSource.Text + "' with move '" & dfile & "' to '" + Me.lbldatafile.Text + "'," & _...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Need some deployment tools

    Hi, I'm already using CVS for my environment but I would need some more tools, to allow me to compare config files, rollback easily and its not mandatory to be free software. Any suggestions?

    Cable0guy20 pointsBadges:
  • batch queries in oracle

    We are developing a .NET web application and have decided to use CSLA as our business architecture framework. Because CSLA is based on Microsoft technology, it is designed to work with MS sql. Much of the framework uses batch queries to grab multiple result sets in one query but it appears that...

    Dhworth5 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:
  • How can we Use SQL 7 in Visual Foxprox

    Dear Friends, in my company we are using Visual basic with SQL, in VB we have very problem to create Text files, But We Good Know Foxpro (easily create text file in visual foxprox), so I want to use SQL 7 in visual foxprox, Note : Many Link i see on net, but not all working. Please send me reply...

    Abhiindia15 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:
  • Excel – Automatically Publish graphs to Intranet

    I want to publish updated graphs to my intranet automaticlly. ie open excel, refresh data (from as400)then save,publish&close (running from the scheduler ) I have my Downloaded vb express & looked at vb sites etc… & managed to create a project which publishes the page to the intranet correctly...

    Gerrib150 pointsBadges:
  • Release management reporting

    how to create reports to measure in time delivery of Release management and change management

    HertzBruno20 pointsBadges:
  • Microsoft Access in a Server

    Hi I am using Vb6 as front-end which is installed in the client machines and MS access 2003 in my server as back-end. Can I create local copies in each client system and at a particular time I need to update the server database with the local databases

    Threeeye5 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