how to write data in different tables of same database in sql server using labview at same time.

[parii]

hello every one 

plz tell me how to add data in two different table in a database at same time

[Sam_Sharp]

Have you tried it? I seem to remember that the SQL Server ODBC connector supports multiple queries in a single statement (separated by a semicolon ';') so you can just put two insert queries into a single request to the server.

Failing that, you could write a stored procedure which takes your data and inserts it into the two tables.

[parii]

yes .i tried it using database connectivity tool but it show error " no of columnsare not equal to parameter".

[Sam_Sharp]

Yeah, you won't be able to do it using the insert VI from the DB toolkit - you'll need to execute a custom (parameterised?) query that does one of the options I mentioned in my first reply.

Why do they need to be inserted at the same time? Can't you insert into one table and then the other immediately afterwards?

[parii]

i don't know how to get it done with qyeries.can you provide me example.

yeah it  be written one after another.please guide.

[Sam_Sharp]

If it can go in one after another, why not use the INSERT database VI multiple times - once for each table?

For the query - it's just a basic SQL query - "INSERT INTO tablename (column1, column2, column3) VALUES (value1, value2, value3);" If you want, you can create a parameterised query using ? instead of value1 etc. and then use the bind parameter to assign your values to the query parameters.

[parii]

ACTUALLY I WANT TO USE THIS VI I N A POP UP WINDOW .what i want is ..