Bilgi Teknolojileri

T-SQL Newline–Satır

2011-07-26T06:23:00.001-07:00

CHAR(13) + CHAR(10) (Carriage return + Line Feed).

Truncate Table SQL CF desteklenmiyor

2011-07-25T00:08:00.001-07:00

aşağıdakinin yerine CF de

TRUNCATE TABLE [NAMEOFTABLE];

bunu

DELETE FROM [NAMEOFTABLE];

ALTER TABLE [NAMEOFTABLE] ALTER COLUMN ID IDENTITY (1,1);

yazmak gerekiyor. aynı şekilde CE cihazlarda .net 3.5 ‘da multithread kod yazarken MethodInvoker nesnenesi yok ve yerine ThreadStart ile casting yapabiliyoruz.

if (mControl.InvokeRequired)

{

mControl.Invoke((System.Threading.ThreadStart)delegate {

showProgressBar(Progress);

});

}

voila

Choosing Between SQL Server 2005 Compact Edition and SQL Server 2005 Express Edition

2011-07-21T23:43:00.001-07:00

Feature	SQL Server Compact Edition	SQL Server Express Edition
Deployment/Installation Features
Installation size	1.7mb download size 1.8mb expanded on disk	53.8mb download size ~197mb expanded on disk
ClickOnce deployment	+	+
Privately installed, embedded, with the application	+	-
Non-admin installation option	+	-
Runs on Windows Mobile platform	+	-
Installed centrally with an MSI	+	+
Runs in-process with application	+	-
64-bit support	- Version 3.1 + Native 64 in next version	+ Windows on Windows (WOW)
Runs as a service	+ In process with the application	+ N + 1
Data file features
File format	Single file	Multiple files
Data file storage on a network share	+	-
Support for different file extensions	+	-
Database size support	4GB	4GB
XML storage	+ stored as nText	+
Code free, document safe, file format	+	-
Programmability
Transact-SQL Common Query Features	+	+
Procedural T-SQL Select Case, If, features	-	+
Remote Data Access (RDA)	+	-
ADO.NET Sync Framework	+ Enabled with Visual Studio Orcas	- Planed support with a future version
Subscriber for merge replication	+	+
Simple transactions	+	+
Distributed transactions	-	+
Native XML, XQuery/QPath	-	+
Stored procedures, views, triggers	-	+
Role-based security	-	+
Number of concurrent connections	256	Unlimited

Windows Mobile Compact Framework- Uygulama Yolu

2011-07-18T23:35:00.001-07:00

System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().FullName.CodeBase)

compact framework de desteklenmeyenler

AppDomain.CurrentDomain.BaseDirectory

System.Environment.CurrentDirectory

Application.StartupPath

DATENAME Türkçe gün,ay isimleri

2011-07-15T01:13:00.001-07:00

SELECT

DATENAME(dw, TimeStart) AS DayOfWeek,

DATEPART(dw, TimeStart) AS DayNum

FROM ExecutionLogs

GROUP BY DATENAME(dw, TimeStart), DATEPART(dw, TimeStart)

DayOfWeek DayNum

------------------------------ -----------

Wednesday 4

Tuesday 3

Sunday 1

Friday 6

Thursday 5

Saturday 7

Monday 2

(7 row(s) affected)

SET LANGUAGE Turkish;

SELECT

DATENAME(dw, TimeStart) AS DayOfWeek,

DATEPART(dw, TimeStart) AS DayNum

FROM ExecutionLogs

GROUP BY DATENAME(dw, TimeStart), DATEPART(dw, TimeStart)

Changed language setting to Türkçe.

DayOfWeek DayNum

------------------------------ -----------

Perşembe 4

Pazartesi 1

Pazar 7

Salı 2

Cumartesi 6

Cuma 5

Çarşamba 3

(7 row(s) affected)

SET LANGUAGE Turkish;

SELECT

DATENAME(month, TimeStart) AS MonthName,

DATEPART(month, TimeStart) AS DayNum

FROM ExecutionLogs

GROUP BY DATENAME(month, TimeStart), DATEPART(month, TimeStart)

Changed language setting to Türkçe.

MonthName DayNum

------------------------------ -----------

Haziran 6

Þubat 2

Mayýs 5

Temmuz 7

Mart 3

Nisan 4

(6 row(s) affected)

Çalışan Sorguları Listeleme- Find Running Queries

2011-07-06T04:23:00.001-07:00

SELECT sqltext.TEXT,

req.session_id,

req.status,

