Register
Login
Register
Login
Search
Home
Applications
Content Management System
Custom DNN Modules
Business Directory
Restaurant Menu Manager
Custom Database Reporting
Distributor Locator
Gift Certificates
Date Time Calculator
Consulting
Design
Surveillance Systems
Business Links
Support
Knowledge Base
Contact
SQL Scripts
Support
/
Knowledge Base
/
Microsoft SQL Server
/
SQL Scripts
Snippets
Current Articles
|
Archives
|
Search
SQL Scripts
NO Image:
01
SQL Function to Lookup DNN Profile Values
DNN Expert
posted on February 01, 2021 15:20
CREATE FUNCTION GIBS_GetProfileElement ( @userID as int, @portalID as int, @ProfilePropertyName as nvarchar(100) ) RETURNS nvarchar(4000) AS B...
[Read the rest of this article...]
Posted in:
DNN
,
Stored Procedures
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
23
Disable DNN Popup Windows
DNN Expert
posted on September 23, 2020 06:19
UPDATE PortalSettings SET SettingValue = 'False' WHERE SettingName = 'EnablePopUps'
DNN Popup Windows
Posted in:
DNN
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
05
Remove any leading or following spaces as well as any carriage returns
DNN Expert
posted on December 05, 2018 08:05
UPDATE YourTable SET YourColumn = RTRIM(LTRIM(REPLACE(REPLACE(YourColumn, CHAR(10), ''), CHAR(13), '')))
Posted in:
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
20
Update NBrightBuy Image Path when upgrading from V2
DNN Expert
posted on December 20, 2016 06:08
-- Used this great tool (https://github.com/FabioParigi/NBrightBuyMigrate ) but ran into a problem with images -- Create a SP to verify the old strin...
[Read the rest of this article...]
Posted in:
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
23
Order By Domain Name from Email Address
DNN Expert
posted on April 23, 2016 05:09
SELECT UserID, Username, FirstName, LastName, IsSuperUser, AffiliateId, Email, DisplayName, UpdatePassword, ...
[Read the rest of this article...]
DNN Users
Posted in:
DNN
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
16
DNN Region Lookup
DNN Expert
posted on February 16, 2016 06:20
(SELECT [Value] FROM Lists where EntryID = (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT ...
[Read the rest of this article...]
DNN Region Lookup
Posted in:
DNN
,
Microsoft SQL Server
,
SQL Server 2008 R2
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
Page 1 of 3
First
Previous
[1]
2
3
Next
Last
Archives
Azure (1)
C Sharp - C# (37)
..private void function() (11)
CraigsList (0)
CSS (15)
DNN (56)
..Modules (21)
....Core Modules (6)
....Custom Modules (33)
..Resource Links (2)
..Skin Objects (2)
..Social (1)
DNS (0)
E-Mail (3)
IIS (3)
Malware (1)
Microsoft SQL Server (17)
..Azure SQL Database (1)
..SQL Scripts (15)
..SQL Server 2008 R2 (11)
..SQL Server 2014 (1)
..Stored Procedures (6)
Networking Problems (7)
Operating Systems (1)
..Windows 7 (3)
..Windows Server 2003 (1)
..Windows Server 2008 (2)
..Windows Server 2012 (2)
..Windows Vista (2)
..Windows XP (4)
PCI DSS Compliance (1)
SSRS (1)
Technology (138)
VbScript (3)
Web Design (7)
Web.Config (5)