Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

In T-SQL under MS SQL Server 2008, what does '@' mean in front of a parameter *value* that's a string literal?

How to atomically move rows from one table to another?

mysql sql atomic

XQUERY - How to use the sql:variable in 'value()' function?

MySQL Query - multiple WHERE clause on 1 column

mysql sql

Conditional sort order in SQL Server windowed function clauses

sql sql-server tsql

SQL Query for YTD, MTD, WTD totals

SQL server join vs subquery performance question

sql sql-server join subquery

Mutual Friend column, select a pair only once

sql

Audit for DISABLE/ENABLE Triggers IN SQL

Odd INNER JOIN syntax and encapsulation

sql sql-server inner-join

DISTINCT ON column only for non null values

Pause and resume running mysql query

mysql sql

How to implement a related articles algorithm using this form of collaborative filtering

mysql sql

MySQL combining records from two tables with join and without

mysql sql join

Run a console application from SQL Server after table update trigger asynchronously?

sql sql-server xp-cmdshell

How to get the arel table of a habtm association?

mySQL select random with probability

mysql sql

What's a good way to provide versioned rows in PostgreSQL? How to query them?

sql postgresql ddl

XML Data Type In SQL Server 2008 Query

sql xml sql-server-2008

Test stored procedure without affecting database