|
|
Microsoft SQL Server
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.
NO
Image:
DNN Expert posted on November 03, 2020 11:20
Declare @todays_date Date
set @todays_date = CAST(SYSDATETIMEOFFSET() AT TIME ZONE 'Eastern Standard Time' AS date)
For example, if you wa...
[Read the rest of this article...]
Azure SQL GetDate()
DNN Expert posted on February 06, 2019 08:27
Set font to Wingdings . . . .
Expression: =IIF(Fields!Parishioner.Value,chr(254),chr(168))
SSRS
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
DNN Expert posted on December 24, 2014 06:33
To get this resolved you need to start you Internet Explorer as Administrator -> Run as Administrator then open the url http://<Server name>/...
[Read the rest of this article...]
SQL Reporting,
SSRS
DNN Expert 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
DNN Expert posted on October 24, 2014 05:57
Get a list of the database names and database size in a sql server instance using tsql:
EXEC sp_databases
sp_databases