Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Exploring the window functions in SQL Server 2005
- Maybe I'm missing the significance of this?I don't get the usefulness of this technique. I even looked at the MSDN documentation, and I still see no reason to use it. This accomplishes nothing that I can't do with some sub-query work, at least as far as I can tell.Hopefully someone...
- Tags: Process improvement, Microsoft SQL Server 2005, Microsoft SQL Server, MichelliL@..., window, ut.sCode, u.hMy, join, p.sAddr1, Group-By
- Discussion threads 2007-03-20
- What comprises a SQL Server DBA?
- Hi all,My question is regarding what makes up the job title of DBA. I am currently working in a SQL Server position, but doing a lot of scripting for reporting purposes. Obviously, this isn't a DBA position. However, I want to move into that area, as there is no growth...
- Tags: certification, dba sql server, IBM DB2, IBM DB2 Universal Database, MichelliL@..., Microsoft SQL Server, Oracle Corp., server, software
- Discussion threads 2005-11-29
- Using recursion in stored procedures
- Conditional RecursionI wrote this function to help me on a query I was working on. It uses recursion in the case where you want the last day of a month.-- =============================================-- Create scalar function to convert dates-- based on user input. Useful to find-- first day of month, last day of month-- and...
- Tags: DateAdd, DECLARE @dtNew DATETIME, MichelliL@..., recursion, routine, SELECT SENTINEL.DBO.udf_Dates, SENTINEL.DBO.udf_Dates, software
- Discussion threads 2005-05-10
- << Previous
- page 1 of 1
- Next >>
