|
|
Browse by Tags
All Tags » Excel
Showing page 1 of 6 (54 total posts)
-
Download Autodesk AutoCAD 2008 here >>>
AutoCAD® 2008 software adds features to help make everyday tasks
easier. Annotation scaling and control of layers by viewport minimize
workarounds, while text enhancements, multiple leaders, and improved
tables help deliver an unmatched level of aesthetic ...
-
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
Forte.
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.
———————————————————————-
<html>
<script language="JavaScript" type="text/javascript">
<!–
var text = 0;
var message=new ...
-
–Create a table with all bad codes
DECLARE @mycode INT
CREATE TABLE #badcodes(badcode INT)
SET @mycode=33
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 ...
1 ...
|
|
|