날자별

2014 2월
 12
3456789
10111213141516
17181920212223
2425262728  

table 존재 안할때 table 생성

[sql]drop table tempdb ;

if exists ( select * from sysobjects where name = ‘tempdb’ and xtype = ‘U’ ) create table cars111 ( Name0 varchar(64) not null, Name1 varchar(64) not null, Name2 varchar(64) not null ) ;

select * from INFORMATION_SCHEMA.COLUMNS where table_name = ‘cars111’ and column_name = ‘Name0’ ; [/sql]

wcf 작업때 표준 코드

Test [csharp] static private readonly ILog s_thelog = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType);

#if DEBUG static public ServiceReference_Solution.ServiceTaxiClient proxy = new ServiceReference_Solution.ServiceTaxiClient(); #else static public ServiceReference_Staging.ServiceTaxiClient proxy = new ServiceReference_Staging.ServiceTaxiClient(); #endif

private ProtoBufRES _function( ProtoBufASK r_ask ) { s_thelog.Info("> " + GetType().FullName + "." + MethodBase.GetCurrentMethod().Name);

var btask = ProtoBuffHelper.Serialize(r_ask); var btres = proxy.function(btask); var res […]