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

ÔÚc#ÖеÄÈ¡µÃsql server´æ´¢¹ý³ÌµÄoutput²ÎÊý

private void Create_Pz(string Sourcename)
        {
            string OutMsg;
            SqlParameter[] sortPara = { new SqlParameter("@ps_IsType", Pzcheck),
                                        new SqlParameter("@pi_SourceId", Pzcode),
                                        new SqlParameter("@ps_ZdrCode", ZdrCode),
                                        new SqlParameter("@OutMsg", SqlDbType.VarChar,500,ParameterDirection.Output,
                                        true,0,0,string.Empty,DataRowVersion.Default,null)
                                    };
            if (Convert.ToBoolean(SqlHelper.ExecuteNonQuery(SqlHelper.SQLCONN, CommandType.StoredProcedure, "sCwGenPzWizard", sortPara)))
            {
         &n


Ïà¹ØÎĵµ£º

Sql2005/08 ±í½á¹¹ SQL Óï¾ä

SELECT
(case when a.colorder=1 then d.name
--+'('+cast(h.value as nvarchar)+')'
else '' end)±íÃû,
a.colorder ×Ö¶ÎÐòºÅ,
a.name ×Ö¶ÎÃû,
isnull(g.[value],'') AS ×Ö¶Î˵Ã÷,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '¡Ì'else '' end) ±êʶ,
(case whe ......

SQL Server ¹ÜÀí³£ÓõÄSQLºÍT SQL

1. ²é¿´Êý¾Ý¿âµÄ°æ±¾  
  select @@version
 
  ³£¼ûµÄ¼¸ÖÖSQL SERVER´ò²¹¶¡ºóµÄ°æ±¾ºÅ:
 
  8.00.194   Microsoft SQL Server 2000
  8.00.384   Microsoft SQL Server 2000 SP1
  8.00.532   Microsoft SQL Server 2000 SP2
  8.00.760 &nb ......

[SQL]SQLÐÔÄܵ÷ÓÅ

³õ¼¶Æª —— ¼òµ¥²éѯÓï¾äµÄµ÷ÓÅ ÀîÃ÷»Û , Èí¼þ¹¤³Ìʦ, IBM­
ÀîÃ÷»Û£¬ÔÚ IBM ÖйúÈí¼þ¿ª·¢ÖÐÐÄ Data Studio ÍŶӹ¤×÷´ÓÊ InfoSphere Warehouse Administration Console µÄ¹¦ÄܲâÊÔ¹¤×÷¡£ÔøÔÚ developerWorks ·¢±í¡¶½« DB2 DWE 9.1.X Ç¨ÒÆµ½ DB2 Warehouse 9.5¡·¡¢¡¶InfoSphere Warehouse SQL ²Ö´¢ÃüÁîÐнӿ ......

C# asp.netÈçºÎʹÓÃMD5¼ÓÃÜ£¬½âÃÜ

using System;
using System.Collections.Generic;
using System.Text;
using System.Security.Cryptography;namespace md5
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine(UserMd5("8"));
Console.WriteLine(GetMd5Str("8"));
}
/**//// <summary>
/// MD5 16λ¼ÓÃÜ ......

sql°²×°ÎÊÌâ

Ò»¡¢Çé¿ö˵Ã÷
    sql server 2000ÒÔǰµÄ°æ±¾£¬ÀýÈç7.0Ò»°ã²»´æÔÚ¶à¸ö°æ±¾£¬Ö»Óбê×¼°æ¸ú×ÀÃæ°æ£¬Óû§Èç¹û²»Çå³þ¸Ãװʲô°æ±¾µÄ»°£¬¿É°´°²×°ÉϵÄ
°²×°ÏȾöÌõ¼þָʾ°²×°£¬Ò»°ãÔÚWIN2000 ·þÎñÆ÷°æÉÏ×°±ê×¼°æ£¬ÆäËûµÄϵͳװ×ÀÃæ°æµÄ¾Í¿ÉÒÔ£»¶øSQL Server 2000°²×°ÎÊÌâ¾Í±È½Ï´ó£¬Ê±³£
¼ûµ½µÄÎÊÌâÈçÏ£º
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