MajidSafari

ALTER DATABASE [old_name]
 
	SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [old_name]
 
	MODIFY NAME = [new_name]
GO
ALTER DATABASE [new_name]
	SET MULTI_USER

MajidSafari

SELECT RIGHT(Email, LEN(Email) - CHARINDEX('@', email)) Domain ,
COUNT(Email) EmailCount
FROM   Article.tblNewsLetter

WHERE  LEN(Email) > 0 AND MailCheck=1 AND IsActive=1
GROUP BY RIGHT(Email, LEN(Email) - CHARINDEX('@', email))
ORDER BY EmailCount DESC

MajidSafari

%UserProfile%\Local Settings\Application Data\Red Gate\

MajidSafari

$('.error-template').delay(400).css({top: -25, opacity: 0}).animate({top: 0, opacity: 1}, 

MajidSafari

$(function() {
  $('a[href*=#]:not([href=#])').click(function() {
    if (location.pathname.replace(/^\//,'') == this.pathname.replace(/^\//,'') && location.hostname == this.hostname) {
      var target = $(this.hash);
      target = target.length ? target : $('[name=' + this.hash.slice(1) +']');
      if (target.length) {
        $('html,body').animate({
          scrollTop: target.offset().top
        }, 1000);
        return false;

MajidSafari

        var xPos, yPos;
        var prm = Sys.WebForms.PageRequestManager.getInstance();
        prm.add_beginRequest(BeginRequestHandler);
        prm.add_endRequest(EndRequestHandler);
        function BeginRequestHandler(sender, args) {
            
        }
        function EndRequestHandler(sender, args) {
           
        }

MajidSafari

set ansi_nulls off

if null = null
	print 'true'
else
	print 'false'

if null IS null
	print 'true'
else

MajidSafari

 string[] myCookies = Request.Cookies.AllKeys;
    foreach (string cookie in myCookies)
    {
        var httpCookie = Response.Cookies[cookie];
        if (httpCookie != null)
        {
            httpCookie.Expires = DateTime.Now.AddYears(-10);
            Response.Cookies.Add(httpCookie);
        }
        var httpCookie1 = Response.Cookies[cookie];