Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2008

How to use OUTPUT to capture new and old ID?

Selecting most recent answers efficiently

Getting Count and Rows in same query

sql sql-server-2008

Select only distinct values from two columns from a table

MSSQL Totals per day for a month

Select distinct and group by on subset of columns

Ignore date list from CTE

INSERT a row only with default or null values

QUALIFY-Like Function in SQL Server

Change the name of columns after they became rows values in unpivot query SQLSERVER2008

Recommended approach how to modify schema of a production SQL database?

how can I delete date in this table?

SQL Custom Order By

fastest way to update varchar column with text

Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot

Query to find out if foreign key is referenced anywhere else in the database

Delete duplicate rows and keep one row

An insert exec statement cannot be nested

sql-server-2008

SQLBulkCopy with Identity Insert in destination table

How do I decide if I should use a CTE or not?