Select as a XML MSSQL
C.GULDOGAN
4:40 PM
In Mssql you can get select result as XML by using following TSQL statement SELECT * FROM TableName FOR XML path, root;
Showing posts with label MsSql Server. Show all posts
Showing posts with label MsSql Server. Show all posts
Friday, November 13, 2015
Thursday, July 31, 2014
IF Sum is null convert it to 0 (zero)
C.GULDOGAN
1:03 AM
Oracle you may use the query below to convert SUM of totalPrice to zero when SUM result is null by using COALESCE select COALESCE ( S...
Saturday, October 1, 2011
5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation'
C.GULDOGAN
5:16 AM
The most common problem - 5(Access is denied.) - when you try to restore db back up.. It is so simple to solve =)) You should change yo...
Sunday, March 14, 2010
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
C.GULDOGAN
3:54 PM
You will face this problem in VisualStudio 2008. If you install and uninstall SQL Server Express 2005 on your system , you will see this err...
Thursday, June 4, 2009
PPC ye. SQL Server Yükleme
C.GULDOGAN
5:37 PM
Geçen gün başardığım (yeni öğrendiğim birşey). Sql server compact edition'ı WM 5 sistemime yüklemeyi başardım.. Aslında yükleme dosyalar...
Monday, June 1, 2009
Datagridview Kullanımı
C.GULDOGAN
4:41 PM
Daha önceki yazımda database'i projemize ekledik.. Şimdi bir form application da database'imizdeki verileri nasıl çekeceğiz ve kulla...
c# ile data base bağlantısı
C.GULDOGAN
4:12 PM
C# ile data base e bağlanmak aslında çok kolay.. Aşağıda resimler le anlatıyorum.. 1- DATA > ADD DATA SOURCE 2- Açılan Pencereden DATABAS...
[MS Sql Server 2008] Prevent saving changes option
C.GULDOGAN
3:42 PM
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made ...
