redirect to new page from jquery

 function foo(id) {

    var url = '@Url.Action("Details", "Branch", new { id = "__id__" })';
    window.location.href = url.replace('__id__', id);
}

UPdate with join query

 UPDATE

    dbo.USERS

SET

    dbo.USERS.UserName = 

       CONCAT(t.FName,t.LName)

FROM 

    dbo.USERS c

    INNER JOIN dbo.PROFILES t

        ON c.Email = t.Email;

Delete All Stored Procedure -from database in Sql server

 DECLARE @spname sysname;

DECLARE SPCursor CURSOR FOR
SELECT SCHEMA_NAME(schema_id) + '.' + name
FROM sys.objects
WHERE type = 'P';
OPEN SPCursor;
FETCH NEXT FROM SPCursor INTO @spname;
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC('DROP PROCEDURE ' + @spname);
FETCH NEXT FROM SPCursor INTO @spname;
END
CLOSE SPCursor;
DEALLOCATE SPCursor;

CREATE NEW USER AND GRANT PERMISSION for INSER/UPDATE/DELETE IN SQL SERVER

 Use YourDatabase;

GO

--- Create User

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'NewUserName')

BEGIN

    CREATE USER [NewAdminName] FOR LOGIN [NewAdminName]

    EXEC sp_addrolemember N'db_owner', N'NewUserName'

END;

GO

--database level permission

GRANT SELECT,UPDATE,INSERT,DELETE ON dbo.SampleDatabase TO user;

-- Schema level permission

GRANT SELECT,UPDATE,INSERT,DELETE ON SCHEMA::dbo TO user;

change table schema name in sql server

declare @sql varchar(8000), @table varchar(1000), @oldschema varchar(1000), @newschema   varchar(1000)

  set @oldschema = 'dbo'

  set @newschema = 'exe'

 while exists(select * from sys.tables where schema_name(schema_id) = @oldschema)

  begin

      select @table = name from sys.tables 

      where object_id in(select min(object_id) from sys.tables where  schema_name(schema_id)  = @oldschema)

    set @sql = 'alter schema ' + @newschema + ' transfer ' + @oldschema + '.' + @table

   exec(@sql)

 end

asp.net bind drop down list

@Html.DropDownListFor(x => x.itmunit, new List<SelectListItem>

    {

                        new SelectListItem() {Text = "Piece", Value="Piece"},

                        new SelectListItem() {Text = "Box", Value="Box"},

                        new SelectListItem() {Text = "Kg", Value="Kg"},

                        new SelectListItem() {Text = "Litre", Value="Litre"}

    }, new { @class = "form-control" })

Check Performance in sql server

SELECT TOP 10 st.text

               ,st.dbid

               ,st.objectid

               ,qs.total_worker_time

               ,qs.last_worker_time

               ,qp.query_plan

FROM sys.dm_exec_query_stats qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st

CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp

ORDER BY qs.total_worker_time DESC