Dear all, How can get difference between two date in sql 2000. say my startdate is '2008-01-01 00:00:43.753' and enddate is '2008-01-01 00:00:44.783'. i want...
Check this select datediff(ms,'2008-01-01 00:00:43.753' ,'2008-01-01 00:00:44.783') Madhu ... 01-01 00:00:44.783'. i want the difference even to millisecond...
Try this link: http://www.sqlservercentral.com/scripts/T-SQL+Aids/30242/ You may have to register to view this page, but registration is free Best Regards, ...
Hi All, While creating Publisher on SQL 2000 I am getting error "Process could not access database ... of server...". I have checked the owner and every...
Hi All, While creating Publisher on SQL 2000 I am getting error "Process could not access database ... of server...". I have checked the owner and every...
Hi All, I have made a few blog posts on generating subtotal/total rows as part of the query results, this week. These posts examine different options using...
Hi All, I have 10 partitions on a table. Now I want to remove 2 out those 10. I dont even want to save the data in those patitions. What's the fastest way to...
Hi, There is nothing so complicated about the LEN() function. But I observed a few interesting points about its behaviour in different cases. I have posted my...
Hi, I have been writing about the SET options of SQL Server and wrote about ANSI_NULLS and ANSI_WARNINGS. I was in the middle of a post that discusses SET...
Hi, SQL Server does not have built-in support for comparing two XML values and determine if the content is equal. I have posted a tutorial that creates a TSQL...
Hi, I wrote a TSQL function that returns the dependency chain of an object. The function reads data from system catalog views and implements a recursive query...
The Last free trail version 2.0 for trainig .......click here <http://jabr-fx-online-trading.blogspot.com/> [Non-text portions of this message have been...
Hi All, I need document to prepare the backup policy for my company;can any one provide the sample document for the same. Thanks and Regards Alok Gautam...
1)What is Forex? 2)How can i start trading Forex? 3)Who own Forex and where is it located? 4)What the working hours of Forex market? 5)What is margin? 6)What...
Hi I am writing a series of posts on performing recursive updates in TSQL. You can find the posts here: TSQL Lab 10 - Writing a recursive procedure to update...
Hi, As we all know, SQL Server limits recursion to 32 levels. I have written a post that demonstrates how to write a recursive procedure that can process more...
Hi, SQL Server 2005 introduced the XML data type. Thought the XML data type is designed to store and manage XML documents, it can be used to solve a number of...
Hi, I suppose, many of us have renamed stored procedures, views, functions and triggers several times in the past. Sometimes renaming such objects can give you...
Jacob, Where is the PASSÂ happening this year? Â With :))s Santhosh Kumar S.J - MCTS ReadMe @ sqlspy.blogspot.com ReadMe @ santhoshpakkangal.blogspot.com ... ...
Transforming rows to columns (PIVOT/CROSS TAB) and columns to rows (UNPIVOT) may be one of the common requirements that all of us must have seen several times...
Hi All, The server is in mixed mode authentication. we have removed Builtin Administrators account and sa has been removed. how can we reset the sa password...
Try to connect SQL Server with windows login and then go to change SA password. Nitin ... From: Shyam Sunder <shyam_k25@...> To: sqlcon@yahoogroups.com ...
I shared with you a few posts, last week, discussing recursive updates in SQL server. We discussed the example of an ecommerce application that needs to...
how come sa will remove , if already you have dropped buildin\Administrator.. very surprising .. ... From: kunal choudhary <nitin_mca_23@...> Subject:...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
