• Would using a table variable from a function be efficient?

    We divided our tables from table zone_a, ..._b, ..._c to zone_z, these tables have the same attributes. We have divided this tables in this way so that any data that is under zone_a would only be on it's specific table, and the same with the other remaining table. Since per table holds thousands of...

    C114020 pointsBadges:
  • How to Make Fixed Row Table

    Hi all My question is that i want to make the table which will accept only 500 row. even it could not accept 501th row. i mean to say i can't accept at the time of insertion not on fetch time

    DotnetDevoloper30 pointsBadges:
  • My as/400 SQL is getting a ‘ Value for column too long.’ error msg

    Value for column or variable SPDESC too long. UPDATE mbmtest01/wbmscur set spdesc = (Select itdsc FROM amflib7/itemasa WHERE itnbr = spptno)  WHERE EXISTS (SELECT DISTINCT itdsc FROM amflib7/itemasa WHERE itnbr = spptno)  How do I make the field truncate the larger input field. The input field is...

    nitzinger385 pointsBadges:
  • SQL record with latest date

    if there is one table with a id and names as cloumns and another table with the id and dates, if want to have a id, name and the latest dates as an id can have mulitple dates what would be the query

    Techybrains5 pointsBadges:
  • Retrieving data tables without backup SQL

    If I truncate a table without the backup of it, how do I retrieve the table data?

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

    Hi I am creating a database. In my legacy system I had what we called a tables system where coded data could be expanded into different values   eg 0 = No 1 = Yes I tried to create this in SQL by having a properties table and then relating the other tables to the property table. However this wont...

    Philsal25 pointsBadges:
  • two dimentional output

    I have a table. The structure looks like this: id(pk) year col1 col2 date 1 2008 50 60 feb09 2 2008 40 70 feb10 3 2009 60 80 feb23 4 2009 50 70 feb24 5 2008 40 80 feb26 I have no idea how to write a sql query to output a table which includes the latest of record of 2008, and the latest record of...

    Zhao5 pointsBadges:
  • How do I fetch synonym names with the SQLTables function in ODBC API?

    Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Effective ways for retrieving millions of records from a table?

    I have two tables -- [em]Users[/em] and [em]UserAddress[/em] -- with 30 million records in each.

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL related tables

    I have 2 tables one with all my products and their accociated details and another with comments on the products. Product table 1 prodID, title, description, price Comments table 2 commID, prodID, comment I would like to export this to a single XML file, thus an XML element for each product from...

    Geeko5 pointsBadges:
  • Diff. between PF and a sql table

    can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index.....

    Anky10 pointsBadges:
  • Getting last entries from two different tables

    Hi, I need to get the last entries from two different tables in MSSQL. I can get the last entry for one table by usung the following. SELECT * FROM dbo.Shaft_Scales WHERE dbo.Shaft_Scales.ID = (SELECT max(ID) from dbo.Shaft_Scales ID) The problem is adding another table. Please help

    GPNel200675 pointsBadges:
  • Error when insertin.g data into SQL table

                    I'm using SQL Server 2005 Express edition as the Database and Microsoft VB.NET 2005 as the programming language for my project. At the moment I'm having a problem of inserting data into one of the tables in my database through my VB.NET application. I...

    Obhasha0795 pointsBadges:
  • Aren’t correlation IDs ok in MSSQL for an UPDATE statement?

    I'm getting the following error with the attached SQL statment on MSSQL: UPDATE IMMUNE I

    DeloeranGuy55 pointsBadges:
  • recovery when using sql tables

    Recovery or rollback procedure when using SQL tables on AS400

    Ragenrags10 pointsBadges:
  • Convert column from Number(9) to varchar2(3) in SQL

    What is the quickest way of achieving a total column datatype change from number(9) to varchar(3)? I have a few million rows in this table and SQL will run forever ....

    GeoMar5 pointsBadges:
  • dynamic temporary table variable usage

    We have an sqr (running against a MS SQL Server DB), that references a dynamic temporary table variable in several begin-sql and begin-select statements. I am getting a syntax error in one begin-select statement where I can't resolve the problem. It occurs after the INNER JOIN on the...

    PaminBuckeyeLand15 pointsBadges:
  • when i print a work order in the application i need to update a field in a sql table to true

    when i print a work order in the application i need to update a field in a sql workorder table to true

    Tanjaatbrenlo40 pointsBadges:
  • Alter SQL table

    hi i have a set of data number | code 1 | abc 2 |ff 3 |aa 3 |bb 4 |cc 5 |dd 5 |ee and i'm wondering if there is a way to convert this data so it looks like number | code1 |code2 1 | abc |null 2 |ff |null 3 |aa |bb 4 |cc |null 5 |dd |ee thx

    Lazy16755 pointsBadges:
  • SQL 2005 SSIS Package to load table from positional flat file

    I have a positional flat file which I need to load contents into a SQL table. I've created an SSIS package and will need to call a VB script to parse the file but since I'm new at VB and SQL I need some assistance creating the VB script. There are 4 fields in the table I need to populate. The first...

    Dacker5 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