|
|
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 March 17, 2011 06:12
When running a named instance of MS SQL the instance will run on a port other than the usual port 1433. To determine the port you can use th...
[Read the rest of this article...]
DNN Expert posted on January 09, 2011 07:26
INSERT
[dbo].[Farming]
(
[First Name]
[Last Name]
Title
[Mailing Address]
[Mailing City]
[Mailing Province/State]
[Mailing Postal/ZIP]
We...
[Read the rest of this article...]
DNN Expert posted on December 20, 2010 07:52
This topic explains how to create a new database from an existing full database backup.
Security Note
...
[Read the rest of this article...]
DNN Expert posted on April 30, 2010 05:15
Add the helper SPLIT function to your database
CREATE FUNCTION dbo.Split
( @List nvarchar(2000), @SplitOn nvarchar(5) )
RETURNS @RtnVal...
[Read the rest of this article...]
SQL,
FUNCTION
DNN Expert posted on March 12, 2010 08:31
PROCEDURE GIBS_SEO_Content nvarchar(50) = null
AS
BEGIN
if
(len(@city)=0)
begin
set
@city=null
end
SET NOCOUNT ...
[Read the rest of this article...]