Transact-SQL
TSQL challenges? This is the place for advice and discussions
Filtro e ordinamentoUsa queste opzioni per ridurre l'elenco delle discussioni.
- 272

We have the databases with restricted size and someone has changed the max size of the data files or may be created a new data file.
Ajay.G 23 ore 17 minuti fa - 12316

Is there a better way to write this SQL? - I wish to use something other than NOT IN.
lcerni martedì 14 maggio 2013 15:13 - 10134

Minutes between two dates excluding holiday's and outside work hours
reddy5511 lunedì 20 maggio 2013 17:12 - 264

Trigger
Muhammad Saad Ch 22 ore 26 minuti fa - 562

Msg 102, Level 15, State 1, Line 17, Any Help is very much appriciated
viveknj 20 ore 49 minuti fa - 3104

Alter column in a compressed table takes long time
Christa Kurschat martedì 21 maggio 2013 07:09 - 8152

Looking for simplest method to output a CSV with a title row (not a header row) and footer row
SQL Server dude lunedì 20 maggio 2013 22:17 - 6182

Remove data (truncate/delete) on tables and Load data SQL Server 2008 R2
SQLDBA321 lunedì 20 maggio 2013 01:32 - 362

I need a quick simple primer on retrieving XML data.
falcon00 21 ore 41 minuti fa - 9129

datetime datatype performance issue
ione721 lunedì 20 maggio 2013 22:21 - 257

Different SUM()'s based on different WHERE -- use subselects?
rick7072 21 ore 48 minuti fa - 252

please explain code
kconwaycole 22 ore 16 minuti fa - 693

Active transaction
simonxy martedì 21 maggio 2013 13:46 - 348

Update Statement not updating all hours
tmacdonaldmpower 22 ore 30 minuti fa - 4128

Return Empty String if any of all columns in select statement is null
Aarsh (MCTS) martedì 14 maggio 2013 15:04 - 592

Moving records - delete and insert in one statement, does this still need wrapped with a transaction?
shiftbit lunedì 20 maggio 2013 19:39 - 257

Partitioned view : Using check constraint on multiple columns
macfly67 23 ore 21 minuti fa - 5160

How to resolve deadlocks
Mark Roworth 3 lunedì 20 maggio 2013 15:47 - 7206

Trouble with query to aggregate values for filtering... do i need more sql skills or Cross Join, Cross apply, or Pivot/UnPivot
Rogge giovedì 16 maggio 2013 18:54 - 134826

Indexed View Issue - Error converting data type nvarchar to numeric
Wolfmeister sabato 7 maggio 2011 12:55

