Blog Posts on sql server




Percent:
 
Distinct:
 


Extract Date Part from Datetime Expression or Datetime Field in SQL Server 2005 by on Jan 19, 2012Use Convert() Function. From MSDN, this is the syntax:Syntax for CONVERT: CONVERT ( data_type [ ( length ) ] , expression [ , style ] )To get it from a datetime expression,Select Convert(varchar(10),GetDate(),111)or from a field,Select Convert(varcha...



SQL Server 2005: Mimicking Visual Foxpro's SCAN/ENDSCAN by on Jan 12, 2012At work, it's been a common thing for me to execute my own queries in our SQL Server for reasons like fixing invalid entries or just for reporting purposes. Our POS and Data Management system are working fine, but the need for database administrator'...



Executing a SQL Server's Stored Procedure in Excel Sheet by on Jan 9, 2012Figure 1.There are times when your boss calls for your immediate solution for simple problems but that solution can only be solved by using your programming skill. You look at the problem, analyze a solution within the scope of the software the compa...



NHibernate and Related Objects by Jojo Sardez Online on Apr 26, 2011By: Jojo Sardez (Apr 26, 2011) Relation between objects is one of the most observed practices in real-world applications. It is used for parent-child, header-detail, or any foreign key related information. Good thing is that NHibernate can also handl...



Introduction to NHibernate by Jojo Sardez Online on Apr 25, 2011By: Jojo Sardez (Apr 25, 2011) NHibernate is an open source ORM tool for .Net framework based applications. Its design and concept is based on the Hibernate ORM for Java. The tool really helps developers to work fast since it gives us more time to wr...



Manipulating SQL Server Database using VB.Net by on Nov 21, 2010Share untitled.jpg Hello Guys This is a simple tutorial on how to manipulate database (sql server 2008) using vb.net Hope You Like it Guys! Manipulating SQL Server Database using VB.Net   God Bless! Cedrick R. Blas undying_emolove@yaoo.com +639...



Visual Basic .NET 2008 Tutorial by on Oct 24, 2010Share In this tutorial I will teach you on how to create a Windows Application using Visual Basic .NET 2008. For the sake of this tutorial I will be using Library System as the system model. read more...



How to Create Database in SQL Server 2005 Express Edition by on Oct 24, 2010Share In this tutorial you will learn how to create a Database in SQL Server 2005 Express Edition. The name of the database that we are going to create is “LibSys” which stands for Library System. read more...



SQL Server – Using Temporary Tables by Lysender's Daily Log Book on Oct 24, 2010The original query was almost perfect – it displays the daily totals for a given month. However, specs changed and they need to add the grand total to the last row. Then another specs for the MAX and MIN rows. … Continue reading →...



SQL Server – Using Temporary Tables by Lysender's Daily Log Book on Oct 24, 2010The original query was almost perfect – it displays the daily totals for a given month. However, specs changed and they need to add the grand total to the last row. Then another specs for the MAX and MIN rows. … Continue reading →...