Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2008

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?

Command(s) completed successfully but... the tables are not created

Archiving Large Table (SQL Server 2008)

SSIS Script Component, Allow Null values

sql-server-2008 ssis null bids

How can I increment the value for each INSERT INTO iteration?

Create permanent table based on temporary table in SQL Server