SQL Scripts

Snippets


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
16
  (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
04
Declare @PortalId int; Set @PortalId = 0; SELECT 'OwnerFirstName' = U.FirstName, 'OwnerLastName' = U.LastName, 'OwnerEmail' = U.Email ...

[Read the rest of this article...]

DNN Region Lookup SQL
Posted in: DNN, SQL Scripts
15
I had a need for getting a property details for a SSR report and came up with the following store procedure  . . . I thought it might be useful t...

[Read the rest of this article...]

Ventrian Property Agent
Page 1 of 3First   Previous   [1]  2  3  Next   Last