• T-sql date question

    Does anyone know how I can convert 2005-09-14 09:49:13.873 to 2005-09-14 00:00:00.000 in a query?

    Kritchard0 pointsBadges:
  • Receiving a DOS output with a Visual Basic script in SQL

    I would like to solve this following complex script in SQL by using Visual Basic, either version 5.0 or 6.0. My first table name is tblClient, with fields ClientID and ClientName. My second table name is tblPurchase, with fields ClientID, Item Name, Qty and Price. I would like to pass one SQL query...

    SQL Server Ask the Experts2,585 pointsBadges:
  • how to view data in gridview with a sqldatasource

    hi , i m amit i want a help to view datasource and grideview,when i make connection in datasourse and use this connection in gridview and run it page can not display gridview structure. plz help me

    Amitshukla60 pointsBadges:
  • Unable to open a SQL application on two different machines

    If someone in our office opens a SQL application, no one else is able to open it. We all receive the message: “Another application is using this file.” How can we solve this problem?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL File Member Can SQL on i allows users to select a specific member to be processed without using a OVRDBF command

    Cqn SQL on i allows users to select a specific member to be processed without using a OVRDBF command

    Cragrat5 pointsBadges:
  • Definition of the withGrant parameter in SQL

    When giving permissions to database users in SQL, what does the withGrant parameter do?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Duplicate Sql

    Hi, I want to know in a given PL/SQL Procedure or PL/SQL Function How to find the duplicate(i.e., Repeated) SQL Statements. regards, aditya.

    Garimella5 pointsBadges:
  • Access databases

    I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?

    Michaelrdowney10 pointsBadges:
  • can a file be loaded from an embedded sql statement?

    can a file be loaded from an embedded sql statement? I want to use the file that was loaded to display the data in a subfile.

    Cansler50 pointsBadges:
  • Backup/Restore a DB from Microsoft SQL Enterprise Manager to SQL Server Management Studio Express

    Hi Is it possible to copy a DB from a server that has a genuin SQL Enterprise Manager to a server that has SQL Server Management Studio Express installed? Both servers are on the same net. I get following error when trying: Restore failed for Server 'PROGTST\SQLEXPRESS'....

    Lissy5 pointsBadges:
  • how to get database name?

    hi i am using th sql statement "SELECT * FROM MASTER..SYSDATABASES" but i want for perticular username and password

    Shwetha20 pointsBadges:
  • SQP file members

    Does SQL on AS400/iSeries allow selecting a specific member to be prcesssed without using a OVRDBF command?

    DMinNC10 pointsBadges:
  • Problems with the SQL query function

    I am designing a website, and I’m having a problem with the SQL query function. My table looks like this: Table Structure Ref_ID Mem_ID 1001 1002 1001 1003 1001 1004 1002 1005 1003 1006 1003 1007 1003 1008 When I try the command “select * from table where ref_id='1001',” it returns 1002, 1003...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Why sqlcode error=100 comes ?

    sqlcode error=100 comes. The required fields are being populated in table. Still why i am getting this error ?

    NAVIN5 pointsBadges:
  • SQL insert statement

    Hopefully there are some ASP experts put there who can help me. I am trying to write an SQL insert statement to populate an access database from an HTML form. When I submit the form, I am getting page cannot be displayed with the following error message: Error Type: Microsoft VBScript compilation...

    Sturdy2725 pointsBadges:
  • SQL

    I have some duplicate rows in my SQL database table, Please Tell me how'll delete duplicate

    Badrugts5 pointsBadges:
  • SQL Subfile and position to ability

    I have a subfile that can be sorted by any of 4 fields, so I want to use imbedded SQL to read the data out of my PF in order to populate the subfile. I want to be able to allow the user to enter position to information, and position to that entry - normally, I would do a SETLL to the file based on...

    Klw50 pointsBadges:
  • How do I control the library list that is in affect on the remote system using SQLPKG?

    In using SQLPKG, I believe my program is running blind on the remote system. How do I control the library list that is used when the SQLPKG is run?

    Tacobell6120085 pointsBadges:
  • How Do I Fix A Implicit conversion Error

    I got the following error on the first line and I'm not sure why. The appropriate fields in both tables (oas_balance and oas_testit) have the same data-types. Could it be an out of order thing? ERROR: Implicit conversion from data type varchar to money is not allowed. Use the CONVERT function to...

    Ilfoprog50 pointsBadges:
  • free software for measuring disk I/O

    Hi, any recommendations for a free software to: Measure disk I/O & SQL Server statistics from many server at once + make graphs of the data?

    Milkyway5 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