Transact-SQL
TSQL challenges? This is the place for advice and discussions
Filtre et triUtilisez ces options pour affiner la liste des discussions.
- 7171

Are you a technology guru? Show us your solutions, win awards, become Guru of the Month!!
XAML guyMicrosoft Community Contributorlundi 20 mai 2013 10:24 - 535350

POSTING TIPS - source code, screen images, details within...
Phil BrammerMVPmardi 1 décembre 2009 22:19 - 054008

Solutions to Common T-SQL Problems
Arnie RowlandMVPsamedi 12 avril 2008 14:52 - 04

SQL Backup Incomplete
J P IT il y a 4 minute(s) - 20115

If Statements not evaluating correctly.
IT Dept GAC il y a 4 heure(s) et 52 minute(s) - 10111

Minutes between two dates excluding holiday's and outside work hours
reddy5511 lundi 20 mai 2013 17:12 - 216

CREATE PROCEDURE - Learning tSQL
PavilionWI il y a 19 minute(s) - 121

Conditional Joining tables based on param value
ace_hk il y a 28 minute(s) - 248

Trigger
Muhammad Saad Ch il y a 3 heure(s) et 50 minute(s) - 7123

TSQL 2008 R2- To condense the table by forming groups without Cursor logic
Aniketm il y a 13 heure(s) et 53 minute(s) - 546

Msg 102, Level 15, State 1, Line 17, Any Help is very much appriciated
viveknj il y a 2 heure(s) et 14 minute(s) - 382

Alter column in a compressed table takes long time
Christa Kurschat il y a 12 heure(s) et 33 minute(s) - 426

Need a faster way to handle a massive IN clause
JWM1981 il y a 1 heure(s) et 24 minute(s) - 225

Update one table from another table in another database
JR Hughes il y a 1 heure(s) et 22 minute(s) - 8132

Looking for simplest method to output a CSV with a title row (not a header row) and footer row
SQL Server dude il y a 21 heure(s) et 24 minute(s) - 6155

Remove data (truncate/delete) on tables and Load data SQL Server 2008 R2
SQLDBA321 lundi 20 mai 2013 01:32 - 347

I need a quick simple primer on retrieving XML data.
falcon00 il y a 3 heure(s) et 5 minute(s) - 139

Writing dinamically the table for a select inside a stored procedure - SQL Server 2012
pscorca il y a 2 heure(s) et 0 minute(s) - 9112

datetime datatype performance issue
ione721 il y a 21 heure(s) et 21 minute(s) - 241

Different SUM()'s based on different WHERE -- use subselects?
rick7072 il y a 3 heure(s) et 12 minute(s) - 236

please explain code
kconwaycole il y a 3 heure(s) et 41 minute(s) - 674

Active transaction
simonxy il y a 5 heure(s) et 56 minute(s) - 238

Get joined rows with temp table?
SearsKM il y a 3 heure(s) et 41 minute(s)