req.command,

req.cpu_time,

req.total_elapsed_time

FROM sys.dm_exec_requests req

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

dönen kayıtlarda gözüken session_id kullanılarak saorgu iptal edilebilir/kesilebilir.

KILL [session_id]

Log dosyası geçmişinin temizlenmesi

2011-07-03T23:32:00.001-07:00

ALTER DATABASE [DATABASE_ADI] SET RECOVERY SIMPLE WITH NO_WAIT

DBCC SHRINKFILE(DATABASE_log_dosyasi, 1)

ALTER DATABASE [DATABASE_ADI] SET RECOVERY FULL WITH NO_WAIT

BI Report Server Oran Hesaplama

2011-06-09T04:15:00.001-07:00

Public Function OranHesapla(ByVal currentValue As Double, ByVal totalValue As Double) As Double
    If totalValue =0 Then
        Return 0
    Else
        Return (currentValue -totalValue ) / totalValue
    End If
End Function

Public Function OranYuzde(ByVal currentValue As Double, ByVal totalValue As Double) As Double
    If currentValue =0 Then
        Return 0
    Else
        Return (totalValue / currentValue)*100
    End If
End Function

rdl Code örneği

=Code.OranYuzde(SUM(Fields!GYT_SATIS.Value),SUM(Fields!BK_SATIS.Value))

Visual Studio Output Panel mesaj yazma

2011-06-08T01:47:00.001-07:00

System.Diagnostics.Trace.WriteLine("Second's destructor is called.");

using System.Diagnostics;

System.Diagnostics.Trace.WriteLine("Second's destructor is called.");

TraceSource ts = new TraceSource("HelloWorld", SourceLevels.All);

ts.TraceInformation("# of records processed: {0}", n);

ts.TraceEvent(TraceEventType.Information, 10, "# of records processed: {0}", n);

ts = new TraceSource("HelloWorld", SourceLevels.Critical | SourceLevels.ActivityTracing);

<system.diagnostics>

<add name="consoleListener"

type="System.Diagnostics.ConsoleTraceListener"/>

<add name="eventlogListener"

type="System.Diagnostics.EventLogTraceListener"

initializeData="Application"/>

<add name="textfileListener"

type="System.Diagnostics.TextWriterTraceListener"

initializeData="helloworld.log" />

<add name="xmlfileListener"

type="System.Diagnostics.XmlWriterTraceListener"

initializeData="helloworld.xml" />

<add name="defaultListener"

type="System.Diagnostics.DefaultTraceListener"/>

</listeners>

</source>

</sources>

</system.diagnostics>

<system.diagnostics>

<add name="myListener"

type="MyTestTraceListener, MyAssembly">

<filter type="System.Diagnostics.EventTypeFilter"

initializeData="Information"/>

</add>

</sharedListeners>

</listeners>

</source>

</sources>

</system.diagnostics>

log.Info( m=>m("some logger info {0}", (object)myObj) )

log.Info( ()=>String.Format("some logger info {0}", (object)myObj) )

Critical Error Warning Information Verbose Start Stop Suspend Resume Transfer

WCF Duplex callback ile mesaj almak ve göndermek

2011-05-30T23:39:00.001-07:00

<system.serviceModel>

</protocolMapping>

</service>

</services>

</behavior>

</serviceBehaviors>

</behaviors>

</system.serviceModel>

WCF Svc file

<%@ServiceHost language="c#" Debug="true" Service="Plugins.Intranet.Library.SupportService" %>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.ServiceModel;

namespace Plugins.Intranet.Library

