arman-hpp

DECLARE @name nvarchar(255)

DECLARE db CURSOR FOR 
SELECT Name FROM sysdatabases
WHERE Name NOT IN ('master', 'tempdb', 'model', 'msdb')

OPEN db;

FETCH NEXT FROM db 

arman-hpp

select * from sys.extended_properties

EXEC sp_addextendedproperty   
@name = N'Description',   
@value = N'بانک اطلاعاتی بانک';  

EXEC sys.sp_addextendedproperty @name=N'MS_Description', 
@value=N'گروه مرجع' , @level0type=N'SCHEMA',@level0name=N'dbo'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', 

arman-hpp

select cpu_count from sys.dm_os_sys_info

select scheduler_id,cpu_id, status, is_online from sys.dm_os_schedulers where status='VISIBLE ONLINE'

arman-hpp

#1

SELECT  d.name , convert (smallint, req_spid) As spid
      FROM master.dbo.syslockinfo l, master.dbo.spt_values v, master.dbo.spt_values x, master.dbo.spt_values u, master.dbo.sysdatabases d
      WHERE   l.rsc_type = v.number and v.type = 'LR' and l.req_status = x.number and x.type = 'LS' and l.req_mode + 1 = u.number
                  and u.type = 'L' and l.rsc_dbid = d.dbid 
                  and rsc_dbid = (SELECT TOP 1 dbid FROM master..sysdatabases WHERE name LIKE 'my_db')
                  
 SET @kill_process =  'KILL ' + @spid      
            EXEC master.dbo.sp_executesql @kill_process

arman-hpp

            var report = new StiReport();
            report.Load((byte[])Resources.ResourceManager.GetObject("TestReport"));
            var reportBusinessObjects = new List<ReportBusinessObject>
            {
                new ReportBusinessObject("", "TestReport", reportDto)
            };
            LoadBusinessObjects(report, reportBusinessObjects);
            report.Compile();
            report.Render(false); 

arman-hpp

@echo off
set /p id="Enter Branch Code: "
@echo Please wait...
netsh interface ipv4 set address name="VirtualBox Host-Only Network" static 192.168.%id%.8 255.255.255.0 192.168.%id%.1
netsh interface ipv4 set dns name="VirtualBox Host-Only Network" static 8.8.8.8 PRIMARY
netsh interface ipv4 add dns name="VirtualBox Host-Only Network" 4.2.2.4 index=2
@echo Current branch changed to %id% Successfully.
pause

arman-hpp

    public static class ActiveDirectoryHelper
    {
        public static string GetSystemDomain()
        {
            try
            {
                return Domain.GetComputerDomain().ToString().ToLower();
            }
            catch (Exception ex)
            {

arman-hpp

            public static int Sqr(double x, double y)
            {
                try
                {
                    checked
                    {
                        return (int)Math.Pow(x, y);
                    }
                }
                catch (OverflowException)

arman-hpp

using System;
using System.Diagnostics;
using System.IO;

namespace TestBytes
{
    class Program
    {
        static unsafe void Main(string[] args)
        {

arman-hpp

    public static class Ebcdic
    {
        private static readonly char[] Ar1;
        private static readonly char[] Ar2;

        static Ebcdic()
        {
            Ar1 = new[]
            {
                'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', '¢', '.', '<', '(', '+', '|', '&', 'Q', 'R', 'S', 'T', 'U',