|
|
-
Brad Schulz Learned 2 Years ago through Just Learned
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...
|
-
Brad Schulz Liked 2 Years ago through Just Learned
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...
|
-
Brad Schulz Learned 2 Years ago through Just Learned
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...
|
-
Brad Schulz Liked 2 Years ago through Just Learned
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...
|
-
Brad Schulz Liked 2 Years ago through Just Learned
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
|
-
Brad Schulz Commented 2 Years ago through Just Learned
One alternative: You could put an OPTION (RECOMPILE) hint on your ad-hoc query and it would NOT be cached....
|
-
Brad Schulz Commented 2 Years ago through Just Learned
One alternative: You could put an OPTION (RECOMPILE) hint on your ad-hoc query and it would NOT be cached....
|
-
Brad Schulz Commented 2 Years ago through Just Learned
One alternative: You could put an OPTION (RECOMPILE) hint on your ad-hoc query and it would NOT be cached....
|
-
Brad Schulz Commented 2 Years ago through Just Learned
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...
|
-
Brad Schulz Commented 2 Years ago through Just Learned
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...
|