Suppose you are maintaining some notes in a notepad on a daily basis and you want to add current date and time whenever you finish so that you can keep track of when notes are added. While working in a notead, Press F5 and it will insert current date an...

Suppose you are maintaining some notes in a notepad on a daily basis and you want to add current date and time whenever you finish so that you can keep track of when notes are added. While working in a notead, Press F5 and it will insert current date an...

Suppose you are maintaining some notes in a notepad on a daily basis and you want to add current date and time whenever you finish so that you can keep track of when notes are added. While working in a notead, Press F5 and it will insert current date and t

One alternative: You could put an OPTION (RECOMPILE) hint on your ad-hoc query and it would NOT be cached....

One alternative: You could put an OPTION (RECOMPILE) hint on your ad-hoc query and it would NOT be cached....

Just one word of warning... LEN() will not count trailing spaces, so the following will (incorrectly) return a value of 7: declare @string varchar(50) set @string='///xxx ///' select len(@string)-len(replace(@string,'/','')) /* Ret...

Just one word of warning... LEN() will not count trailing spaces, so the following will (incorrectly) return a value of 7: declare @string varchar(50) set @string='///xxx ///' select len(@string)-len(replace(@string,'/','')) /* Ret...

You could also do it this way: WHERE data LIKE '%\%%' ESCAPE '\'...

You could also do it this way: WHERE data LIKE '%\%%' ESCAPE '\'...

Let me know how it goes (if you're still alive)....