JStarkl 0 Posted April 9, 2013 Share Posted April 9, 2013 Hello I use Evernote for SQL-Scripts a lot, but there is the problem that whitespaces are inserted everywhere in the code, is there a possibility to turn this off? Example: Original script:select top(10)que.text,(qst.total_physical_reads/qst.execution_count) as avg_reads,last_physical_reads as last_reads,qst.execution_countfrom sys.dm_exec_query_stats as qstcross apply sys.dm_exec_sql_text (qst.sql_handle) as queorder by qst.total_physical_reads/qst.execution_count desc After evernote "parsed" it - via copy & paste to evernote:select top ( 10)que .text ,( qst. total_physical_reads /qst . execution_count) as avg_reads ,last_physical_reads as last_reads,qst .execution_countfrom sys . dm_exec_query_stats as qstcross apply sys. dm_exec_sql_text (qst . sql_handle) as queorder by qst. total_physical_reads /qst . execution_count desckind regardsJürgen Link to comment
This topic is now archived and is closed to further replies.