I have seen some videos from the Microsoft guys , who teach us how to change certain things in the Vista OS through Microsoft Visual Studio 2005 ??!! .... they say : it`s as simple as that .....
first of all, the columns are evaluated by exec, that's why in my table it updates the fields with the string +@nume+,...
and second, i can't concatenate values because i give the table dinamicaly.
that's what i'm asking, can it be done?
i declare the variables and serve them to the procedure...
i have a problem with dinamic sql, pls help
i want to dinamycally update a table from my database
this is the code i wrote so far:
declare @temp char
set @temp = Cast(@nr_crt as char)
declare @Result varchar (8000)
select column_name into #temp from information_schema.columns where...
i have a problem with dinamic sql, pls help
i want to dinamycally update a table from my database
this is the code i wrote so far:
declare @temp char
set @temp = Cast(@nr_crt as char)
declare @Result varchar (8000)
select column_name into #temp from information_schema.columns where...
Hallo , i have a small problem , i made a form page ,i made a drop down list wich has the AUTO-POST-BACK property, and i made a text-box wich has to be cleared at each POST-BACK , but i don`t know exactly how.Please help
can u please be a little more specific?
i have to create a procedure that accepts a table name (for ex my_table) and creates a new table with two columns: a column with column names of my_table and a column with program variables.
(not sure i can make it, but...)
then how do i asign to...
i need to update a table that i select dinamicaly
at update i need to acces the table's columns and asign eash a variable. here i'm stuck because i don't know how many columns the tables has, their names, and the variables i need to insert in them
-- if @a is the table that i imput
exec...
i can make a query to give me the table's columns, like this:
select * from information_schema.columns where table_name =@a
but i still neet to put variables in the columns
i know, that was very usefull with select statement, but at update i need to acces the table's columns dinamicaly.
that's what i was trying to find out
-- if @a is the table
exec ('update '+@a' set --in this set i must acces the table's columns and asign each a variable
yes, i want to make a procedure that accepts a table_name and table_name.id as argument and updates the other columns.
what i don't fully understand is what means dinamic sql, how does it works...
Can someone help me with an algoritm for updating a table imputed dinamicaly .
what steps do i have to take to find out the the tables columns , and update .
i want to make a query in VS2005 wich allows me to dinamicaly imput a table and a column , something like :
select * from @a where @b='something'
can someone pls help me with the sintax?
thank you
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.