Is there a way in MS-Access to delete the data in all the tables at once. We run a database in access, save the data every month and then delete all the data in access. But it requires deleting data from a lot of tables. Isn't there a simpler/easier way to do so? ...
I have three databases that all have the contents of several web pages in them. What would be the best way to go about searching all three and having the most relevant web page at the top of the search results? The only way I can think of is break down content by word count and/or creating a complex set of search rules to give one cont...
Anybody knows how to do this? I know there's a better way of loading XML data to Oracle without using SQL*Loader, but I'm just curious on how this is done using it. I have already a code that can load XML data to the DB, however, it wont run if the XML file has values that contain a CDATA... Below is the control file code which works ...
I have a table with 3 fields like this: ProfessorID StudentID Mark P1 S1 9 P1 S2 8 P1 S3 10 P2 S1 7 P2 S2 2 P2 S3 4 P3 S4 5 P4 S1 6 ...
Hi, I'm changing a database (oracle) with a script containing a few updates looking like: UPDATE customer SET status = REPLACE(status, 'X_Y', 'xy') WHERE status LIKE '%X_Y%' AND category_id IN (SELECT id FROM category WHERE code = 'ABC'); UPDATE customer SET status = REPLACE(status, 'X_Z', 'xz') WHERE status LIKE '%X_...
We have a database currently sitting on 15000 RPM drives that is simply a logging database and we want to move it to 10000 RPM drives. While we can easily detach the database, move the files and reattach, that would cause a minor outage that we're trying to avoid. So we're considering using DBCC ShrinkFile with EMPTYFILE. We'll create a...
Hello everyone, My question is how to assign the DataType value for columns of special SQL Types like, uniqueidentifier/nvarchar/datetime/varbinary(max) -- I did not find a mapping between .Net data type and such 4 types of SQL column data type? Here is a sample, which shows we need to assign the DataType (this sample maps .Net type to...
I have a table (readings) already connected by ODBC in Access that opens very quickly when I click on it. However, when I try to run this in VBA I it locks up and never displays anything: Dim strSql As String strSql = "SELECT readings.ids " & _ "INTO ids_temp " & _ "FROM readings " & _ "WHERE readings.ids > 12...
I have a batch of sql statements such as ... insert into.... ; insert into.... ; delete .........; etc When i try to execute them against oracle it gives me this error (ORA-00911 Invalid Character) now i can understand that this is because of the semicolon between the statements, i tried this on SQL Server and it worked but in Oracle...
I have questions regarding MySQL date and querying with it. First: SELECT * FROM post WHERE DATE(Post_Date)="2009-03-25" returns 0 results SELECT * FROM post WHERE Post_Date="2009-03-25" returns 71 results SELECT * FROM post WHERE Post_Date>="2009-03-25" returns 379 results I understand that the second query returning 71 ...
Im working on this large DB which has a lot of the business knowledge embedded in the SPs[I know!] and there is a lot of chaining between the SPs. i.e one stored proc calling another. Im want to find out a list of stored procedures which update a particular column. How would I do that. Using showplan_All as outlined in http://stacko...
I have a situation in which a CSV is uploaded to my application and each line essentially needs to be put into the database. I read each line and build a data table and then SqlBulkCopy that table up to a staging table. The staging table looks like this: UserID, GroupID, FirstName, LastName, EmailAddress I have three other relevant t...
In my current project I've been inherited with lots of long (1200+ lines) SQL Server stored procedures with some horrible indentation and formatting which makes them almost unreadable. Is there some tool that I can use to automatically format these and make them more readable? I don't want to go through it manually and indent it. ...
I am parsing RSS feeds with the format as specified here: http://www.feedparser.org/docs/date-parsing.html date tuple (2009, 3, 23, 13, 6, 34, 0, 82, 0) I am a bit stumped at how to get this into the MySQL datetime format (Y-m-d H:M:S)? ...
Can someone explain the implications of using "with (nolock)" on queries, when you should/shouldn't use it? For example, if you have a banking application with high transaction rates and a lot of data in certain tables, in what types of queries would nolock be okay? Are there cases when you should always use it/never use it? ...
Is there a way to get SSIS (<cough>hateit</cough>) to suggest the types on a flat file connection mgr from a destination table? So the problem is I have a largish table with lots of text fields and even when using suggest types, it will sometimes set the length of those fields smaller than the target column. That, of course, would be f...
I have a table with a couple thousand rows. The description and summary fields are NTEXT, and sometimes have non-ASCII chars in them. How can I locate all of the rows with non ASCII characters? ...
I'm a bit rusty when it comes to MS Access and I am hoping someone can help me out..... I have a list of all items that have been scanned (for purchase) by each store, by UPC for a one month period. I also have a particular group of UPC's that I want data for. What I want to get is the items that DIDN'T get scanned. Obviously, the it...
This is very similar to question 653714, but for MySQL instead of SQL Server. Basically, I have a complicated select that is the basis for several stored procedures. I would like to share the code across the stored procedures, however, I'm not sure how to do this. One way I could do this is by making the shared select a stored procedu...
I have an application that builds dynamic parameterized SQL queries. The following query returns an inner exception of "syntax error at or near "="... I am thinking it is in the way that I am assigning the parameter to the column name but, I'm not sure. Code follows. SELECT TOP 50 77 AS Repository, DocID, LastFileDate, ImageCount, Lo...