• Check IF Field is Numeric in AS/400 SQL

    is there a function to check if field is numeric (like ISNUMERIC in standard SQL)?

    Jaggerdude60 pointsBadges:
  • Earning Badges Pays Off – Literally!

    We told you that payoffs were coming, and they're finally here! To kick off this exciting new phase of the IT Knowledge Exchange Badge Program, we're doing a site-wide reward for members who have been active within the past 6 months and have earned at least one badge: $10 Amazon.com gift card to...

    MelanieYarbrough6,345 pointsBadges:
  • Can’t close or clear file in iSeries V5R3

    Generally we create a file in QTemp when returning data for a stored procedure. The cursor is left open so the data can be accessed. I neglected to copy the file to qtemp and now on our test system, I can't close the file, I can't clear the file. I've deleted each of the records in the file...

    ItsHer20 pointsBadges:
  • Error message when installing SQL Server 2005

    I have installed SQL Server 2005 and acquired SP2. However, when I continue to install the SAP dialog instance, it gives me the following error: MDB-05036 Error when creating sqldmo SqlServer object What does this mean?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Data File Storage

    We have a SQL Server with 32GB of RAM, 8 CPU 16 Cores, using SAN. On our production database (1 database only) we have 3 file groups Primary, Core, Index with 1 file in the PRIMARY Group, 16 Files in the Core Group, and 16 Files in the Index Group. Each file group including all data...

    Rick Martinez585 pointsBadges:
  • SQL failed to execute the “ROLLBACK” command

    In the process of querying i made a mistake in an UPDATE statement which affected my "UNIT" field (all UNIT changed to 500). I used the ROLLBACK but dit not work. Please help

    Okappaw55 pointsBadges:
  • Select statement in asp.net

    How can i use ms sql select statement with where clause in asp.net

    Pioneerinaspnet15 pointsBadges:
  • Connecting to a SQL Server 2005 database through LAN

    I am trying to connect to my SQL server 2005 database on my server. I open SQL server 2005 management studio and try to set the server name to IPADDRESS\SERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either

    Providence15 pointsBadges:
  • SQL SERVER Data Files and Threads

    I am reading a Microsoft Press Book MCTS Exam 70-432 and in chapter 2 it talks about Data Files and it says "SQL Server creates a thread for each file underneath a database. As you increase the number of files underneath a database, SQL Server creates more threads that can be used to read and write...

    Rick Martinez585 pointsBadges:
  • Combining 2 queries in SQL 2008

    I am having a little trouble combining the following 2 queries into a single nested statement (if indeed it's possible). Can anyone assist? Query 1: SELECT Eff_Date, CoNum, Brandname, COUNT(Brandname) AS CountOfBrandName FROM dbo.Products WHERE (Eff_Date BETWEEN '1/1/2010' AND '12/31/2010') GROUP...

    DavidHa!!110 pointsBadges:
  • Selecting Field Defined as L in SQL Server

    I am building 4 part SQL select across 4 files using union alls. All 4 files have a date field which is one of the fields I am selecting. My problem is that on one file the date field is defined as L type where the other three files have a date field defined as 8S 0. Since the field I am selecting...

    Canuhp235 pointsBadges:
  • How I can automated process load xml file to SQL server 2008?

    Hello!

    Ana6335 pointsBadges:
  • SQL Server and AntiVirus

    We have many sql server running on seperate boxes, the Network team wants to install antivirus software on all the sql servers. Is that a good idea? Why?

    Rick Martinez585 pointsBadges:
  • SQL Server 2005 database conversion

    HI, we plan to migrate SQL server 2005 from SQL server 2000. we have database with average size of 12GB. can any one please let me know how to convert our database from SQL2000 to SQL2005.Thanks in advance.

    Anto5 pointsBadges:
  • Pagination in SSRS 2005 Reports

    I have several reports in SSRS 2005 that consist of a "report header" area with various textboxes (note this is in the body of the report, not a page header) and then a table -- sometimes a very long table (and then a "report footer" area with some more textboxes, and also a bona fide page footer...

    Groberts3145 pointsBadges:
  • Web development course and Microsoft qualifications

    I recently left my job in the UK as a project manager from a niche organisation that provides business services to public service bodies. I am thinking of sharpening my skills by doing some web development training and getting certified with some Microsoft and Adobe products and moving into Web...

    Tobeeornot25 pointsBadges:
  • TWO Free IT Books: Multicore Application Programming & The Rails 3 Way

    We've got two free IT books this week. Since nobody won last week's The Rails 3 Way, we're piggybacking the books together. Both contests are currently happening, and winners will be announced Monday, March 7, 2011. The second free IT book, Multicore Application Programming, is a comprehensive,...

    MelanieYarbrough6,345 pointsBadges:
  • MySQL vs SQL server

    If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they're cabable of or does it just change what front-end you use? Why would I need a WAMP stack and what exactly do...

    Katy20 pointsBadges:
  • How to check browser activity?

    Hi, i'm working a project ,In that i'm storing login,logout time,wht if i don't click logout button and close my browser,or somehow my system shutdown.i cannot store the logout time,so that my program will be in error state.. tell me how to get the logout time when my programmer didn't click logout...

    Karthij5 pointsBadges:
  • Open PDF with parameters

    I want to open a PDF file with a #page= parameter. This works if I create a fetch link with the full folder string - http://ecm.domain.net/ecm/livelink.exe/fetch/2000/115075//GUIDE.pdf?nodeid=9948579#page=4 ...but does not work if I "Open" the shortlink -...

    Luvdove10 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