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 sql. Show all posts
Showing posts with label sql. Show all posts
Friday, November 13, 2015
Thursday, April 2, 2015
Alter column size Oracle
C.GULDOGAN
8:17 AM
To Alter column size in Oracle you may use the following query. It helps if your size of input doesn't fit your column. ALTER TABLE...
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...
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...
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...
