Geeks With Blogs
Łukasz Kuryło's blog SQL
Using stored procedures with NHibernate
NHibernate has many ways to create and executes queries. With one of them* - the Named Queries we can execute our manually created stored procedures. This example is dedicated to SQL Server. This is important to notice, because this code is database specified. That means, for each database the query can look diffrent. E.g. in SQL Server we call the stored procedure by using the syntax: exec <procedure>. In Oracle it is: call <procedure>, so we must remember it. Let's assume we have a ......

Posted On Wednesday, August 24, 2011 12:12 AM

Aliasing the data returned as xml
I just wanted to return from sql server data as xml. This is very easy to do, because sql server has a build-in suppot for that. select Id, Name from Extensions FOR XML RAW('Extension'), ROOT('Extensions') But using this query, the returned column has name like XML_F52E2B61-18A1-11d1-B105... It's been some time when I manually created a sql query, so I lost few minutes to think, how to alias this column using the AS keyword. Correct query looks as follows select (select Id,Name from Extensions ......

Posted On Tuesday, August 23, 2011 5:57 PM

Copyright © Łukasz Kuryło | Powered by: GeeksWithBlogs.net