New answers tagged

-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
rachoo's user avatar
  • 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 ...
Hannah Vernon's user avatar
  • 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 ...
Mike's user avatar
  • 628

Top 50 recent answers are included