sql

Home » Archives for sql

How can I delete duplicate rows in a table

Tag: , ,

13 Answers

Can LINQ to SQL query an XML field DB-serverside?

Tag: , , ,

3 Answers

SQL Select Upcoming Birthdays

Tag: , ,

26 Answers

Is it possible to use the SELECT INTO clause with UNION [ALL]?

Tag: ,

6 Answers

MS SQL Server – When is a CURSOR good?

Tag: , , ,

9 Answers

How to check if a function exists on a SQL database

Tag: , ,

2 Answers

Script entire database SQL-Server

Tag: , ,

5 Answers

What is the best way to represent “Recurring Events” in database?

Tag: , , ,

6 Answers

Multiple INSERT statements vs. single INSERT with multiple VALUES

Tag: , , , ,

3 Answers

Using WITH NOLOCK Table Hint in Query Using View – Does it Propagate Within the View?

Tag: , ,

2 Answers

How to quickly edit values in table in SQL Server Management Studio?

Tag: , ,

3 Answers

Possible to use SQL to sort by date but put null dates at the back of the results set?

Tag: ,

3 Answers

What do column flags mean in MySQL Workbench?

Tag: , ,

1 Answers

How can I avoid NULLs in my database, while also representing missing data?

Tag: , , , ,

9 Answers

How to get last inserted id?

Tag: , ,

7 Answers

Subquery using Exists 1 or Exists *

Tag: , ,

6 Answers

postgreSQL group by different from mysql?

Tag: , , , ,

8 Answers

quick selection of a random row from a large table in mysql

Tag: , , ,

19 Answers

Singular or plural database table names? [duplicate]

Tag: , ,

13 Answers

How do I create a recursive query in MSSQL 2005?

Tag: , , ,

4 Answers

Import SQL dump into MySQL

Tag: , , , ,

3 Answers

PHP PDO bindValue in LIMIT

Tag: , , ,

4 Answers

Mysql – Alter a column to be AUTO_INCREMENT

Tag: , ,

5 Answers