Microsoft SQL Server

Snippets


Microsoft SQL Server

 

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
08
Try running . . . . exec sp_updatestats; SQL, DNN
12
COALESCE (Transact-SQL)
Page 1 of 3First   Previous   [1]  2  3  Next   Last