I am doing the following to drop the sproc which works fine:
View Complete Post
Dear frdz ,
I have to create database in remote computer dynamically from TSQL.
Actually my requirement from a store procedure I have to create database in remote server.
Here remote server is dynamic…
I have all the TSQL statement for creating table & store procedure.
What is the best method for doing this?
we are creating a custom report tool, which could be used for generate the report as per end user's needs. In that we are providing an option as user could create a query and procedure as well.
In sql server we can use "EXEC" function for execute dynamic query.
Could anyone help me for create the dynamic query in Oracle?
I just tried with "execute immediate", which would throws error as
Please help me.
Please help me.
MSDN Magazine October 2004
I want to generate create table script using c#.net, I want to connect sql server 7.0 and generate table create script. Its urgent kindly help me urgently.
First time post here, if i'm in the wrong area please move as necessary. Thanks
I'm using VWD with a database back end. I have a list of teams which are marked off by league, level, division, teamid and then using gridview for the list of players per teams.
I've got the drop downs working correctly but running into a little snag and that is on the auto postback.
When I only have one option come up in a list, i obviously don't change that list and thus it doesn't change the next drop down because there is no post back. is there a way to use a "header" value?
Example of my data
League Level Division Team
NHL 1 West VancouverNHL 1 West CalgaryNHL 1 West EdmontonNHL 1 Central Chicago
OHL 2 West LondonOHL 2 West Guelph
NBA 1 Central ChicagoNBA 1 Central DetroitNBA 1 Central Milwaukee
So my drop downs choose by league, then level then division and then team then shows the player roster for that selected team.
The problem I run into is when only one value exists based on the previous choices I've made. If I choose NHL then Central only Chicago shows up in the example above. Because I'm not choosing between it and another value, the drop down does not put in a post back and thus I don't get a list of the team and then the players