Multi-statement execution

Comments posted to this topic are about the item Multi-statement execution

The Value of Experience

Comments posted to this topic are about the item The Value of Experience

T-SQL

Comments posted to this topic are about the item T-SQL

A guide to recover a database out from Suspect mode

Comments posted to this topic are about the item A guide to recover a database out from Suspect mod…

Looping a select statement to return one table

Hi All, I am a C# developer who is learning T-SQL as I go. There may be a better way to do what I'm…

Need Help with the Error 'Subquery returned more than 1 value'.

How To Write An Interview Winning Resume

Comments posted to this topic are about the item How To Write An Interview Winning Resume John Sans…

Please Help on Trailing spaces

Hello, Can someone please help me removing the trailing spaces, leading spaces, white space, tabs, …

not getting rid of physical reads

We did not have proper indexes on production and almost all the queries were using clustered index …

How to uncommit the transaction and execute the next statement in the cursor?

Hi Friends, DECLARE @JurisID int, @CodedID int, @SrcCodeValueRef varchar(100), @SrcCodeDescr varc…

Create DML trigger for single table in SQL 2008 and send email alert to group

Hi, i have a requirement to Create DML trigger for single table ( check for any updates ) in SQL 20…

Logic problem in "SET [Quantity_Remaining] = [Quantity_Remaining] - 1"

Any ideas?... I have a trigger (not working obviously) set up that decrements from my [tblBulkPurch…

Why Don't We Have Better Practices?

Comments posted to this topic are about the item Why Don't We Have Better Practices?

COUNT() Function

Comments posted to this topic are about the item COUNT() Function

Code Reviews

Comments posted to this topic are about the item Code Reviews