SQL Server - How to Change (Reseed) Identity Column Value in SQL Server 2008

SQL Server Replace Multiple Spaces in String with Single Space:


To replace multiple spaces in string with single space in sql server
we need to write
the query like this

Select REPLACE(REPLACE(REPLACE(@str,' ','{}'),'}{',''),'{}',' ')
Example:

DECLARE @str varchar(150)

SET @str='Hello Welcome to Aspdotnet-suresh.com'

Select REPLACE(REPLACE(REPLACE(@str,' ','{}'),'}{',''),'{}',' ')



SQL Server - How to Remove Special Characters from String in SQL Server 2008:
DECLARE @regex INT,@string varchar(100)
SET @string='welcome-to''aspdotnet=sures@h.com##39;
SET @regex = PATINDEX('%[^a-zA-Z0-9 ]%', @string)

WHILE @regex > 0

BEGIN
SET @string = STUFF(@string, @regex, 1, ' ' )
SET @regex = PATINDEX('%[^a-zA-Z0-9 ]%', @string)
END
SELECT @string

SQL Server - How to Change (Reseed) Identity Column Value in SQL Server 2008:

DBCC CHECKIDENT (Table_Name, RESEED, New_Reseed_Value)

: DBCC CHECKIDENT ('UserDetails', RESEED, 500)

Best Login Page Design in HTML, CSS with Source Code

<html>

<head>

<meta charset="utf-8">

<title>Best Login Page design in html and css</title>

<style type="text/css">

body {

background-color: #f4f4f4;

color: #5a5656;

font-family: 'Open Sans', Arial, Helvetica, sans-serif;

font-size: 16px;

line-height: 1.5em;

}

a { text-decoration: none; }

h1 { font-size: 1em; }

h1, p {

margin-bottom: 10px;

}

strong {

font-weight: bold;

}

.uppercase { text-transform: uppercase; }

/* ---------- LOGIN ---------- */

#login {

margin: 50px auto;

width: 300px;

}

form fieldset input[type="text"], input[type="password"] {

background-color: #e5e5e5;

border: none;

border-radius: 3px;

-moz-border-radius: 3px;

-webkit-border-radius: 3px;

color: #5a5656;

font-family: 'Open Sans', Arial, Helvetica, sans-serif;

font-size: 14px;

height: 50px;

outline: none;

padding: 0px 10px;

width: 280px;

-webkit-appearance:none;

}

form fieldset input[type="submit"] {

background-color: #008dde;

border: none;

border-radius: 3px;

-moz-border-radius: 3px;

-webkit-border-radius: 3px;

color: #f4f4f4;

cursor: pointer;

font-family: 'Open Sans', Arial, Helvetica, sans-serif;

height: 50px;

text-transform: uppercase;

width: 300px;

-webkit-appearance:none;

}

form fieldset a {

color: #5a5656;

font-size: 10px;

}

form fieldset a:hover { text-decoration: underline; }

.btn-round {

background-color: #5a5656;

border-radius: 50%;

-moz-border-radius: 50%;

-webkit-border-radius: 50%;

color: #f4f4f4;

display: block;

font-size: 12px;

height: 50px;

line-height: 50px;

margin: 30px 125px;

text-align: center;

text-transform: uppercase;

width: 50px;

}

.facebook-before {

background-color: #0064ab;

border-radius: 3px 0px 0px 3px;

-moz-border-radius: 3px 0px 0px 3px;

-webkit-border-radius: 3px 0px 0px 3px;

color: #f4f4f4;

display: block;

float: left;

height: 50px;

line-height: 50px;

text-align: center;

width: 50px;

}

.facebook {

background-color: #0079ce;

border: none;

border-radius: 0px 3px 3px 0px;

-moz-border-radius: 0px 3px 3px 0px;

-webkit-border-radius: 0px 3px 3px 0px;

color: #f4f4f4;

cursor: pointer;

height: 50px;

text-transform: uppercase;

width: 250px;

}

.twitter-before {

background-color: #189bcb;

border-radius: 3px 0px 0px 3px;

-moz-border-radius: 3px 0px 0px 3px;

-webkit-border-radius: 3px 0px 0px 3px;

color: #f4f4f4;

display: block;

float: left;

height: 50px;

line-height: 50px;

text-align: center;

width: 50px;

}

.twitter {

background-color: #1bb2e9;

border: none;

border-radius: 0px 3px 3px 0px;

-moz-border-radius: 0px 3px 3px 0px;

-webkit-border-radius: 0px 3px 3px 0px;

color: #f4f4f4;

cursor: pointer;

height: 50px;

text-transform: uppercase;

width: 250px;

}

</style>

</head>

<body>

<div id="login">

<h1><strong>Welcome.</strong> Please login.</h1>

<form action="javascript:void(0);" method="get">

<fieldset>

<p><input type="text" required value="Username" onBlur="if(this.value=='')this.value='Username'"onFocus="if(this.value=='Username')this.value='' "></p>

<p><input type="password" required value="Password" onBlur="if(this.value=='')this.value='Password'"onFocus="if(this.value=='Password')this.value='' "></p>

<p><a href="#">Forgot Password?</a></p>

<p><input type="submit" value="Login"></p>

</fieldset>

</form>

<p><span class="btn-round">or</span></p>

<p>

<a class="facebook-before"></a>

<button class="facebook">Login Using Facbook</button>

</p>

<p>

<a class="twitter-before"></a>

<button class="twitter">Login Using Twitter</button>

</p>

</div> <!-- end login -->

</body>

</html>