Here's an update to my blog entry 3 years ago regarding the same topic: ---Calculates the first day of the previous month SELECT DATEADD (mm, DATEDIFF (m, 0, GETDATE ()) - 1, 0) AS [First day of the previous month ] ---Calculates the first day of current month SELECT DATEADD (mm, DATEDIFF (m, 0,...
[This 3-part series was written by Douglas Reilly who died early 2007. The articles were written in February to June of 2006.] This is the Part I of the series: The Value of Conferences And here is the Part II : The Benefit of Foru m Finally, Part III : Importance of Books and the Constant Change Author...
Its been months since i have'nt posted anything haha. I was addicted to photography indeed. Http://HumpreyCogay.BlogSpot.Com Any way i want to share one of my problems then. I've been coding SQL Querries for SQL Server for several years now, but working for the bank we use AS400 DB2 as a main...
[Description from website:] The Microsoft SQL Server support team uses several internally-written utilities to make it easier to work on a typical customer support case. These utilities may also be useful to database developers and system administrators who work with Microsoft SQL Server 2000 and Microsoft...
Suppose that you need to populate record set from a stored procedure. This is how it's being done: CREATE PROC NameList AS SET NOCOUNT ON SELECT Emp_FNAME, Emp_LNAME From Emp_Table SELECT FName, LName From Table_of_Names RETURN When you execute this Stored Proc, it gives you something like this:...
My New Year's Resolution List: 1. Prepare For The MCTS-SQL Server 2005 Certification (70-431) 1.a Self-Paced Training (Training Kit + Videos Lessons) 2. Prepare For The OCA Exam (1Z0-042) 2.a Review Oracle 10g Architecture and Administration 2.b Attend Class For the Oracle 10g Backup and Recovery...
I wrote an article a few years ago using SQL SMO and just realized today that I can also list SQL Severs without importing an additional assembly to my project ( Microsoft.SqlServer.Management.Smo ) by using the SqlDataSourceEnumerator class . SqlDataSourceEnumerator is a class that provides a mechanism...