Browse by Tags
Showing page 1 of 6 (53 total posts)
User Defined Function returns the numbers of days in month.It is very simple yet very powerful and full proof UDF.CREATE FUNCTION [dbo].[udf_GetNumDaysInMonth] (
@myDateTime DATETIME ) RETURNS INT AS BEGIN DECLARE @rtDate INT ......... http://blog.joggee.com/?p=51
Last June 19, 2007, at the Pearl Continental Hotel here in Lahore, I attended the Pakistan Developer
Conference 2007. The speaker was Stephen
He had shared the latest Database Training
techniques on SQL Server 2005 and I would
like to share these techniques and updates
because of its simplicity and for everybody to be ...
I am familiar with Goto Command since i was
using Visual Basic 6.0.
I wanted to prevent or bypass the execution in a
stored procedure and i used the same command
in Sql Server 2005.
Some details:................ http://blog.joggee.com/?p=49
If i feel this will help others i posted. The Continue statement skips the remaining statements in the loop body of a repetition statement and causes control to proceed to the next iteration of the loop.Code example for Visual Studio 2005 May 2004 Community Preview
` // Continue Statement in Visual Basic 8.0
` For using ...
Here is the single line of code for getting current webpage name.
Dim pag As String.................... http://blog.joggee.com/?p=66
To shrink the Trucated Log file.
Following code always shrinks the Trucated Log
File to minimum size possible.USE Master--You can replace with the database name but if it doesnt--works then replace with master databas)..... http://blog.joggee.com/?p=65
You can set timeout as your wish.
var text = 0;
var message=new ...
–Create a table with all bad codes
DECLARE @mycode INT
CREATE TABLE #badcodes(badcode INT)
WHILE @mycode<=255....................... http://blog.joggee.com/?p=52
All we know SQL Server 2005 has new features are going to discuss in this article is the Row Number function and Partitioning.
Normally developers used temporary tables and co-related sub-queries to generate calculated row numbers in a query. Now SQL Server 2005 provides a function, which replaces all of the additional resources we used to ...
Returns a null value.NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression........... http://blog.joggee.com/?p=57