Microsoft SQL Server

Snippets


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:
03
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()
06
Set font to Wingdings . . . . Expression:  =IIF(Fields!Parishioner.Value,chr(254),chr(168)) SSRS
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
24
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
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
24
Get a list of the database names and database size in a sql server instance using tsql: EXEC sp_databases sp_databases
Page 1 of 3First   Previous   [1]  2  3  Next   Last