{

// The callback interface is used to send messages from service back to client.

// The Result operation will return the current result after each operation.

// The Equation opertion will return the complete equation after Clear() is called.

public interface ISupportServiceDuplexCallback

{

[OperationContract(IsOneWay = true)]

void NewMessage(SupportMessage msg);

}

// Define a duplex service contract.

// A duplex contract consists of two interfaces.

// The primary interface is used to send messages from the client to the service.

// The callback interface is used to send messages from the service back to the client.

// ICalculatorDuplex allows one to perform multiple operations on a running result.

// The result is sent back after each operation on the ICalculatorCallback interface.

[ServiceContract(Namespace = "http://intranet.metafor",

SessionMode = SessionMode.Required,

CallbackContract = typeof(ISupportServiceDuplexCallback))]

public interface ISupportService

{

[OperationContract(IsOneWay = true)]

void TestService();

[OperationContract(IsOneWay = true)]

void GetMessages(string UserID);

}

// Service class which implements a duplex service contract.

// Use an InstanceContextMode of PerSession to store the result

// An instance of the service will be bound to each duplex session

[ServiceBehavior(InstanceContextMode = InstanceContextMode.PerSession)]

public class SupportService : ISupportService

{

public int ServiceStatus { get; set; }

public void TestService()

{

ServiceStatus= 11;

}

public void GetMessages(string UserID)

{

// dummy message for test

var buf = new SupportMessage()

{

Title="Test Message Title",

Description= "Lorem ipsum",

CreateTime= DateTime.Now

};

Callback.NewMessage(buf);

}

ISupportServiceDuplexCallback Callback

{

get

{

return OperationContext.Current.GetCallbackChannel<ISupportServiceDuplexCallback>();

}

public class SupportMessage

{

public string Sender { get; set; }

public string Title { get; set; }

public string Description { get; set; }

public int Category { get; set; }

public DateTime CreateTime { get; set; }

}

http://localhost/metafor/plugins/SupportService.svc

web result

class Test

{

static void Main()

{

SupportServiceClient client = new SupportServiceClient();

// Hizmetteki işlemleri çağırmak için 'client' değişkenini kullanın.

// Her zaman istemciyi kapatın.

client.Close();

}

Visual Basic

Class Test

Shared Sub Main()

Dim client As SupportServiceClient = New SupportServiceClient()

' Hizmetteki işlemleri çağırmak için 'client' değişkenini kullanın.

' Her zaman istemciyi kapatın.

client.Close()

End Sub

End Class

Client code :

Svcutil.exe http://localhost/metafor/plugins/SupportService.svc

Output.config

<system.serviceModel>

</security>

</binding>

</wsDualHttpBinding>

</bindings>

</identity>

</endpoint>

</client>

</system.serviceModel>

namespace Plugins.Intranet.Library

{

public class SupportSelfCallback : ISupportServiceCallback

{

public delegate void MessageReceivedEventHandler(object sender, MessageReceivedEventArgs e);

public event MessageReceivedEventHandler MessageReceived;

protected void RaiseMessageReceived(object propertyName)

{

MessageReceivedEventHandler messageChanged = this.MessageReceived;

if ((MessageReceived != null))

{

MessageReceived(this, new MessageReceivedEventArgs(propertyName));

}

#region ISupportServiceCallback Members

public void NewMessage(ServiceReferenceSupport.SupportMessage msg)

{

RaiseMessageReceived(msg);

}

#endregion

}

public class MessageReceivedEventArgs : EventArgs

{

public MessageReceivedEventArgs(object message)

{

this.MessageField = message;

}

private object MessageField;

public virtual object Message { get { return MessageField; } }

}

End of code

SupportSelfCallback duplexCallBack = new SupportSelfCallback();

duplexCallBack.MessageReceived += new SupportSelfCallback.MessageReceivedEventHandler(duplexCallBack_MessageReceived);

// Construct InstanceContext to handle messages on callback interface.

InstanceContext instanceContext = new InstanceContext(duplexCallBack);

SupportServiceClient client = new SupportServiceClient(instanceContext);

void duplexCallBack_MessageReceived(object sender, MessageReceivedEventArgs e)

{

// do stuff

}

Visual Studio 2010 Exceptions- Hataları düzenlemek

2011-05-27T04:13:00.001-07:00

shortcut Ctrl + Alt + E

Visual Studio prebuild- postbuild Command

2011-05-27T03:55:00.001-07:00

mkdir %SystemDrive%\inetpub\wwwroot\servicemodelsamples
mkdir %SystemDrive%\inetpub\wwwroot\servicemodelsamples\bin
copy "$(TargetDir)service.dll" %SystemDrive%\inetpub\wwwroot\servicemodelsamples\bin
copy "$(ProjectDir)service.svc" %SystemDrive%\inetpub\wwwroot\servicemodelsamples
copy "$(ProjectDir)web.config" %SystemDrive%\inetpub\wwwroot\servicemodelsamples

Macro	Description
$(ConfigurationName)	The name of the current project configuration, for example, "Debug\|Any CPU".
$(OutDir)	Path to the output file directory, relative to the project directory. This resolves to the value for the Output Directory property. It includes the trailing backslash '\'.
$(DevEnvDir)	The installation directory of Visual Studio 2010 (defined with drive and path); includes the trailing backslash '\'.
$(PlatformName)	The name of the currently targeted platform. For example, "AnyCPU".
$(ProjectDir)	The directory of the project (defined with drive and path); includes the trailing backslash '\'.
$(ProjectPath)	The absolute path name of the project (defined with drive, path, base name, and file extension).
$(ProjectName)	The base name of the project.
$(ProjectFileName)	The file name of the project (defined with base name and file extension).
$(ProjectExt)	The file extension of the project. It includes the '.' before the file extension.
$(SolutionDir)	The directory of the solution (defined with drive and path); includes the trailing backslash '\'.
$(SolutionPath)	The absolute path name of the solution (defined with drive, path, base name, and file extension).
$(SolutionName)	The base name of the solution.
$(SolutionFileName)	The file name of the solution (defined with base name and file extension).
$(SolutionExt)	The file extension of the solution. It includes the '.' before the file extension.
$(TargetDir)	The directory of the primary output file for the build (defined with drive and path). It includes the trailing backslash '\'.
$(TargetPath)	The absolute path name of the primary output file for the build (defined with drive, path, base name, and file extension).
$(TargetName)	The base name of the primary output file for the build.
$(TargetFileName)	The file name of the primary output file for the build (defined as base name and file extension).
$(TargetExt)	The file extension of the primary output file for the build. It includes the '.' before the file extension.

referrer : http://msdn.microsoft.com/en-us/library/42x5kfw4.aspx

SQL ile değerlerin arasına virgül koymak- Join

2011-05-20T07:57:00.001-07:00

SELECT STUFF((SELECT ',' + ISMI FROM MAGAZA_TANIM FOR XML PATH('')),1, 1, '')

iki tarih arasındaki zamanı hesaplamak

2011-05-20T07:56:00.001-07:00

[Microsoft.SqlServer.Server.SqlFunction]

public static SqlString datediff2(SqlDateTime Date1, SqlDateTime Date2, string StringFormat=" {0} yıl, {1} ay, {2} gün")

{

// date1 is small one-- date2 is biggest one

int years = 0;

int months = 0;

int days = 0;

string buff = string.Empty;

DateTime currentDate = Date1.Value;

DateTime datetarget = Date2.Value;

DateTime tmpMyDOB = new DateTime(datetarget.Year, datetarget.Month, 1);

DateTime tmpFutureDate = new DateTime(currentDate.Year, currentDate.Month, 1);

while (tmpMyDOB.AddYears(years).AddMonths(months) < tmpFutureDate)

{

months++;

if (months > 12)

{

years++;

months = months - 12;

}

if (currentDate.Day >= datetarget.Day)

{

days = days + currentDate.Day - datetarget.Day;

}

else

{

months--;

if (months < 0)

{

years--;

months = months + 12;

}

days +=

DateTime.DaysInMonth(

currentDate.AddMonths(-1).Year, currentDate.AddMonths(-1).Month

) + currentDate.Day - datetarget.Day;

}

//add an extra day if the dob is a leap day

if (DateTime.IsLeapYear(datetarget.Year) && datetarget.Month == 2 && datetarget.Day == 29)

{

//but only if the future date is less than 1st March

if (currentDate >= new DateTime(currentDate.Year, 3, 1))

days++;

}

buff = string.Format(StringFormat, years, months, days);

buff = buff.Replace(", 0 gün", string.Empty);

buff = buff.Replace(", 0 ay", string.Empty);

buff = buff.Replace(" 0 yıl, ", string.Empty);

return new SqlString(buff);

}

Aero Style Forms

2011-01-15T09:34:00.001-08:00

#region ----- Aero Form

[System.Runtime.InteropServices.StructLayout(System.Runtime.InteropServices.LayoutKind.Sequential)]

public struct MARGINS

{

public int Left;

public int Right;

public int Top;

public int Bottom;

}

private MARGINS margins;

[System.Runtime.InteropServices.DllImport("dwmapi.dll", PreserveSig = false)]

public static extern void DwmExtendFrameIntoClientArea

(IntPtr hwnd, ref MARGINS margins);

[System.Runtime.InteropServices.DllImport("dwmapi.dll", PreserveSig = false)]

public static extern bool DwmIsCompositionEnabled();

protected override void OnLoad(EventArgs e)

{

base.OnLoad(e);

if (DwmIsCompositionEnabled())

{

// Paint the glass effect.

margins = new MARGINS();

margins.Top = 50;

DwmExtendFrameIntoClientArea(this.Handle, ref margins);

}

protected override void OnPaintBackground(PaintEventArgs e)

{

base.OnPaint(e);

if (DwmIsCompositionEnabled())

{

// paint background black to enable include glass regions

e.Graphics.Clear(Color.Black);

// revert the non-glass rectangle back to it's original colour

Rectangle clientArea = new Rectangle(

margins.Left,

margins.Top,

this.ClientRectangle.Width - margins.Left - margins.Right,

this.ClientRectangle.Height - margins.Top - margins.Bottom

);

Brush b = new SolidBrush(this.BackColor);

e.Graphics.FillRectangle(b, clientArea);

}

#endregion

RowNumber ve Sayfalama

2011-01-13T09:29:00.001-08:00

SELECT ROW_NUMBER() OVER(ORDER BY Name) as 'Row Number', Name,[Type] FROM @test

Row Number Name Type

1 Film normal

2 Film normal

3 Film Korku

4 Film Savas

5 Film Savas

6 Film Savas

7 Film Savas

8 Film Komedi

9 Film Komedi

10 Film Komedi

11 Müzik Pop

12 Müzik Pop

13 Müzik Rock

14 Müzik Hard Rock

15 Müzik Hard Rock

16 Müzik Hard Rock

17 Müzik Metal

18 Müzik Metal

;WITH test as

(

SELECT ROW_NUMBER() OVER(ORDER BY Name) as 'Rows',

Name,

[Type]

FROM @test

)

SELECT * FROM test WHERE [Rows] BETWEEN 3 AND 7

Rows Name Type

3 Film Korku

4 Film Savas

5 Film Savas

6 Film Savas

7 Film Savas

SELECT RowNumber= identity(int,1,1), Name,[Type] INTO #tmp

FROM @test

SELECT * FROM #tmp WHERE RowNumber BETWEEN 10 AND 15

DROP TABLE #tmp

RowNumber Name Type

10 Film Komedi

11 Müzik Pop

12 Müzik Pop

13 Müzik Rock

14 Müzik Hard Rock

15 Müzik Hard Rock

cube ve rollup ile Toplam hesaplamak

2011-01-13T08:43:00.001-08:00

DECLARE @test TABLE

(

ID int identity(1,1),

[Type] nvarchar(100),

Name nvarchar(100)

)

INSERT INTO @test VALUES( 'normal','Film' )

INSERT INTO @test VALUES( 'Korku','Film' )

INSERT INTO @test VALUES( 'Savaş','Film' )

INSERT INTO @test VALUES( 'Komedi','Film' )

INSERT INTO @test VALUES( 'Pop','Müzik' )

INSERT INTO @test VALUES( 'Rock','Müzik' )

INSERT INTO @test VALUES( 'Hard Rock','Müzik' )

INSERT INTO @test VALUES( 'Metal','Müzik' )

SELECT COUNT(ID) as Count, Name FROM @test GROUP BY Name

Count Name

10 Film

8 Müzik

SELECT COUNT(ID), COALESCE(Name,'Toplam') FROM @test GROUP BY Name with cube

Count Name

10 Film

8 Müzik

18 Toplam

SELECT COUNT(ID) as Count,Type, Name FROM @test GROUP BY [Type],Name with cube

Count Type Name

3 Komedi Film

1 Korku Film

2 normal Film

4 Savas Film

10 NULL Film

3 Hard Rock Müzik

2 Metal Müzik

2 Pop Müzik

1 Rock Müzik

8 NULL Müzik

18 NULL NULL

3 Hard Rock NULL

3 Komedi NULL

1 Korku NULL

2 Metal NULL

2 normal NULL

2 Pop NULL

1 Rock NULL

4 Savas NULL

SELECT COUNT(ID) as Count, Name FROM @test GROUP BY Name with rollup

Count Name

10 Film

8 Müzik

18 NULL

SELECT COUNT(ID) as Count,Type, Name FROM @test GROUP BY [Type],Name with rollup

Count Type Name

3 Hard Rock Müzik

3 Hard Rock NULL

3 Komedi Film

3 Komedi NULL

1 Korku Film

1 Korku NULL

2 Metal Müzik

2 Metal NULL

2 normal Film

2 normal NULL

2 Pop Müzik

2 Pop NULL

1 Rock Müzik

1 Rock NULL

4 Savas Film

4 Savas NULL

18 NULL NULL

SELECT COUNT(ID) as Count,[Type], Name FROM @test GROUP BY rollup([Type],Name)

SELECT COUNT(ID) as Count,[Type], Name FROM @test GROUP BY cube([Type],Name)