• Removing spaces between two words in SQL

    Hi, I have a table called employee and column called Name. The column Name contains (firstname lastname)i.e. firstname 'space' lastname. I want to retrieve just the firstname from the column Name for ALL the employees. I have tried using the function "substring" but since the firstname can be of...

    Kpatel0 pointsBadges:
  • sqlserver 2000 stored procedures

    Hi , i have the unfortunate task of time to integrate microsoft sql server 2000 stored procedures to mysql so that our software will work. Can anybody tell me if this can be done, if so how easy is it and how do i go about it? Thanks for your help andy

    Andy119830 pointsBadges:
  • REPORT WAIT TIMES

    We have a commercial accounting software package programmed in Access. Recently began having to wait for some reports to process to the screen for over 3 minutes. We have only had this software for under a year and have eliminated the problem being the network by moving the data files from the...

    Jmoeller0 pointsBadges:
  • Urgent!Please help: TOP 3 cities only returned based on count() – result

    I have three tables: Country, City, Restaurant. I would like to have a query that first calculates how many restaurants are for each city. I would only want to return those three cities for each country which has the most number of restaurants. Country-table: countryid, countryname City-table:...

    Ronjar0 pointsBadges:
  • SQL Trigger to create .csv file

    I need to create a .csv file out of table A upon the insertion of a record into table B. It seems to me that this should be easy to accomplish, but the only answer I can get from anyone is to do a scheduled DTS package, which means we are dumping this table every couple of minutes all throughout...

    Zannemarie0 pointsBadges:
  • Oracle ./runInstaller problem

    Dear Oracle Experts, I came across the following problem when trying to update my Oracle 9.2 to Oracle 9.2.0.4 When I typed > ./runInstaller for the Oracle 9.2.0.4 patch. I get the following error. "You do not have permission to write to the inventory /oracle/product/db/920/$ORACLE_HOME....

    Asiankiwi0 pointsBadges:
  • Exporting Data to Text/CSV file in SQL Server 6.5

    Hi, I would like to know how do we Export Data to Text/CSV file in SQL Server 6.5 Do we have something similar to DTS in SQL Server 2000? Thanks, Kruti

    Kpatel0 pointsBadges:
  • Accessing Linked Server in SQL Server 2000 (Urgent)

    I have a server named say 'SRVMAIN'. Using Enterprise Manager I added a linked server 'LNKDSRVR1' (existing server). I m able to access any database in 'LNKDSRVR1' by writing a query in query analyzer of 'SRVMAIN' as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as...

    Bakash0 pointsBadges:
  • SQL Server equivalent of Oracle’s desc tablename command

    Thank you all for the response to my previous query. What is the T-SQL equivalent of Oracle's desc command? I mean, what is the command in T-SQL to see the structure of a particular table? And what do we do in T-SQL if we want to see list of all the tables in a particular database?

    Kpatel0 pointsBadges:
  • Difference between SQL and T-SQL(Microsoft SQL Server 2000)

    What is the difference between SQL and T-SQL(used by Microsoft SQL Server 2000)?

    Kpatel0 pointsBadges:
  • Database comparison

    I know this is 'cheating' but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp's etc. I think this can be done using systables, however i was wondering if anybody had done this and how easy it was. All...

    UselessOne0 pointsBadges:
  • Convert date format from UTC to PST in SQL

    HI Friends Is there any way to convert date format from UTC to PST? Thanks and Regards Ashu

    Ashug8bangalore0 pointsBadges:
  • Returning Multiple result sets to Excel

    I need to return a full result set including a number of Sum(s) Max(s) etc to an excel spreadsheet (don't ask why) from a Stored procedure on MS SQL2000. Problem is that Xcel can only handle a single result set per sheet... Any Ideas?

    UselessOne0 pointsBadges:
  • Front-End Reporting Tools for Secure Web Service Application with MS-SQL server

    Hi... We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small web service application for reporting purposes that will require minimal IT experise to build or maintain. The back end RDBMS engine is built with MS...

    Mmosystem0 pointsBadges:
  • Calling all SQL Server experts!

    My name is Catherine Ketcher; I am a TechTarget editor in the process of launching a new site targeted to IT professionals using MS SQL Server. I am looking for SQL Server experts to participate on the site. I need experts interested in writing tips and/or answering questions in our 'Ask the...

    CathyK0 pointsBadges:
  • Unix ODBC Drivers

    I am looking for an inexpensive way to do a pull of Sqlserver data into Oracle using Native Oracle Sql Statements to select the data from Sqlserver. This request would be easy to fulfill if there were an ODBC driver for Unix. I have found such drivers but they are expensive ($4000 per CPU on Unix...

    Jk666380 pointsBadges:
  • T-SQL, and cascading updates or finding constraint names

    Hi all, I have been tasked with a difficult project. My employer has a rather large database, hosted on SQL Server 2000, which is used by several thousand users across our organization, and grouped by business units. This database is evolving with each minor release, which is just about every...

    Sonotsky695 pointsBadges:
  • Accessing SQL Server data-2

    I need to access data on an SQL server from our AS/400. I need something quick and cheap. Help!

    As400guyone0 pointsBadges:
  • Database choice for web application

    I am building web applications, using ASP.NET, each of which must store/retrieve data to/from a set of central databases. I basically have a choice between using MS Access or SQL Server and could use some advice about which to go for or what criteria to apply. Bear in mind that there will be...

    JacobSCracker0 pointsBadges:
  • TopIndex property for .NET Web ListBox

    I'm trying to automatically scroll down to the last inserted item in a multi-select ListBox when only a few of the total # of rows are visible. Windows.Forms ListBox control has a TopIndex property that allows you to do that, but there is no similar property for the Web control. Note: In a single...

    Nohemi0 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