Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server-2008

Inserting a ROW at the end of a query with Totals for SUM columns

How to find list of databases on Microsoft Analysis Server(SSAS)

sql-server-2008 ssas-2008

SQL - How to count records for each status in one line per day?

"Invalid use of a side-effecting operator 'OPEN SYMMETRIC KEY' within a function." error while opening a symmetric key

Why Sql Conditions (not in , not like , !=) not working on varchar value of table

How to drop all tables except 1

How to convert datetime string without delimiters in SQL Server as datetime?

Why doesn't SQL Server fail when the result of an UPDATE is ambiguous?

how to retrieve thousands of rows from a stored procedure efficiently

Optional where clause / parameter in a SQL 2008 stored proc?

SQL query that'll rollback if any statements fails

Database schemas WAY out of sync - need to get up to date without losing data

Possible to have an OrderBy in a view?

How to check if a client has SQLNCLI10 provider installed when browsing?

BIDS - SSIS - Redirect row on Error sends too many rows

sql-server-2008 ssis

SQL 2008 R2 - Time-Based Triggers?

How to auto Shift primary keys to start from 1 again

how to set column value equal to row no?

SQL Server EXPLICIT mode with FOR XML

database email with attachement(excel file / pdf file)?