in
All Tags » sql server (RSS)

Browse by Tags

  • How do I identify similar registries in a Database and Catalog them automatically?

    Hi, I have a huge table with a lot of registries in a column wich I wish to catalog. The column looks in some way like this: Store -------- Apple Store MI Apple Store CA Online AppleStore WalMart NY WalMart WA Wal-Mart Optic Dept ...... ... I'm a total newbie in ETL's and just downloaded SQL...
    Posted to EAI (Forum) by software on 06-17-2010

  • SQL Server- parse path into 2 different tables

    I have a table FileName with a field called Path. Here is an example of a record in the field: C:\My Documents\My Pictures\Vacation2010\Sunset.jpg 1. I need to write a procedure/function that will parse the extension from field Path in the table FileName to field extension in the table FileName. (THIS...
    Posted to Btrieve (Forum) by software on 06-16-2010

  • Sql Server

    Hi, I am getting this error "failed to convert parameter from datetime to byte[". I have a variable that is storing System.DateTime.Now .. In my Sql server i have it as Timestamp. I am attaching it to a gridview and i want to show the time along with the date as well. Any help will be appreciated...
    Posted to REALbasic (Forum) by software on 06-13-2010

  • SQL Server Client tools licensing

    Hi All, What if I install just SQL client tools on my pc using a enterprise edition 180 day trail version. will that installed tools to get expired after 180 days or will that tools be good after 180 days too?
    Posted to Btrieve (Forum) by software on 06-11-2010

  • SQL Query help

    HI All, I am setting up a very basic point score database and require some help with writing the appropriate SQL query. I have 3 tables, and only need to run a few few reports. Table 1 - Members id, Name, Class Table 2 - Events id, date, venue, type, president_series, clubman_series, points (clubman_series...
    Posted to Oracle (Forum) by software on 06-07-2010

  • How do I run SQL Server Backups from a client application

    Experts I have created a small SQL server Express/VB.Net app for a couple of users to manage a small dataset on a single standalone computer. I want tihe users to be as autonomous as possible so have created a backup/restore process in the application for the SQL server data for a daily full back up...
    Posted to Btrieve (Forum) by software on 06-05-2010

  • How do I calculate the elapsed time?

    Hi, Say... My transaction table has date field and time field. How do I calculate the time elapsed after doing the transaction? Thank you. Regin
    Posted to Oracle (Forum) by software on 06-05-2010

  • Modify method in dealing with XML data on SQL server

    Modify method is sued on XML data to manipulate directly particular attribute or field of a given record It has three submethods namely Insert, delete, replace I get an error while trying to delete a value in a particular column. I am working on a books table which looks like this ee3.jpg And now I am...
    Posted to XQuery (Forum) by software on 06-03-2010

  • Begin SQL Transaction within IF statement

    Hello Experts! I'm trying to write a fairly simple SQL stored procedure and have run into some difficulty. The purpose is to test whether one of the parameters is 0 or -1 (via a bit variable) and if it is 0 then perform a certain INSERT statement and if it is -1 then perform a different INSERT statement...
    Posted to EAI (Forum) by software on 06-03-2010

  • SSIS output column (nullable)

    Hi, Experts, I have problem for null value in SSIS "output column". in SQL server 2008 in my package, the input string is from excel sheet. and the strings are "either" empty or "has value" in the case of empty, I would like to put null in the database (SQL server 2008)...
    Posted to Oracle (Forum) by software on 06-02-2010
Page 1 of 85 (847 items) 1 2 3 4 5 Next > ... Last ยป