Viewing 15 posts - 1 through 15 (of 67 total)
Great article. I modified it to cycle through 6 different color changes:
Public Dim Color As String = "#C6E0B4"
Public Function ToggleColor(ByVal PreviousTriggerColumnValue As String, ByVal CurrentTriggerColumnValue As String ) As String
If...
March 25, 2024 at 11:55 am
December 4, 2018 at 9:04 am
davidandrews13 - Friday, November 30, 2018 4:07 AMis it considered a currency symbol somewhere?
all these return 0.00select \
select £
select $
select ¥
select €
You...
November 30, 2018 at 7:52 am
Martin Bell wrote a good article and associated script for this:
I've used it several times successfully. One note: it does not work with replicated databases.
November 21, 2018 at 11:23 am
In TSQL, there is a function, OBJECT_DEFINITION(). It doesn't work with all object types however.
There is a SCRIPTER method in SQL Server plugin for Powershell.
August 6, 2018 at 9:43 am
hashbytes is contingent on data type:
select HASHBYTES('MD5','hello'), HASHBYTES('MD5',N'hello')
gives different results.
August 2, 2018 at 12:46 pm
if the " (double quotes) are not part of the column name try:
alter table A drop column "ALTER PROCEDURE [dbo].[AreaToEdge] @WKT VARCHAR(MAX), @SEARCH_DISTANCE INT, @MARGIN INT = 10/*********************************";
July 23, 2018 at 8:26 am
Are they members of more than one AD Group with database access?
June 4, 2018 at 1:11 pm
June 1, 2018 at 11:35 am
Decades ago, as part of a murder investigation, I was asked to pull all production and sales data for a product we manufactured. For days, I was reading old weekly,...
June 1, 2018 at 9:16 am
Worse yet is how it makes you feel, think, act, and react. Still working on always taking the "high road"...
May 15, 2018 at 9:14 am
If you're referring to SSMS, there is an export/import option for registered servers.
View > Registered Servers
right click the server/group
Tasks > Import/Export
May 14, 2018 at 1:24 pm
I had to change the path:
$datetime = Get-Date -uformat "%m%d%Y"
$path = "c:\temp\"+$datetime
#$path = "\\Lucy\ShareVol\FDB\Archived\"+[datetime]::Today.ToString('MM')+[datetime]::Today.ToString('dd')+[datetime]::Today.ToString('yyyy')
If(!(test-path $path)){
new-item -ItemType Directory -Path $path -Force
}
April 13, 2018 at 11:17 am
Will this work?
exec ('select ' + @Formula);
April 13, 2018 at 9:59 am
where are the line breaks? I ran it putting them where I thought they should go and got no errors...
April 13, 2018 at 9:32 am
Viewing 15 posts - 1 through 15 (of 67 total)