New answers tagged sql-server-2008-r2
-1
votes
why a convert from varchar do date fails on a different row everytime it runs?
Try this to move the year. it worked for me .
select cast(substring ( ugly_column_date, 5,8) + substring ( ugly_column_date, 1,4) as datetime) from ugly_table
0
votes
How export a sql server 2008 diagram to PDF filetype?
This is super easy and free to do in Windows 10+. Simply use the built-in Snipping Tool when viewing the Database Diagram by pressing Windows Key + Shift + S. Be sure to zoom in to an appropriate ...
5
votes
Applying Quotes Across Multiple Lines
To add to the excellent answer from Aaron, there is also a way to add characters at the end of multiple lines using keyboard shortcuts, even when those lines have different lengths. (If they have the ...
Top 50 recent answers are included
Related Tags
sql-server-2008-r2 × 3778sql-server × 2628
t-sql × 353
sql-server-2008 × 338
performance × 218
sql-server-2012 × 169
backup × 124
index × 111
replication × 109
permissions × 105
ssis × 95
ssms × 94
query-performance × 82
security × 74
restore × 71
sql-server-2014 × 70
transactional-replication × 69
sql-server-agent × 66
stored-procedures × 64
linked-server × 62
transaction-log × 60
mirroring × 57
database-design × 53
sql-server-2005 × 52
index-tuning × 49