oracle sql-server

I have a bunch of products with a bunch of different possible attributes for each product. E.g. Product A has a name, size, color, shape. Product B…

I'm going to start a simple SaaS application and am considering which DB to go with(MSSQL, MySql, Oracle). Can someone who experience it(actual…

When using stored procedure is it faster to return a cursor back? or is it faster to use the out data parameter of the data type. or it really won't…

I am considering designing a relational DB schema for a DB that never actually deletes anything (sets a deleted flag or something). 1) What metadata…

Are there queries in other databases equivalent to Oracle's very useful ANALYZE TABLE.. ? I am looking for alternatives for the following Database…

Is there a way to fetch list of aggregate functions supported by a dbms using jdbc metadata or running any dbms specific query? Thanks in advance

I am trying to understand at a conceptual level , how are databases synchronized when they are largely distributed. eg a rail/airline reservation…

I have to do some logic based on the following implementation. I have a big number upto 36 Digits e.g. 913695089923267549815145223638290430…

I am trying to make a method for a class that will automatically insert a record into a table. The problem is that I need to make the code work for…

SQL Server: SELECT col1, col2,ROW_NUMBER() OVER (order BY col1) AS intRow FROM Table1 What is the equivalent code in Access?

How much we can extend the Oracle's Horizontal and Vertical Scalability (approximately). And how about HDFS (Hadoop Distributed File System)?? How…

For example, given 3 tables: gastropod snail slug and assuming we want to enforce that every row in 'gastropod' has exactly one corresponding row in…

I've been doing SQL for several years, and throughout all that time, my thought of joins was that of equivalence joins, as in select ... from t1…

Is it possible to make a library or dll that can be used in both MATLAB and any DBMS like SQL Server (with .net), Oracle, etc... I want to process…

I have a sql query that can easily return 70,000 rows of a relational database table (with a few joins involved). The total size of this resultset…

I'm a Java retread pretty new to C#. I'm hoping to stay out of trouble when I crank out a bunch of DML code in the next few weeks. I'm used to the…

What aspects should be considered to have a secure database?? Along with avoiding sqlInjection what else should be considered??? What is the NOT to…

Is there any site available online for verifying the syntax which conforms to multiple databases? For example: If I have a SQL statement with a…

Is there a general rule of thumb for designing databases to allow the columns as nulls vs 3nf normalization? I have a table with a column that will…

I'm trying to retrieve the Primary Key metadata for all tables in a database using ADO.NET 4. The GetSchema() methods let you pull down a lot of…