/* ------------------------ My Meta Content Here SEO ------------------------ */

Pages

Main Menu




Friday, December 19, 2014

Example Uses of the PARSENAME Function in SQL Server

Example Uses of the PARSENAME Function

The PARSENAME function returns the specified part of an object name.  The parts of an object that can be retrieved are the object name, owner name, database name and server name.  ThePARSENAME function does not indicate whether an object by the specified name exists.  PARSENAME just returns the specified part of the specified object name.
PARSENAME ( 'object_name' , object_part )
The  object_name parameter is the name of the object for which to retrieve the specified object part.  The object_part parameter, which is of int data type, is the object part to return and can have a value of 1 for the object name, 2 for the schema name, 3 for the database name and 4 for the server name.
DECLARE @ObjectName SYSNAME
SET @ObjectName = 'MyServer.SQLServerHelper.dbo.Customer'


SELECT PARSENAME(@ObjectName, 1) AS [ObjectName],
       PARSENAME(@ObjectName, 2) AS [SchemaName],
       PARSENAME(@ObjectName, 3) AS [DatabaseName],
       PARSENAME(@ObjectName, 4) AS [ServerName]


ObjectName  SchemaName  DatabaseName     ServerName
----------- ----------- ---------------- -----------
Customer    dbo         SQLServerHelper  MyServer
Sort IP Addresses with PARSENAME
One use of the PARSENAME is with sorting IP addresses.  Similar to a fully qualified object name, an IP address is made of 4 parts separated by a period.  Here’s an example on how to sort IP addresses using the PARSENAME function:
DECLARE @IPAddresses TABLE ( [IPAddress] VARCHAR(20))

INSERT INTO @IPAddresses VALUES ('10.0.0.1')
INSERT INTO @IPAddresses VALUES ('255.255.255.255')
INSERT INTO @IPAddresses VALUES ('192.123.545.12')
INSERT INTO @IPAddresses VALUES ('1.2.3.4')

SELECT * FROM @IPAddresses
ORDER BY CAST(PARSENAME([IPAddress], 4) AS INT),
         CAST(PARSENAME([IPAddress], 3) AS INT),
         CAST(PARSENAME([IPAddress], 2) AS INT),
         CAST(PARSENAME([IPAddress], 1) AS INT)

IPAddress
----------------
1.2.3.4
10.0.0.1
192.123.545.12
255.255.255.255
Split Full Name Into First Name and Last Name with PARSENAME
Another use of the PARSENAME function is to split a 2-part full name into first name and last name.
DECLARE @FullName VARCHAR(50)
SET @FullName = 'Donald Duck'
SELECT PARSENAME(REPLACE(@FullName, ' ', '.'), 2) AS [FirstName],
    PARSENAME(REPLACE(@FullName, ' ', '.'), 1) AS [LastName]
FirstName LastName
----------- ---------- 
Donald Duck
http://www.sql-server-helper.com/
Read More »

Thursday, December 18, 2014

Dynamically create mutiple users login in sql server

Dynamically create multiple users login in sql server by passing dynamic value



DECLARE @site_value INT;
DECLARE @login varchar(20);
DECLARE @password varchar(20);
DECLARE @Sql varchar(max);
SET @site_value = 0;

WHILE @site_value <= 3
BEGIN  
   SET @site_value = @site_value + 1;
   SET @login = 'user' + cast(@site_value as varchar(10));
   SET @password = 'password@' + cast(@site_value as varchar(10));
   SET @Sql = 'CREATE LOGIN '+@login+' WITH PASSWORD = '+''''+@password+''''+'';
   PRINT(@Sql)
   exec (@Sql)
END;

PRINT 'Done WHILE LOOP';
GO

Result

CREATE LOGIN user1 WITH PASSWORD = 'password@1'
CREATE LOGIN user2 WITH PASSWORD = 'password@2'
CREATE LOGIN user3 WITH PASSWORD = 'password@3'
CREATE LOGIN user4 WITH PASSWORD = 'password@4'
Done WHILE LOOP


Read More »

Wednesday, December 17, 2014

How to recover SA password on Microsoft SQL Server 2008 R2

How to recover SA password on Microsoft SQL Server 2008 R2


When you are using MS SQL Server in mixed mode, it is very important that you know your SA password.

There can be different reasons you lost the password
Person who installed the SQL Server knows the password but has left the building.
You did not write down the password in your password file
Password file is lost

