T-SQL Newline–Satır

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

Truncate Table SQL CF desteklenmiyor

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

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

 

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

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

 

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]