• SQL Server Patch

    How do you get notified when Microsoft is doing a SQL Server Patch? Is there a way to be alerted before they do a patch?

    Amfaust15 pointsBadges:
  • Can you use variables as input and output when calling a stored procedure in COBOL?

    If you move data into your variable before calling your procedure, can the procedure then return a value back, which might be different? The procedure will intially be searching for the variable data, but, according to our .net programmer, will return a blank or null if it does not find the data....

    Bunkyg15 pointsBadges:
  • Free IT Book: Securing SQL Server

    This week's free IT book is written by one of IT Knowledge Exchange's very own members, Mrdenny. Securing SQL Server promises to help you "secure your SQL Server database so the outside world can't access your internal data." With Mrdenny's extended experience in simplifying SQL speak via his blog,...

    MelanieYarbrough6,345 pointsBadges:
  • SQL code made simpler

    I have 2 files that are clones - created by DUPOBJ. File_A is the original. File_BU is the copy. After I finish processing File_A, I want to update the same column (tSTAdm) in File_A when it is not equal to the same column (tStAdm) in File_BU. The file has a unique key – TsStat. I got the...

    PSMurray530 pointsBadges:
  • System tables in SQL Server

    How to view System tables in drop down menu of a database in SQL SERVER 2005

    VendoorMohankrishna5 pointsBadges:
  • Convert Oracle code to Microsoft SQL code

    I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?

    VelameLaCosa110 pointsBadges:
  • DBF in AS/400 – last record written

    Hi , There is  file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it.   Thanks

    Atti123135 pointsBadges:
  • View in SQL 2000

    How to create view with parameter? Thanks and regards.

    Pkaur65 pointsBadges:
  • UNICODE Characters

    When you run the query below: SELECT '✘ РǻuľO Čєѕaя ™' She is returning this: "?? Ulo C? To? ™" How to query return without truncating the text?

    Caiquedourado5 pointsBadges:
  • EmployeeNumber query in SQL Server 2008

    I am trying to write a query that will generate employee numbers. Employee number = first initial & first 7 characters of last name. UNLESS that is taken, then it's first initial, first 6 characters of last name, then the number 1. UNLESS that is taken, then it's first initial, first 6 characters...

    Mmdmurphy30 pointsBadges:
  • Free IT Book: Achieving Extreme Performance with Oracle Exadata

    This week you could win a copy of Achieving Extreme Performance with Oracle Exadata from Oracle Press. Chock full of best practices for Oracle Exadata Database Machine deployment and maintenance, this resource covers data warehousing, transaction processing, consolidation strategies, maximum...

    MelanieYarbrough6,345 pointsBadges:
  • Application compatibility with SQL Server 2005

    We would like to upgrade from SQL Server 2000 to SQL Server 2005, but we are currently also using PowerBuilder version 6.0. How can we determine if our version of PowerBuilder is compatible with SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Increase in Network I/O when running SQL Profiler

    Hi, Just wondering why every time I run the profiler on SQL Server 2008, and I monitor the Activity Monitor's network I/O it increases and when I stop or pause the profiler the network I/O decreases? This occurs the same when I run the profiler remotely or on the SQL Server instance. What has this...

    Db23290 pointsBadges:
  • Inserting DB2 records on iSeries to SQL Server 2005 Table

    I need to insert records from a DB2 file residing on an iSeries to a SQL Server 2005 table on a remote system. How can I do this in a CL or RPG ? Thanks

    shizam5 pointsBadges:
  • Problem Querying SQL table from PHP

    I recently added a new table to an existing database. Data is entered into the db via a web front end, using PHP 5. I am not a php developer. Our developer is trying to build a search query against the new table (there is data in the table). From the page he is working on, he can run a query...

    ELHaysStrom20 pointsBadges:
  • I want to dump the contents of the DSPFD command to file and then use FNDSTRPDM to find certain text strings

    I am doing some testing with file attributes that I want to automate.  I have been using the DSPFD command to print the attributes of the file.  I would now like to automate that.  I tried dumping the output of the command to an outfile and then using FNDSTRPDM to find out if the attribute was...

    Qa40045 pointsBadges:
  • How to save the output from an SQL select statement to a spool file

    Please can someone tell me how I can save the output from an SQL select statement to a spool file. Thanks, Tom

    Tomotsk75 pointsBadges:
  • AS/400 tab text delimited format of physical file

    Hi , Using i series utility you can download PF as Text Tab Delimited format in your PC.However when I do the same by CLP using CPYTOIMPF using FLDDLM as X'05' or *tab , I get a text tab delimited file which is not completely same as the file downloaded using I series utility.

    Atti123135 pointsBadges:
  • Select Value question in SSMS

    I am trying to select "log_comment" field with the max("stamp_date") field from "action_log" table where "field_index" field ='1007' I am getting more than just the row with the maximum stamp_date. Can someone please tell me what I'm doing wrong? Field_Index    Stamp_Date   Log_Comment...

    Sadams115 pointsBadges:
  • Building new SQL server

    had a sql server (2000 I think) built on enterprise 2003 die. Got new hardware and am beginning the guessing game. any good reference articles, step by step of how to build new and restore backups from external hd. Old server won't even boot.

    uwantfries60 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