Steps to recover the SA password
Start SQL Server Configuration Manager


Stop the SQL services


Edit the properties of the SQL Service


Change the startup parameters of the SQL service by adding a –m; in front of the existing parameters


Start the SQL services. These are now running in Single User Mode.
Start CMD on tthe SQL server
Start the SQLCMD command. Now you will see following screen


Now we create a new user. Enter following commands
CREATE LOGIN recovery WITH PASSWORD = ‘TopSecret 1′ (Remember SQL server has default strong password policy
Go
Now this user is created
Now we grant the user a SYSADMIN roles using the same SQLCMD window.
sp_addsrvrolemember ‘recovery’, ‘sysadmin’
go
Stop the SQL service again
Change the SQL service properties back to the default settings


Start the SQL service again and use the new created login (recovery in my example)
Go via the security panel to the properties and change the password of the SA account.


Now write down the new SA password.
Read More »

Wednesday, December 3, 2014

CKEditor Toolbar in asp.net

CKEditor Toolbar


Toolbar Customization


CKEDITOR.editorConfig = function( config )
{
// Define changes to default configuration here. For example:
// config.language = 'fr';
        // config.uiColor = '#AADC6E';


    config.toolbar_Full =
    [
   { name: 'document', items: ['Source', '-', 'Save', 'NewPage', 'DocProps', 'Preview', 'Print', '-', 'Templates'] },
   { name: 'clipboard', items: ['Cut', 'Copy', 'Paste', 'PasteText', 'PasteFromWord', '-', 'Undo', 'Redo'] },
   { name: 'editing', items: ['Find', 'Replace', '-', 'SelectAll', '-', 'SpellChecker', 'Scayt'] },
   { name: 'forms', items: ['Form', 'Checkbox', 'Radio', 'TextField', 'Textarea', 'Select', 'Button', 'ImageButton',
            'HiddenField']
   },
   '/',
   { name: 'basicstyles', items: ['Bold', 'Italic', 'Underline', 'Strike', 'Subscript', 'Superscript', '-', 'RemoveFormat'] },
   { name: 'paragraph', items: ['NumberedList', 'BulletedList', '-', 'Outdent', 'Indent', '-', 'Blockquote', 'CreateDiv',
   '-', 'JustifyLeft', 'JustifyCenter', 'JustifyRight', 'JustifyBlock', '-', 'BidiLtr', 'BidiRtl']
   },
   { name: 'links', items: ['Link', 'Unlink', 'Anchor'] },
   { name: 'insert', items: ['Image', 'Flash', 'Table', 'HorizontalRule', 'Smiley', 'SpecialChar', 'PageBreak', 'Iframe'] },
   '/',
   { name: 'styles', items: ['Styles', 'Format', 'Font', 'FontSize'] },
   { name: 'colors', items: ['TextColor', 'BGColor'] },
   { name: 'tools', items: ['Maximize', 'ShowBlocks', '-', 'About'] }
    ];

//    config.toolbar_Basic =
//    [
//    ['Bold', 'Italic', '-', 'NumberedList', 'BulletedList', '-', 'Link', 'Unlink', '-', 'About']
//    ];

};

Source:  http://docs.cksource.com/CKEditor_3.x/Developers_Guide/Toolbar
http://docs.cksource.com/CKEditor_3.x/Developers_Guide

Another Way:

 ID="CKEditor1" BasePath="/ckeditor/" runat="server" Width="100%" Toolbar="Basic"
ToolbarBasic="|Bold|Italic|Underline|Strike|-|NumberedList|BulletedList|Outdent|Indent|-|JustifyLeft|JustifyCenter|JustifyRight|JustifyBlock|
|Link|Unlink|-|TextColor|-|Undo|Redo|Cut|Copy|Paste|PasteText|PasteFromWord|
/
|Find|Replace|SelectAll|-|Image|Table|HorizontalRule|SpecialChar|-|Format|" >
Read More »

Tuesday, December 2, 2014

All About Client Script

Page redirection script
///
    /// This method is used to redirect into another page
    ///
    ///
    private void RedirectionScript(string pageUrl)
    {
        string redirectionScript = "";
        Page.ClientScript.RegisterStartupScript(this.GetType(), "Startup", redirectionScript);
    }

________________________________________________________________________________


Read More »

Recent Posts

My Blog List