database sql-server

I am wondering if there is any method available to implement event trigger based on time. Lets say i want to deleted/modify a record in a certain…

Hi I am trying to insert the guestpass type name in table guestpasstypes and at a time it will check the database whether the database has already…

I have a big file (3GB) containing a database dump. The file extension is "bkp", but it's only a uncompressed ascii file. Tables are descripted in…

I have my project A with mySql database and I have another project B with msSql. I have connected the database from A and fetched data from B. But…

I'm designing a small piece of software for a company. Basically, they need to manage a large list of items. Edit, delete, and so on. Basically, I'm…

I am trying to find a way to validate data in my columns using regex CHECK constraints but have so far only come across the LIKE keyword that has an…

If we have the same database schema in a database on Postgresql and on MsSql Server (table, primary keys, indexes and triggers are the same) what…

Is there any software that I could use to convert an ms sql database to mysql? I tested exporting the ms sql database using ms sql server management…

I'm trying to build an application so that the user can see table entries in a mysql database. I'm programming this in visual basic. How can this be…

hi all, this is my simple query written in ms sql server... now i need to convert this database to mysql... suggest me the simplest way to do…

I want to get data from our production server to my local development server for testing purposes. I was wondering if there is any way by which I…

Hi all, is mysql capable of managing the data for a site which holds lots of data (say with hundreds of millions of users)? which database would be…

I have a database being used by two different applications. Application1 will perform all the operations in the database. We do not have control on…

Is there a tool (open source / commercial) that can transfer structural and data changes between two databases residing on different Microsoft SQL…

I've got a production app running on Postgres, and I'm taking nightly dumps to a tar.gz file. I'd like to restore this dump to a separate SQL Server…

CREATE TABLE MemberProfile ( memberID, memberTypeID, aboutMeID, memberRegID, memberProfileSettingsID, lastLogin datetime, PRIMARY KEY(memberID) )…

I'm going to launch a website in a few days, and I'm thinking of having one front-end server, and one MySQL database server. And my question is, if…

Hello all, Preferrably MS SQL, I want to make the switch over from MySql. So I have this awesome customer who has 4 Excel Files. Each Excel file…

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 know that SQL Server can store a row's data at leaf level in a clustered index. I believe that PostgreSQL doesn't do this. If so, what is its…