• Converting data field into hours, minutes, seconds.

    How do I convert a field in SQL 2005 from seconds to hours, minutes, and seconds?

    Tonya5 pointsBadges:
  • join tables with nested select count and group by

    hi i am having three tables : state, agencydetail, parentdetaills i am running following queries but i am getting wrong result plz help me out where is the problem select state.state,count(ag.agencycode) as registag,count(ff.agencycode) as reportag,count(inp.regno) as incpwait,count(interp.regno)...

    Bijendersverma5 pointsBadges:
  • Copying databases in SQL Server 2005 and SQL Server 2008

    In SQL Server 2005 and SQL Server 2008, the CREATE DATABASE function creates a new database and copies all the tables that are present in the model database. Is there a function where I can do the same from a template database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do i replace a sql tables field value with another value

    I have the following script that works in Access but not in sql. I trying to replace the the value in the field "RSAMSTORE" with another value I give it (i.e. 999994, etc.) when the data is displayed. In otherwords when the select distinct is ran instead of seeing the value in the table "RSAMSTORE"...

    Ilfoprog50 pointsBadges:
  • Explaining features in SQL Server 2005

    I have a presentation to give on business intelligence using SQL Server 2005. Can you assist me by explaining the features Data Integration, Data Analysis, Data Reporting and Data Mining in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Receiving an error consistently in SQL

    I receive the following error constantly in SQL: "Notice: Use of deprecated function sql_query in /var/www/html/includes/sql_layer.php on line 43 Notice: Use of deprecated function sql_fetch_array in /var/www/html/includes/sql_layer.php on line 64" It repeats over and over, and I am not sure how to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Automation of SQL Report

    Hi, I need to automate a certain report which we take from 2 different databases and paste the data in the Excel and send it to certain email IDs? can someone help me??

    Ramesh63635 pointsBadges:
  • Error In SQL SERVER DataBase

    am trying to insert four varchar(50) values in a table which is with a primarykey column id_number. i didnt check : "True" to the null field . so it should not allow null values in table. but while am trying . it allows null values. including primary key column. how is possible ? pls help me. i am...

    SrimanBenivolent5 pointsBadges:
  • How to setup for the SQL Database Mail to link with Exchange?

    How to setup for the SQL Database Mail to link with Exchange?

    Zur5 pointsBadges:
  • MSSQL service SQL service icon in the system tray does not have a green arrow on it

    I know Windows Sharepoint services with Windows Server 2000 installs SQL MSDE by default and the installation of same occurred successfully but how come afterwards the SQL service icon in the system tray does not have a green arrow on it instead it has a white filled-in circle and when I launch it...

    SAP Cum IT35 pointsBadges:
  • can VS 2005 support Oracle 10g?

    can VS 2005 support Oracle 10g data base? i need the MS Report service (SSRS) to be used to make report and the data base is Oracle 10g.please replay to me

    KPL5 pointsBadges:
  • Saving the results of a SQL Server 2005 table query in a XML file

    I have data in a table on a SQL Server 2005, and I need to query this table and save the results in a XML file that conforms to a given XSD. Is there an easy way of doing this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sp_OACreate is missing

    Hi I'm trying to create a stored procedure to send mail, and 1 line in my SP states: EXEC @hr = sp_OACreate 'CDONTS.NewMail', @MailID OUT But I get an error that sp_OACreate is missing. How it happened I don't know. But how do I fix the problem? Is it possible to recreate sp_OACreate manually?...

    Kowalski5 pointsBadges:
  • Complications in snapshot replication from a SQL Server database

    I have done snapshot replication from my SQL Server database to another SQL Server database. After completing the replication, the replicated data is not present in the other SQL Server database. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copy SQL Server Table

    How do I copy a table into the same database without including the data? Thanks ken

    Ilfoprog50 pointsBadges:
  • How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

    How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

    Deepanshu35 pointsBadges:
  • CASE sintaxis error in SELECT

    In the middle of a large storage procedure I have a working SELECT 01 (see below) which at a couple of points uses CASE statement. I need to expand the most inner CASE to get SQL Server check for several values instead of one. Currently CASE I am talking about looks like (it is in the middle of...

    Jzurbo775 pointsBadges:
  • Stored Procedure

    I am calling some stored Procedure, having selct statment, after inserting some a new data entry by different stored procedure. Some times my Select stored procedure does not return any value. Data is exactly correct and when I explicitly called that SP with same data by Query analyzer, I will got...

    Deepanshu35 pointsBadges:
  • SQL Server

    What is a tempDB in SQL Server?

    Sai5 pointsBadges:
  • The purpose of an “undo” file in SQL Server

    I performed a full backup on a development database (Full Recovery Model) in SQL Server, made some changes, backed up the transaction logs, made some more changes and backed up the transaction logs again. Now, when I restore the database using WITH STANDBY, it puts the database into a read only...

    SQL Server Ask the Experts2,585 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