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
- 1
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 ...
- 69.7k
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 ...
- 628
Top 50 recent answers are included