• Update a Date_Time Field

    I'm trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I'm missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ' ' WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value 'Ê' to a column...

    DJandLO130 pointsBadges:
  • Restrict a script to reduce SQL injection attacks

    I want to reduce SQL injection attacks. How can I restrict a script to execute one query at a time?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Send a email with attachment?

    How do I send a email with attachment in a SQL script using SQL 2000?

    Mistp00120 pointsBadges:
  • Getting “An error has occurred while establishing a connection to the server” error message

    While running the setup on client machine, An error Number 5 occurred telling - "An error has occurred while establishing a connection to the server. When connecting to SQL server 2005., this failure may be caused by the fact that under default settings SQL server does not allow remote connections....

    Pchandrachoudhary5 pointsBadges:
  • Getting ORA-29283 error when opening CSV file using UTL_FILE.FOPEN

    I have a SQL script and all it does in to open a CSV file using UTL_FILE.FOPEN. I keep getting the ORA-29283 error.  I have an Oracle directory object pointing to the file location. Here is the code snippet: create or replace procedure "SKINNY" as v_inputfile            ...

    jkeri360 pointsBadges:
  • Locating active procedures in iSeries SQL

    I have a strange problem in iSeries SQL. I'm running a script that fails every time it tries to create a procedure that already exists. The script is quite involved and necessary to complete a number of projects. Is there a way I can determine if specific procedures within the system already exist...

    ITKE351,965 pointsBadges:
  • Creating a SQL script for determining if a sequence exists

    I'm looking to create a SQL script to see if a sequence exists in my SQL Server 2012 database. I understand the concept of stored procedures but not with sequence.

    ITKE351,965 pointsBadges:
  • ORA-06502: Character string buffer too small

    Hi guys, Here's my script I have created aggregate string function 'Tab_To_String' using this below script CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); CREATE OR REPLACE FUNCTION Tab_To_String (p_varchar2_tab IN t_varchar2_tab, p_delimiter IN VARCHAR2 DEFAULT ',') RETURN...

    Kruti123456789shah15 pointsBadges:
  • Validate SQL and display the output

    I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether it is valid or not....

    RamvishakRamesh2,505 pointsBadges:
  • System i Navigator Run SQL Script block CL commands

    Hello. The run sql script in System i Navigator allows me to run CL commands. How can i block this? Thx in advance.

    MelGranja20 pointsBadges:
  • Update SQL Server 2005 Scripts

    I don't right code & don't have the confidence to try on my own so, I'm asking for help. I need to run an update script to clear out the data from iweb_conf_demo.Attendee_ribbons.Then I’ll need to run multiple scripts to update multiple records on the same field iweb_conf_demo.Attendee_ribbons...

    DJandLO130 pointsBadges:
  • Running a script against local SQL servers

    Hi guys i am trying to run a script against local servers stored on a txt file i have already used osql to list the output to a text file. but after this probs

    Cerb300365 pointsBadges:
  • Create QA database with only some production tables

    I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They're all in the same filegroup in the original database. I've...

    Rwaltz5 pointsBadges:
  • Translate Ruby Script to SQL Query?

    I need help translating a ruby script to SQL query. I'm a SQL noob. Help please. [em]here is the script.[/em] require "rubygems" require "ruport" SQL = <<-EOS SELECT     tv.ApptDate, tv.PatName, tv.PatFirst, tv.PatLast, tv.Phone, tv.ApptTime, tv.Provlast, tv.ProvFirst, tv.ProvTitle,...

    Transom3245 pointsBadges:
  • SQL Server 2005 maintenance plans

    I have several maintenance plans setup in SQL 2005, but if the backup fails I am not alerted in any manner how can I fix this? Will I need to script something or is this a built in feature?

    TeachMeIT975 pointsBadges:
  • dba deleting data

    Is part of a DBA's job to delete production data using SQL scripts?

    Biker015 pointsBadges:
  • iSeries Navigator SQL Script Output

    I'm not familiar with CL but is there an easy way to direct the output of an adhoc SQL query in iSeries Navigator into a CSV file in my local Windows drive? Thanks in advance.

    Jaggerdude60 pointsBadges:
  • mssql login script

    Hello, Can anyone give me a simplet powershell script to check login attempt to remote MSSQL database.For eg: if i have a database "db" in remote sql server say 192.168.1.10 which having username"test" and password as "password".If the login is successful its output should shows as "OK" in...

    LINSONAJ5 pointsBadges:
  • Query Calculation Part of Select Criteria

    This query works great except I need to add one thing. There are two district codes that need to be included in the query. These codes just need the MC_Tax_Amount field totaled - no dividing by two. How do I add this to my query? Thank you, SELECT "T16.CPRP".CP_DISTRICT_CODE,...

    lorit365 pointsBadges:
  • SQL Script with hyphen in the value set

    We have a particular piece of malware that will put some binary code in the HKLM/System/ControlSet001/Services/{5083B7D5-47AF-8FF9-657C651C2B10}/ I am using an sql script along with Microsofts logparser to parse some data out of the registry on a windows box and I am having trouble with the last...

    Markmorgan475 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