SQL Scripts

Snippets

 

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
16
Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems SQL
12
COALESCE (Transact-SQL)
05
ALTER TABLE MyTableName ADD CONSTRAINT DF_MyTableName DEFAULT GETDATE() FOR MyColumnName SQL, Alter Table
Posted in: SQL Scripts
21
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...]

12
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
27
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
10
Here's a great sql script to use for the DotNetNuke Reports Module: Select --   AU.Username,    U.FirstName,   ...

[Read the rest of this article...]

Page 2 of 2First   Previous   1  [2]  Next   Last