Categories
aggregate database-cursor sql sql-server-2008 tsql

Merging data in a single SQL table without a Cursor

Categories
sql sql-server-2008 tsql

Add Column to Temp Table – ‘Invalid column name DECIMAL’

Categories
sql sql-server-2008 tsql

How can I do a SQL UPDATE in batches, like an Update Top?

Categories
sql sql-server-2008 tsql

Changing SQL Server 2008 recovery mode

Categories
sql sql-server-2008 tsql

how to use single quotations inside a transact sql statement

Categories
sql sql-server-2008 tsql

Can I use multiple “with”?

Categories
date sql sql-server sql-server-2008

SQL Server : get date with inparameters year,week,weekday

Categories
date sql sql-server sql-server-2008

need to calculate year,month and day for closing date

Categories
entity-framework linq sql-server-2008

Entity Framework: There is already an open DataReader associated with this Command

Categories
c# date sql sql-server-2008

SQL-Date-Question: How to get Yesterdays date in the following formatte