i am trying to rename a table which is in ms Access file and i am sending a sql query through the oledb.command and the syntax i used is Rename 'table_original_name' as 'table_new_name' it show an error that invalid sql server what is the way or synax to rename the table which is in the MS Access File
View 3 RepliesI'm importing a .csv file into my SQL Server (2005) using SSIS on a schedule, after its imported I would like to change the name of the file. The name of the imported file is always different as its coming from an external source.Is there anyway of changing the table name?
I've looked at using the stored procedure sp_rename, i.e.
Code:
USE TESTDATABASE1
GO
EXEC sp_rename 'dbo.SalesTerr5673A1889', 'Values';
GO
What I would like to use is a wildcard?
Assuming that an x64 version of ADOX is not available, how do I rename a Microsoft Access table from an x64 WinForms app using an OleDbConnection with the Microsoft.ACE.OLEDB.12.0 provider?
View 5 RepliesThe database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
i should say hi experts :D . Help me with this pretty code :)
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
I have a query that I have to run that requires me to get rows from a table based on the value of a field in another table (which I have gotten earlier). I currently have it done like this (simplified).
[Code]...
My problem is with the tickets table, I have listed the user that created the ticket, the tech who will solve the ticket and a user that over sees the ticket. All three users reference the users table. So how do I can I query the tickets table and get all three users that reference the same table storing the users?
Table1: Tickets
1) Ticketnumber
2) EnteredBy User 100
3) Issue
[code]....
What I can do now is something like this:
Select Ticketnumber, EnteredBy, Issue, UserName FROM Tickets INNER JOIN Users
ON Tickets.EnteredBy = Users.UserID
I am trying to automate an access table make query through vb.net.It works fine the first time, but the second time it fails because the table already exists.Of course i can delete the table through code by it's name, but i want to let my .net-application find out wich table must be deleted. Or maybe there is a solution that doesn't fail with the error "table exists" without first deleting it.[code]
View 1 Replies[Code] my issue is that now i need two cases, first i need a query that will return the date created and modified of the table and i also need to know if its possible to query a list of table names in the database ordered by date created but that have a certain thing in their names. for example the database contains the following tables: [Code] and what i need the query to return is the tables that contain "Data", settings and employees are for the other functions of the program. so the query should return the 4 data tables in order of date created. but i have no idea how to go about doing that in the query, does anyone know how this is done?
View 6 RepliesI really need your help. I want to query in a table in MS SQL using a data in another table.This is the query I've constructed : "SELECT TABLE1.FIELD1,TABLE1.FIELD2 FROM TABLE1, TABLE2.[code]
View 1 RepliesI have a table (Projects) which is linked to projectVersions on projectID..projectVersions contains several columns on which I'd like to filter a returned project (and associated projectVersions) list. For example there is a "capacity" column and a "country" column. I am doing a filtered list of projects on one page and I'd like to include all projects where any one of the associated projectVersions has a capacity of 750ml and a country of "France" for example.It may be that a particular parameter is not set and so I pass a zero to indicate not to filter on that.I guess this needs some kind of subquery as when I try and do something like this: [code] it doesn't work as the "xxx" bit, being one-to-many, expects me to specify an item to get at the entities within and yet I want to query where ANY of the associated versions match one of the criteria.
View 1 RepliesI am using visual studio 2010 to create a form where you can edit,delete, or insert data from an accessdatabase. When I try to run the form in a web browser I get the error "Query input must contain at least one table or query." I believe that the problem lies with my code/syntax but I am unable to determine the cause of the problem.
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/database.accdb" SelectCommand="SELECT * FROM [database]"
DeleteCommand="DELETE FROM [database] WHERE ([EmployeeID] = @EmployeeID)"
[Code].....
I have Access as my back end. Student is the database name and its path is c:Projectstudent.mdb And am having few tables in it. When i click a command button in vb.net a new table must be created in the path mentioned. And it should have the fields I declare. What s the query I need to use ? Is it possible to do like that ?
View 2 RepliesDim tbl as String = Request.QueryString("tb") 'tb value = User
Dim sql As String = "Select * From @table Where @Col = @ColVal"
Dim para As New SqlParameter
[Code]....
what should I do to run the sql with given table name as parameter and avoid the sql injection.
I am starting with Linq to SQL in VB.NET, and trying to figure out how to make a simple query to a database.I want to do it all programaticly.I have made a connection to the database with a connectionstring, and this works fine - I can get a message if the database exists or not.But when I want to query a table, I am missing the part where I connest to the table. I have googled a lot to find an answer for thi, but [code]
View 2 RepliesI'm using Vb2005 to hit a SQL server. i have a pretty complicated query that hits identically structured databases on the server. I was looking into parameterizing the FROM clause but cant seem to do it.[code]Depending on the users needs I will hit the 'DriverDb' or the 'MaintDb' or 'DispDb' databases. the SQL string is actually much more complicated than that with references to the db in about 5 places so wanted to simplify it so that i could just replace with a parameter.
View 2 RepliesI am trying to run this query to fill a temp table.It worked once, I am not sure why it won't load anymore.. Care to take a look?
[Code]...
I was able to use it for querying out info from an XML file but now i have to use the DBF file from a folder. where i can find out how to query out DBF table using LINQ. I basically need to get data from a column of a DBF table.
View 2 RepliesIm a noob to sql query ,can anybody point to what table would be returned from ths sql Query. [code]
View 1 Repliessuppose we have three tables in the Database:
[Code]....
[Code]....
It is returning all the columns by id. I need only the primary key. When I add the following line it is empty: WHERE SIK.indid = 1 Why is that? Is there other ways to do the same thing and working? Since I am in the rush
I have a query called qryimportpatients which has fields name, region, DOB and have a table called tblprojectpatients which has the same fields in sql database. On my VB.Net form I have button (Copy Data), which when I click I want to copy all the data from qryimportpatients to tblprojectpatients.
View 1 RepliesI have a query called qryimportpatients which has fields name, region, DOB and have a table called tblprojectpatients which has the same fields in sql database. On my VB.Net form I have button (Copy Data), which when I click I want to copy all the data from qryimportpatients to tblprojectpatients.
View 9 RepliesI am working with Vb.Net 2005 and sql server database.
I have a query in sql database (qryImportpatients) - it has 4 fields: prac_no, prac_eid, pat_name, pat_yr.
I have a table in sql database (tblProjectpatients) - it has 5 fields: Project_ID, prac_no, prac_eid, pat_name, pat_yr.
Now on my form in VB.Net - I have a textbox (txtProjectID) which has a numeric value. I want to have a function which when called will insert all the datafrom the 4 fields from qryImportpatients to tblProjectpatients and also insert the numeric value (ProjectID) besides each record.
how to select multiple table in vb2010? i trying to create a login so i need to retrieve the data in 3 different tables in one database i have a code but not work.[code]
View 2 RepliesDo you just need to format the date? Such as msgbox(New Date(2010, 1, 1).ToString("yyyy-MM"))
Or do you need a hashtable:
[Code]...
I am new in VB.NET. Can any tell me how a richtextbox query MySQL table. i.e select * from table test where name= 'Bowser' then the richtextbox will display the results.
View 3 RepliesI have 3 textboxes and need to search differently for each of the textboxes. For example textbox1.text is searched in column ans1, textbox2.text is searched in column ans2 and textbox3.text search in column ans3 in table Answer. is there any sql query that can do the search in one button click event.
View 3 RepliesMy following code is only retrives number month(1,2,3,4....12)and not month name(January,February,.....December).Before that i had try using function datepart, Monthname and date_format but i still din get my answer.[code...]
View 3 Repliesive been learning Vb.net at uni. Ive never used it before and im finding it a little difficult ( supposed to be easy )i usually code in c++ and MFC Problem I have craeted the database and added all the fields to the form.
View 3 Replies