SQL Scripts

Snippets


SQL Scripts

 

NO Image:
20
Clear all page level skins in a Portal update {databaseOwner}{objectQualifier}Tabs set skinsrc=null where SkinSrc is not null and PortalID=0 ...

[Read the rest of this article...]

Posted in: DNN, SQL Scripts
01
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...]

23
UPDATE PortalSettings SET SettingValue = 'False' WHERE SettingName = 'EnablePopUps' DNN Popup Windows
Posted in: DNN, SQL Scripts
05
UPDATE YourTable SET YourColumn = RTRIM(LTRIM(REPLACE(REPLACE(YourColumn, CHAR(10), ''), CHAR(13), '')))
Posted in: SQL Scripts
20
-- 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
23
SELECT        UserID, Username, FirstName, LastName, IsSuperUser, AffiliateId, Email, DisplayName, UpdatePassword, ...

[Read the rest of this article...]

DNN Users
Posted in: DNN, SQL Scripts
Page 1 of 3First   Previous   [1]  2  3  Next   Last