|
|
|
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 August 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 Query about a Stored proc.. Posted by Vamsi at 4/11/2004 11:06:16 PM hi,
i have a stored proc which is like this..
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Code_Testing1]') and OBJECTPROPERTY
(id, N'IsProcedure') = 1)
drop procedure [dbo].[Code_Testing1]
GO
Print 'Creating procedure Code_Testing ....'
CREATE PROCEDURE dbo...more >>
Order of results in Union Posted by Thomas Scheiderich at 4/11/2004 11:04:44 PM I am trying to use a union and get the first select statement to show
before the second select.
In the following I have only 1 row. It consists of one word "ALL" that
I want to show first as it is going into a web drop down control. The
problem is that in Sql Server 6.5, it puts the "ALL"...more >>
update query not updating Posted by Tony C. at 4/11/2004 9:37:45 PM
Hi,
I'm trying to do an update query using a cursor but
it isn't updating the table. I have it in the debugger and
I can see it executing with the correct data in the variables,
but when I examine the tmpTicketItemToppings table nothing
is getting updated.
wierd....
It selects dif...more >>
recover mode and the transaction log file question Posted by Kent Eilers at 4/11/2004 7:20:52 PM It's been about seven years since i've worked with SQL Server...(ouch) and
I"ve been playing around with it on my home PC.
My goal is to get the transaction log filled. I've reviewed the new
'recovery mode' options and have set the recovery mode for my test database
to 'full' with the followi...more >>
newbie on creating SP Posted by Raymond Du at 4/11/2004 4:27:50 PM Hi,
I tried to create a SP, here is a snippet
Create Procedure spGetEmployeeTimeClock
@StartDate DateTime,
@EndDate DateTime,
@EmployeeID int = 0;
AS
if @EmployeeID = 0
select * into #tmp from TimeClock
where logTime>=@StartDate and logTime>=@EndDate
else
select * into #tmp from TimeC...more >>
Dynamic Where Clause in Stored Procedure Posted by Peter at 4/11/2004 3:51:03 PM Is there a way to have different number of expressions in a where clause? The following example explains the question
............
select ...
where color = 'green' and
quality = 'medium
But, sometimes, a user wants any color, the first is not needed. The question is ...more >>
Need help with update query Posted by Learner at 4/11/2004 1:55:34 PM I want to update a field called Qty in my table called tblSales in such
a manner that the Qtyfield in all records should be multipled by say 5.
How do I do this?...more >>
problem returning a uniqueIdentifier value Posted by Paul M at 4/11/2004 12:45:30 PM hi there,
i have a small database that creates a new order record, and i want the
stored proc to return the GUID as output..
i declared the output parameter as:
-----------------------------
@OUTPUTID uniqueidentifier OUTPUT
-----------------------------
and after the database record is...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Dedicated SQL Server Posted by scorpion53061 at 4/11/2004 10:48:46 AM Hi,
I have written a vb.net application that interacts with a mainframe system
that makes extensive use of SQL Server, mostly for data collection purposes.
This application was originally written around the accounting package I used
with my employer. Others that use the accounting package ha...more >>
need help with a simple query, i'm not too good with SQL Posted by Michael Beatty at 4/11/2004 9:42:40 AM I have a query with a field for player name, round date, round score, and
opponent
I need a query that displays the name of eachplayer, and the average score
for each opponent any help would be great. Thank You
...more >>
SQL Server & Visual Basic Connection Posted by Jitu at 4/11/2004 3:11:03 AM Hi
How can i create connection string when SQL Server running in a different network
1) my PC [192.168.2.88
2) SQL Server Running [128.168.9.8\SBIS
Exm
gsConnect = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=JituSea;Data Source=128.168.9.8\SBIS"...more >>
Job start by user Posted by John Celery at 4/11/2004 12:28:06 AM I make an ADO connection to MSDB using the sa account and
run sp_start_job @job_name = 'abc'
Sometimes in the job history it says 'job started by:
myDomain\someUser' instead of reporting that the job was
started by 'sa'.
Domain users have no Windows Auth privledge to the server,
so it'...more >>
Matching Strings In Different Tables Of Same Database Posted by Smith at 4/11/2004 12:13:56 AM I have a situation where I want to pull strings from one table of a SQL 2000
database and find matches for it in other tables of the same database and
have those values returned. i.e. In one table I have prospects and I want
to match their names to a table that stores the names of prospects tur...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |