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 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…

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…

I'm working with a SQL database for a Skills Matrix application and I need a query to return a list of employees that are qualified for a given…

I am trying to build a sql query that I think it involves inner joins, but I can't figure it out. Here's the model: There's two tables: comments,…

I have a SQL table gathering form results. I noticed after about 200 results had been gathered, that instead of the date being in the format of…

here is my database structure members table member_Id membertomshiptable membertomship_startdate membertomship_enddate member_id mshipstatustype_id…

The Microsoft website ( microsoft ) states The firewall must be configured to permit port 1433 incoming (or the port numbers that SQL Server listens…

I have SQL CREATE statements for MySQL. They have KEY , example : CREATE TABLE a ( a varchar(25) NOT NULL DEFAULT '', b varchar(20) NOT NULL DEFAULT…

I have a member Table with member_Id a mmship table with columns mmshipstart date and member_Id and mshipstatus_Id another table mshipstatustype…

We have an upcoming project that will be hosted via cloud computing, and we have the choice of Sun MySql Server, or Microsoft SQL Server as the DB…

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…

Consider the following MS SQL Server table: ID | X | Y ------+-------+------- 1 | 1 | 1 2 | 1 | 2 3 | 1 | 3 4 | 2 | 40 5 | 2 | 500 6 | 3 | 1 7 | 3 |…

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…

We have two physical servers on the different area protected by firewalls. We need to use DB Mirroring for our purpose. So which ports we need to…

I'm trying to do SELECT * FROM tbl , but out of 20 columns I don't want 1 particular column to be selected. Is there a dynamic way to do so? Just…

Is there any way to call a remote stored procedure on sqlserver from postgres ? I need to call a stored procedure that receive 3 parameters and make…

I'm migrating an MSSql database that has "sql_variant" columns to MySql database. What's the equivalent of this type in MySql world?

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 List in C# for my Winform application : List<string> StudentSubjects = new List<>(string); I have inserted these into List :…