SQL Tables

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,...

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. Software/Hardware used: SQL Server

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...

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

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...

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.....

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 Software/Hardware used: MSSQL

Getting specific values from a SQL table to the ComboBox

How do I get specific values from a SQL table to the ComboBox in the running mode?

recovery when using sql tables

Recovery or rollback procedure when using SQL tables on AS400

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 ....

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...

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

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 ...

Database Issues - Trying to prove that something has to be done

Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some...

sql update a column to remove a certain character

i have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. i want to be able to perform some calculation with the table but the '*' is preventing me from doing this. SO how do i update or alter the table so that i can remove the * and keep...

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...

split column

i need to take a column in my database and split it into different columns based on a question id. Basically i want to write a whole bunch of sql statements that are non related for one grid - a whole bunch of sql statements each with their own where statement

SQL Server 2005 Select Multiple views or Tables

in SQL 2000 it was easy to cntl-right-click and select multiple views, stored procedures or tables and generate one script which could be changed (using SQL Analyzer) to create new objects (search and replace text) with different names. This was a big time saver but I don't know how to do that in...

table row values for column headers

Hi. I have two tables in a simple database: Prices ID (int, identity, PK) Year (smallint - year of value) Quarter (smallint - year quarter 1-4) Area (smallint - FK to Areas.ID) Index (float) Areas ID (int, identity, PK) Name (varchar) So, as you can see, the Prices table contains price...

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...