Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

openrowset for excel: can we skip several rows?

sql sql-server openrowset

SQL: Count number of columns in all tables, excluding views

sql sql-server-2005

Count number of rows that are not within 10 seconds of each other

mysql sql

Using a SELECT statement within a WHERE clause

sql select where-clause

View SQL prepared with sp_prepare

sql sql-server

create table permission denied in database 'master'

SQL Triggers - how do I get the updated value?

sql sql-server tsql triggers

Is it conceptually right to do a SELECT MAX(id) etc. for finding the last inserted row?

mysql sql postgresql

Find the Date range of week by current date in sql?

Oracle DB equivalent of on duplicate key update

sql oracle

How can I update top 100 rows in DB2

sql db2 ibm-midrange

union all with queries that have a different number of columns

sql sqlite

Selecting primary keys that do not have foreign keys in another table

mysql sql database one-to-many

Adventure Works Explanation

Wordpress update mysql table

mysql sql wordpress sql-update

Select columns with particular column names in PostgreSQL

date_sub ok with mysql, ko with postgresql

sql postgresql

Using pivot table with column and row totals in sql server 2008

sql sql-server-2008 pivot

Most efficient way to test SQL connection string availibility

Trigger to prevent Insertion for duplicate data of two columns