Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

C#¶ÁÈ¡sqlserver ¶¯»­flash swf Îļþµ½±¾µØÓ²ÅÌ

 using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;
public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        //°ÑͼƬ±£´æ³ÉÊý¾Ý¿â¶þ½øÖÆÐÎʽ
        Stream ImageStream;
        string Path = FileUpload1.PostedFile.FileName;// ÎļþÃû³Æ
        int Size = FileUpload1.PostedFile.ContentLength; // Îļþ´óС
        string Type = FileUpload1.PostedFile.ContentType; // ÎļþÀàÐÍ
        ImageStream = FileUpload1.PostedFile.InputStream;
        byte[] Content = new byte[Size];
        int Status = ImageStream.Read(Content, 0, Size);
        SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
        SqlCommand comm = new SqlCommand("insert into testimage (UserName,Image,Path,Type) values(@UserName,@Image,@Path,@Type)", conn);
        comm.CommandType = CommandType.Text;
        comm.Parameters.Add("@UserName", SqlDbType.VarChar, 255).Value = txtUserName.Text;
        comm.Parameters.Add("@Image", SqlDbType.Image).Value = Content;
        comm.Parameters.


Ïà¹ØÎĵµ£º

Óû§"sa "µÇ½ʧ°Ü SQLServer ´íÎó18456

 ÓÃwindowsÕ˺ݹÊÇ¿ÉÒԵǼµÄ¡£
²éÕÒÎÊÌâµÄ¹ý³Ì£º
µÚÒ»²½£º Æô¶¯ËùÓÐÓëSQLÓйصķþÎñ£¬ÎÊÌâÒÀ¾É£»
µÚ¶þ²½£º ²é¿´windows·À»ðǽ£¬±»Ä¬ÈÏÆô¶¯ÁË£¬²»Æô¶¯Ñ¡ÔñÏî±»Disabled¡£Á½¸öÌáʾ“ÓÉÓÚ°²È«¿¼ÂÇ,ijЩÉèÖÃÓÉ×é²ßÂÔ¿ØÖÆ”“Windows·À»ðǽÕýÔÚʹÓÃÄúµÄÓòÉèÖÔ£¬ÏÈÓÃgpedit.msc´ò×é²ßÂԱ༭Æ÷£¬» ......

Sqlserver ÖÐunionºÍorder by ×Ó¾äµÄÎÊÌâ

UnionĬÈÏÊDz»ÄÜÓÐorder by×Ó¾ä
Èç¹ûÐèÒªÅÅÐò£¬ÔòÖ»ÄÜÈçÏÂʵÏÖ 
select * from (select top 100 PERCENT  * from ±íÃû order by ×Ö¶ÎÃû) a
               union all
 select * from (select top 100 PERCENT  * from ±íÃû ......

´«ÖDz¥¿ÍÎÒµÄSqlServer½Å±¾

 
======================SqlServer´ó²¿·Ö֪ʶ¶¼ÔÚÎÒÕâ½Å±¾Àï===============
Èç¹ûÄãÄܰÑÊý¾Ý½á¹¹»­³öÀ´µÄ»°£¬ÄÇôÄã¾ÍÈëÃÅÁË£¡£¡ºÇºÇ£¡£¡
--²é¿´konwyoumore¿âÊÇ·ñ´æÔÚ
USE master
IF exists(SELECT * from sysdatabases WHERE name='KnowYouMore')
BEGIN
DROP DATABASE knowyoumore;
END
GO
--´´½¨konwyo ......

ΪSQLServer±íÖеÄ×Ö¶ÎÌí¼Ó˵Ã÷

ÔÚSQLÓï¾äÖÐͨ¹ýϵͳ´æ´¢¹ýsp_addextendedproperty¿ÉΪ±í×Ö¶ÎÌí¼ÓÉ϶¯Ì¬µÄ˵Ã÷£¨±¸×¢£©ÏÂÃæÊÇSQL SERVER°ïÖúÎĵµÖжÔsp_addextendedproperty´æ´¢¹ý³ÌµÄÃèÊö
Óï·¨
sp_addextendedproperty
    [ @name = ] { 'property_name' }
    [ , [ @value = ] { 'value' }
   &nbs ......

OracleÖÐÓëSQLSERVER ISNULLº¯ÊýÏàͬ×÷Óõĺ¯Êý

NVL(Expr1,Expr2)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr1µÄÖµ
NVL2(Expr1,Expr2,Expr3)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr3µÄÖµ
NULLIF(Expr1,Expr2)Èç¹ûExpr1ºÍExpr2µÄÖµÏàµÈ£¬·µ»ØNULL£¬·ñÔò·µ»ØExpr1µÄÖµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