分类： 编程

查看SQL Server实际占用的物理内存

查看SQL Server实际占用的物理内存

SELECT
    object_name
   ,Counter_name
   ,cntr_value
   ,ROUND(( cntr_value * 8192.0 ) / 1048576, 0) AS cntr_value_MB
FROM
    sys.dm_os_performance_counters
WHERE
    object_Name LIKE '%Buffer Manager%'
    AND RTRIM(counter_name) IN ( 'Free pages', 'Total pages',
                                 'Database pages' )
UNION SELECT
    object_name
   ,Counter_name
   ,cntr_value
   ,ROUND(( cntr_value / 1024 ), 0) AS cntr_value_MB
FROM
    sys.dm_os_performance_counters
WHERE
    counter_name IN ( 'Target Server Memory (KB)',
                      'Total Server Memory (KB)' )

kindeditor获取不到内容的解决办法

kindeditor获取不到内容的解决办法

var editorMini = KindEditor.create('.editor-mini', {
    width: '98%',
    height: '450px',
    resizeType: 1,
    items: [
        'fontname', 'fontsize', '|', 'forecolor', 'hilitecolor', 'bold', 'italic', 'underline',
        'removeformat', '|', 'justifyleft', 'justifycenter', 'justifyright', 'insertorderedlist',
        'insertunorderedlist', '|', 'emoticons', 'link'],
        afterBlur: function() {
            this.sync();
        }
});

在 KindEditor.create中增加

afterBlur: function() {
    this.sync();
}

this.sync()说明：这个函数就是同步 KindEditor 的值到 textarea文本框。

官方解释：

sync()
将编辑器的内容设置到原来的textarea控件里。

SQL SERVER函数中使用SELECT 给变量赋值

SQL SERVER函数中使用SELECT 给变量赋值，注意函数中不能用SELECT INTO

SELECT @UserId= UserId FROM Tweet WHERE Id= @ReplyTo;

实例代码如下：

CREATE FUNCTION MyFun
(

)
RETURNS int
AS
BEGIN
        DECLARE @ReplyTo int
        DECLARE @UserId int
        DECLARE My_Cursor CURSOR --定义游标
        FOR (SELECT ReplyTo FROM Tweet WHERE ReplyTo<> 0) --查出需要的集合放到游标中
        OPEN My_Cursor; --打开游标
        FETCH NEXT FROM My_Cursor INTO @ReplyTo ; --读取第一行数据
        WHILE @@FETCH_STATUS = 0
        BEGIN                     
      SELECT @UserId= UserId FROM Tweet WHERE Id= @ReplyTo;
             FETCH NEXT FROM My_Cursor INTO @ReplyTo; --读取下一行数据
        END
        CLOSE My_Cursor; --关闭游标
        DEALLOCATE My_Cursor; --释放游标

        RETURN 0

END
GO

C#下载网页图片

C#下载网页图片

static void Main(string [] args)
{
    string url1 = "http://my.oschina.net/js/ke/plugins/emoticons/{0}.gif" ;
    for(int i=0; i<135; i++)
    {
        string url = string.Format(url1, i);
        WebRequest request = WebRequest .Create(url);
        WebResponse response = request.GetResponse();
        Stream reader = response.GetResponseStream();
        FileStream writer = new FileStream (@"E:\临时测试\ConsoleApplication2\新建文件夹\" + i.ToString() + ".gif", FileMode.OpenOrCreate, FileAccess.Write);
        byte[] buff = new byte[512];
        int c = 0; //实际读取的字节数
        while ((c = reader.Read(buff, 0, buff.Length)) > 0)
        {
            writer.Write(buff, 0, c);
        }
        writer.Close();
        writer.Dispose();
        reader.Close();
        reader.Dispose();
        response.Close();
    }
    Console.WriteLine( "下载完成.." );
}

ASP.NET MVC Controller中执行javascript

ASP.NET MVC Controller中执行javascript：

[HttpPost]
public ActionResult AjaxDelete(int id)
{
    using (var conn=DBConn.OpenConnection())
    {
        conn.Execute( "DELETE FROM Tel WHERE Id=@id", new { id = id });
    }
    return JavaScript( "location.reload();");
}

最后返回调用JavaScript的函数，这个函数参数就是要执行的JS脚本代码，在客户端页面执行。