|
|
|
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 Does function get evaluated twice if used as criteria? Posted by Ian Evitable at 9/10/2005 10:56:30 PM Hello
This newsgroup seems to have deleted my previous messages?
So thanks to Louis here for previous help. I am now getting the resultsets i
want. Another question:
For the select query below, does the function dbo.ACEOr get evaluted once or
twice? I.e is the reference to db.ACEOr evaluate...more >>
Sp Help! Posted by Scott at 9/10/2005 10:03:01 PM I need to write a stored procedure which will insert the comma separated
values from a text file line-by-line into the SQL server database. I will be
using this stored procedure from front-end.
Can some one help??
Thanks alot.
Scotty....more >>
Prevent direct deletion from junction table in a many-to-many relationship Posted by Chris at 9/10/2005 9:02:25 PM I have created a many-to-many relationship on the following tables...
CommissionCodes, ItemCodes and the junction table Commission. Both sides of
the many-to-many relationship have a cascade delete.
I would like to prevent deletions from the Commission table directly. The
only way rows sh...more >>
How to send Faxes with VB6 Posted by hdeveloper7 at 9/10/2005 5:37:02 PM Is it possible to send faxes with info from a database. This is using Visual
Basic 6 and SQL Server 200.?
...more >>
TOP keyword Posted by simon at 9/10/2005 5:14:28 PM I have stored procedure with @rows int parameter.
Rows means how many rows should procedure returns.
How can I say (without dynamic sql):
SELECT top @rows * from table
regards,S
...more >>
Name of current db in proc Posted by Soeren S. Joergensen at 9/10/2005 2:28:55 PM Hi,
What's the best way to get the name of the current db (not filename, but db
name) from inside a sp ??
I'm writing a general sp that has to be put into numerous db's, except one
Kr.
Soren
...more >>
Is Northwind database fully optimised ? Posted by call me VK at 9/10/2005 11:53:13 AM Hi Guys
I am trying to figure out how to optimise a sql server database. For
starters I pumped in to the orders table of Northwind database around
120,000 records.
I have now queried the database to retrive those records.
A simple join query like this
SELECT * FROM Orders O INNER JOIN Empl...more >>
Challenging Search Engine Like Stored Porcedure Needed Posted by Jeff at 9/10/2005 11:47:08 AM (DML below)
First, thank you in advance for your help. Here's one for those of you that
like a little challenge, or perhaps this is a cake walk for you (I'm jealous).
This DB is to hold information so that our helpdesk can search it for
support information. The front end will be a Visual B...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Microsoft.ApplicationBlocks question Posted by Walter Levine at 9/10/2005 11:11:19 AM I am using this syntax :
retVal = (Int32)SqlHelper.ExecuteScalar(cn, CommandType.StoredProcedure,
"getEmployeeFromSSNO", new SqlParameter("@EmpSSNO", emp_ssno));
to call this stored procedure
CREATE PROCEDURE dbo.getEmployeeFromSSNO(@EmpSSNO varchar(12))
AS SELECT id
FROM ...more >>
Execute DTS package from .adp ? Posted by meyvn77 NO[at]SPAM yahoo.com at 9/10/2005 11:02:53 AM Hello,
Currently I save a DTS as a storage file. I then run the storage file
with VBA code in the .adp(Access Data Project). This works if you run
the ADP on the Server but the users of the .adp will be opening it on
the network from their machines. When they do it says missing
custtask.dll a...more >>
Template for Stored Procedures Posted by Craig HB at 9/10/2005 7:51:02 AM I am building a template to use for stored procedures that includes error
handling and rolls back transactions. If anyone can see any faults in the
template or can suggest improvements, please let me know.
By the way, checking the @rowcount after executing SQL is optional and will
change de...more >>
Find In...Stored Procedures? Posted by jpuopolo NO[at]SPAM mvisiontechnology.com at 9/10/2005 6:10:46 AM All:
Is there a way to do a "Find" across the text of a set of stored
procedures? (SQL Server 2000)
I am in the process of doing some code refactoring and have eliminated
a column in one of my tables. Now, I want to find all the stored
procedures that use the column name.
Is there a way ...more >>
SysViews and Systables Posted by Madhivanan at 9/10/2005 3:54:47 AM When I want to view all the table names and column names
I used following two queries
Select table_name, Column_name from information_Schema.columns
order by table_name
Select object_name(so.id),sc.name from sysobjects so inner join
syscolumns sc
on so.id=sc.id order by so.name
Both pro...more >>
HowTo:Dynamically Inject a Select Query Into UDF Posted by Ian Evitable at 9/10/2005 12:00:00 AM Hello,
Below is a UDF the intent of which i think is pretty clear. Trouble is it
doesn't work because of the attempt to dynamically inject/build select query
for cursor. Any help much appreciated.
Ian
CREATE FUNCTION dbo.ACEor(@ACEId int, @Authority nvarchar(100)) RETURNS int
AS BEGIN
...more >>
@@FETCH_STATUS... one per simultaneous execute? Hope not! Posted by Ian Evitable at 9/10/2005 12:00:00 AM Hello,
In another question i am using @@FETCH_STATUS . Below is an excerpt from SQL
Books Online.
"Because @@FETCH_STATUS is global to all cursors on a connection, use
@@FETCH_STATUS carefully".
Sounds silly but can anyone define a "connection" for me with respect to Sql
Server. I dont w...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |