Register
Login
Register
Login
Search
Design
Consulting
DNN Apps
Content Management System
Custom DNN Modules
Business Directory
Restaurant Menu Manager
Custom Database Reporting
Distributor Locator
Gift Certificates
Date Time Calculator
Screenshot Gallery
TimeTracker
QR Code Maker
Surveillance Systems
Business Links
Support
Knowledge Base
Contact
SQL Scripts
Support
/
Knowledge Base
/
Microsoft SQL Server
/
SQL Scripts
Snippets
Current Articles
|
Archives
|
Search
04
SQL DNN Get User Profile with Region Lookup
posted on January 04, 2016 06:13
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
Actions:
E-mail
|
Permalink
|
Comments (0)
15
Pivot Query for Ventrian Property Agent
posted on December 15, 2014 08:22
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
Posted in:
Modules
,
Custom Modules
,
Microsoft SQL Server
,
SQL Scripts
,
SQL Server 2008 R2
,
Stored Procedures
Actions:
E-mail
|
Permalink
|
Comments (0)
16
Replace Null or Empty Value with String
posted on September 16, 2014 06:28
Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems
SQL
Posted in:
SQL Scripts
,
SQL Server 2008 R2
,
Stored Procedures
Actions:
E-mail
|
Permalink
|
Comments (0)
12
COALESCE (Transact-SQL)
posted on May 12, 2014 14:11
COALESCE (Transact-SQL)
Posted in:
Microsoft SQL Server
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
05
Alter Table - Setting a Column Default Value
posted on December 05, 2012 04:36
ALTER TABLE MyTableName ADD CONSTRAINT DF_MyTableName DEFAULT GETDATE() FOR MyColumnName
SQL
,
Alter Table
Posted in:
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
21
Updating DNN Module Skin Container via SQL
posted on December 21, 2011 06:24
DNN module skin container settings are stored in the TabModules table. Use the following SQL statement to reset all containers: update TabModules s...
[Read the rest of this article...]
Posted in:
DNN
,
Modules
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
12
Formatting a Short Date in SQL using Convert Function
posted on August 12, 2011 11:26
To format a short date like MM/DD/YY try the following: select CONVERT(VARCHAR(8), GETDATE(), 1) as MyShortDate For a complete guide to&nb...
[Read the rest of this article...]
SQL
,
Date
,
Convert
Posted in:
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
27
Quick Table Backup - SELECT INTO
posted on April 27, 2011 06:01
Syntax: SELECT field1 [ , field2 [ , ... ] ] INTO newtable FROM source field1 Is a parameter that specifies the list of the fields that are to b...
[Read the rest of this article...]
Posted in:
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
10
DNN User Login report SQL script for DNN Reports Module
posted on April 10, 2011 13:27
Here's a great sql script to use for the DotNetNuke Reports Module: Select -- AU.Username, U.FirstName,  ...
[Read the rest of this article...]
Posted in:
DNN
,
Core Modules
,
Microsoft SQL Server
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
Page 2 of 2
First
Previous
1
[2]
Next
Last
Categories
Azure (3)
C Sharp - C# (41)
..private void function() (11)
CSS (17)
DNN (63)
..Modules (23)
....Core Modules (6)
....Custom Modules (39)
..Resource Links (2)
..Skin Objects (2)
..Social (1)
E-Mail (4)
IIS (3)
Malware (1)
Microsoft SQL Server (18)
..Azure SQL Database (5)
..SQL Scripts (19)
..SQL Server 2008 R2 (11)
..SQL Server 2014 (1)
..Stored Procedures (6)
Networking Problems (7)
nopCommerce (3)
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 (2)
Technology (139)
VbScript (3)
Web Design (7)
Web.Config (5)
Archives
2025 (9)
2024 (12)
2023 (1)
2022 (1)
2021 (2)
2020 (16)
2019 (11)
2018 (8)
2017 (14)
2016 (14)
2015 (4)
2014 (26)
2013 (11)
2012 (15)
2011 (30)
2010 (157)