As a long time Toad for Oracle user, I have gotten used to hitting Ctrl+Enter and having just the statement under the cursor be executed. In SQL Server Management Studio, hitting F5 runs the entire script. To run just the current statement, I have to manually highlight the statement I want, and then hit F5. That is really annoying to m...
I have a product entity which has several classes (each product type has different fields with thousands of product types). One product class could be a hammer which would have fields of "handle length", "head weight", etc. Another could be a chair with fields of "cushion material", "box spring", etc. Customers add fields based on the...
I am new to Sql Server. One of the things that I am seeing is that I am writing a query in the top window and viewing results in the bottom window. The problem is that the result of the query takes up a lot of space vertically.. some queries take up a lot of space vertically. I want to see both the query and the query result side by...
I currently have a database with two tables called Articles and Tags . In order to allow articles to be in multiple categories i have a many to many relationship. Is it a mistake to have such a design in terms of performance? or should i remove the relationship between these two table and add a third table as a bridge (articlesTags)? ...
This answer is based on this answer. Cha uses arrays in storing login -info in contrast to my code. It likely improves the efficiency in searching the login -data and keeps your data organized. However, I am not sure whether this is the best data structure in storing all pieces of the login info. My solution always fetches passhash fro...
I beleive that ODBC has gotten to a certain point that makes it more reliable and queit portable. Needless to mention that there arent too many oppurtunities for Speed optimization if one should consider using a direct RDBMS API. In Addition, ODBC abstraction, to some sense, does make codes writing portable, having said that, Migrating...
I'm attempting to clean up data in this (old) spreadsheet and need to remove things like single and double quotes, HTML tags and so on. Trouble is, it's a 3000 row file with 25 columns and every spreadsheet app I've tried (NeoOffice, MS Excel, Apple Numbers) chokes on it. Hard. Any ideas on how else I can clean this thing up for import ...
Below is some example code of how I run my mysql queries, I run them through a function which I think would maybe simpliy switching databases. Below is an example of a mysql query I run and below that is the actual function. Would it be difficult to change to a different database type like oracle or some other if I ever decided to usin...
I have images stored in my database, when fetching these images I wish to know what the weight (20KB,90KB,etc.) per image is. How do I get this info? Thanks in advance. ...
I Just need to create table from a user to any user under the same DB. letz consider 3 Schemas. Schema_1,Schema_2 and Schema_3. schema 1 had DBA Privilege. Is it possible to table in SChema_2 or Schema_3 from Schema_1???? or we need to give this role "CREATE ANY TABLE" also ?? ...
i am working on a Windows Forms application using VB.net. It basically is an application made in vb 6.0 being upgraded to vb.net. Now i have an idea but i am not sure if it exists. Say i have a database (My_DB) and it has a table (item_details). I wish to make dataentry into the elements of item_details table which currently has 6 fiel...
This might be a duplicate (question) but I am looking specifically for the .NET best practise. How to store database connection strings, username and password etc. in a safe way? Is an encrypted app.config best in most cases? I would also like to be able to set the password in the config file and then have it encrypted as soon as the a...
When do you use which in general? Examples are highly encouraged! I am referring so MySql, but can't image concept being different on another DBMS ...
Recently I've asked a question about the best way to go to design a DB schema to support multiple types of users and interactions between them, one of the answers suggested that I use one table for each user type and Distributed Keys. The thing is the only databases I actively work with are MySQL and SQLite and I've always done this kin...
I am designing a new laboratory database. My primary data tables will have at least id (PK NUMBER) and created_on (DATE). Also, for any two entries, the entry with a higher id will have a later created_on date. I plan to partition by created_on to increase performance on recently entered data. Since the columns increase together, t...
When and Why does some one decide that they need to create a View in their database? Why not just run a normal stored procedure or select? ...
Hi, In many past projects, I observed that people tend to keep database column name as two or three words separated with '_', for example : first_name. However the same column is mapped to Java bean's variable : firstName. I don't know why people don't keep database field names like firstName but tend to use _ in between. Even if we us...
I have created a table and accidentally put varchar length as 300 instead of 65353. How can I fix that? example would be appreciated. thansk ...
I am trying to pull data from a single column from my database but I would like to make it come out alphabetized and in two columns. I have tried floating the list but it ends up looking like this: A_____B C_____D E_____F I would like it to look like this: A_____D B_____E C_____F ...
I'm trying to execute a statement like: UPDATE table1 SET name="Joe" WHERE id='1'; UPDATE table2 SET name="Bob" WHERE id='2' But, when executing the query, I get: Microsoft JET Database Engine error '80040e14' Characters found after end of SQL statement. It works when I execute the statements separately, though. So I'm guessing the...