Questions tagged [sql] - KnowledgeHub

219

votes

13

answers

Select SQL Server database size

asked 2013-08-02T10:12:40.090

10

votes

2

answers

postgresql pgBench tool running user defined SQL script

sql postgresql multithreading benchmarking

asked 2013-08-01T14:38:23.617

12

votes

5

answers

Invalid Object Name Error in Function in SQL

asp.net sql sql-server

asked 2013-07-31T10:21:58.740

8

votes

1

answers

Mysql query to dynamically convert rows to columns on the basis of two columns

mysql sql pivot pivot-table

asked 2013-07-31T07:23:12.203

24

votes

2

answers

Setting a variable date in SQL

sql sql-server variables date ssms

asked 2013-07-30T20:05:55.803

15

votes

2

answers

MySQL - Where Or?

mysql sql where-clause

asked 2013-07-30T17:29:12.463

271

votes

5

answers

What is a SQL JOIN, and what are the different types?

sql join

asked 2013-07-30T11:48:12.387

11

votes

1

answers

What is the recommended max value for join_buffer_size in mysql?

mysql sql

asked 2013-07-29T15:43:35.813

10

votes

3

answers

Foreign Key constraints missing after phpmyadmin export

mysql sql phpmyadmin foreign-keys key

asked 2013-07-26T20:26:20.477

8

votes

3

answers

Convert rows to columns after counting

sql sql-server sql-server-2008

asked 2013-07-26T07:15:33.030

51

votes

8

answers

SQL ignore part of WHERE if parameter is null

sql database sql-server-2008 stored-procedures

asked 2013-07-25T06:36:12.553

8

votes

2

answers

How to speed up min/max aggregates in Postgres without an index that is unnecessary otherwise

sql performance postgresql

asked 2013-07-24T17:41:34.343

19

votes

5

answers

Finding the longest streak of wins

sql oracle-database oracle11gr2

asked 2013-07-24T15:52:12.697

10

votes

5

answers

Counting number of records for specific ranges sql server

sql sql-server coldfusion

asked 2013-07-23T14:38:21.840

35

votes

13

answers

Update one of 2 duplicates in an sql server database table

sql sql-server

asked 2013-07-22T09:23:00.560

53

votes

1

answers

SQL JOIN many-to-many

mysql sql join many-to-many

asked 2013-07-21T16:22:11.867

8

votes

4

answers

How to convert Float to Varchar in SQL

sql sql-server t-sql

asked 2013-07-20T09:54:44.127

11

votes

4

answers

Oracle Database import .sql file by command prompt

sql oracle-database oracle11g oracle10g oracle-sqldeveloper

asked 2013-07-18T12:14:10.593

29

votes

3

answers

Database structure for "customer" table having many orders per customer and many items per order

sql database sqlite

asked 2013-07-17T22:24:03.510

10

votes

3

answers

how to extract specific word from string in Postgres

sql postgresql

asked 2013-07-15T11:00:09.593

8

votes

4

answers

Exporting SQL Server Table to multiple part files

sql sql-server database hive bcp

asked 2013-07-13T16:51:08.530

12

votes

2

answers

Why select from multiple tables without join

sql

asked 2013-07-12T15:02:14.647

66

votes

5

answers

ORDER BY "ENUM field" in MYSQL

mysql sql enums sql-order-by

asked 2013-07-11T21:32:08.793

11

votes

7

answers

SQL Server Copying tables from one database to another

sql sql-server data-migration

asked 2013-07-11T00:03:49.267

27

votes

5

answers

Cannot Use ConfigurationManager inside Unit Test Project

c# sql unit-testing configuration mocking

asked 2013-07-10T20:41:41.237

124

votes

6

answers

How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?

sql select where-clause advantage-database-server sql-delete

asked 2013-07-09T12:56:30.283

9

votes

2

answers

SELECT TOP error

mysql sql database select

asked 2013-07-06T13:58:10.267

19

votes

3

answers

Could not allocate CursorWindow

android sql database sqlite android-cursor

asked 2013-07-05T19:30:03.707

255

votes

8

answers

Group query results by month and year in postgresql

sql postgresql datetime

asked 2013-07-05T15:18:24.213

14

votes

7

answers

SQL Server drop and recreate indexes of a table

sql sql-server sql-server-2008 sql-server-2008-r2

asked 2013-07-05T12:17:47.383

11

votes

6

answers

How to avoid Duplicate values for INSERT in SQL?

sql sql-server-2008

asked 2013-07-03T08:12:49.847

10

votes

5

answers

Store string with special characters like quotes or backslash in postgresql table

sql postgresql

asked 2013-07-03T06:46:51.247

14

votes

1

answers

Using window functions to LIMIT a query with SqlAlchemy on Postgres

python sql sqlalchemy

asked 2013-07-02T23:14:39.797

74

votes

1

answers

Optimistic locking in MySQL

mysql sql locking database optimistic

asked 2013-07-02T16:52:16.577

19

votes

5

answers

Hibernate SQL Query result Mapping/Convert TO Object/Class/Bean

java sql hibernate hibernate-mapping

asked 2013-06-28T01:44:57.283

11

votes

6

answers

Return rows in the exact order they were inserted

sql sql-server

asked 2013-06-27T14:21:20.703

40

votes

3

answers

How to give a unique constraint to a combination of columns in Oracle?

sql oracle-database constraints unique-constraint composite-key

asked 2013-06-27T12:43:08.430

9

votes

2

answers

ANY or IF EXISTS in T-SQL

sql t-sql

asked 2013-06-27T06:25:06.237

44

votes

6

answers

Check if a column contains text using SQL

sql sql-server t-sql

asked 2013-06-26T14:00:59.880

27

votes

11

answers

Using sql function generate_series() in redshift

sql amazon-redshift generate-series

asked 2013-06-24T18:20:04.323

18

votes

7

answers

Order By month and year in sql with sum

sql sql-server

asked 2013-06-24T08:44:22.817

10

votes

2

answers

Selecting specific row number in sql

sql sql-server

asked 2013-06-23T10:14:04.930

27

votes

4

answers

Replacing NULL and empty string within Select statement

sql t-sql

asked 2013-06-21T21:47:29.907

9

votes

2

answers

Linq to SQL, InsertOnSubmit vs. InsertAllOnSubmit performance?

c# sql linq linq-to-sql

asked 2013-06-20T09:19:16.653

9

votes

1

answers

subquery - how to refer to outer query value

sql sql-server subquery

asked 2013-06-17T04:15:46.087

27

votes

1

answers

Pass array literal to PostgreSQL function

php sql arrays postgresql parameter-passing

asked 2013-06-16T23:48:10.497

15

votes

6

answers

how to combine firstname and lastname in SQL and search with LIKE

c# asp.net sql

asked 2013-06-14T09:31:38.317

8

votes

1

answers

Powershell SqlCmd - Using result values without defining variables

sql variables powershell literals sqlcmd

asked 2013-06-12T18:40:49.443

64

votes

6

answers

My Select SUM query returns null. It should return 0

sql sql-server

asked 2013-06-11T15:44:08.333

18

votes

6

answers

Is it practical to have back-end (database side) validation for everything?

sql database

asked 2013-06-11T08:47:52.363

Questions tagged sql