|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 %Rowtype in SQL server Posted by Chandra at 9/24/2006 11:39:01 PM Hi,
I'm in the process of converting an oracle stored procedure into Sql server
2005.
Please let me know if there is any alternative in SQL server 2005 for
%Rowtype while working with cursors.
Thanks in advance
Chandra....more >>
retriev employee information with the help of password encryption Posted by Muhammad Ahsin Saleem at 9/24/2006 10:39:19 PM i have a problem that i have encrypted the user password but don't know
how to retrieve information against that user i have written a store
procedure but it does not work kindly if any body can help me, then do
help me its urgant
i have 4 collums in my tbl_login table
1=2E emp_name cha...more >>
selecting and locking a record from distributed DB Posted by Muhammad Ahsin Saleem at 9/24/2006 9:33:15 PM hi
everyone I have a problem that I have an application having a shared DB
and I want that when I retrieve a record from database for one machine
then that record must be locked so that others couldnot modify that
record. I need urgant help I shall be thankful to all of you if anybody
can help ...more >>
cumulative problem Posted by Gogzilla at 9/24/2006 9:06:02 PM Hi all
I would like to calculate the cumulative summation by ordering the
descending type from htese below data,
Id Status Item Description Score Amount
9/16/2006 5:00:02 PM DD 1 Topic 1 Good 1
9/16/2006 5:00:02 PM DD 2 Topic 2 ...more >>
Calculating Percent Posted by Chamark via SQLMonster.com at 9/24/2006 5:38:29 PM I get zero when I do this calculation and I need help. I want to calculate
the percent of employees that have been evaluated against total number of
employees. I tried this
COUNT(Evaluated_.Employees) / Total_Number_Employees
So Evaluated employees = 368 divided by total number of employees...more >>
Simple syntax question Posted by Rudy at 9/24/2006 2:21:02 PM Hello All!
A simple question, kinda dumb really. Get a syntax error of "Incorrect
syntax near the keyword 'set'."
DECLARE @Type varchar
DECLARE @Model varchar
DECLARE @Engine varchar
DECLARE @Trans varchar
DECLARE @UserID nvarchar
Update Plays (Set Type = @Type, Set Model = @Model, SET ...more >>
SqlContext does not contain a definition for GetCommand() Posted by TenDot at 9/24/2006 10:57:02 AM I want to do a query that arranges columns into rows. I'm thinking it's
easier to do this in .NET code in the SqlServer CLR than in T-Sql.
I've got the following using statements:
using System;
using System.Data;
using System.Data.Sql;
using Microsoft.SqlServer.Server;
using System.Da...more >>
prevent concurrent reads of a table... Posted by Kurt Hill at 9/24/2006 2:22:32 AM Hello all,
PLEASE NOTE: Identity values are not an option for this table.
I need a procedure that prevents duplicat "packet" numbers from being
assigned. The procedure is below. What I want it to do is lock the
packets table so as to prevent another user from accessing it at the
same ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
join order question Posted by JB at 9/24/2006 12:00:00 AM Is there anything (articles, blogs...) online that fully explains the
precedence or processing order of joins? I'm interested in explaining the
following case:
A left join B inner join C
Why is it that the left join processes before the inner join and therefore
in some cases brackets are...more >>
find connection killer Posted by Ganesh at 9/24/2006 12:00:00 AM Hi There,
I'm running a schduler all the time, it should be connected to the server
all the time. But i'm getting error message connection failure due someone
or some process kills the connection.
I would like to know how the connection get disconnected or being killed, is
it possible ca...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |