|
|
|
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 31 Newbie, how to run a SP on a remote server Posted by verci at 10/28/2006 8:33:51 PM Hi guys,
I'm running SQL Server 2000, I'm working on server A but want to run a SP on
server B which it's not linked to server A from a Stored Procedure I will
create on server A, is there a way to do this?
I've credentials and access rights on both servers but for some weird
company po...more >>
declaring variables Posted by Keith G Hicks at 10/28/2006 8:26:45 PM In a trigger, function or procedure, what's the difference between this (one
has "AS" and the other doesn't):
DECLARE @MyVar AS INT
and this:
DECLARE @MyVar INT
Other than just technique? They both seem to work fine. I have tons of code
with the "AS" and lots without. I can't find any ...more >>
How do I export to flat file using code? Posted by Andrew F at 10/28/2006 7:25:01 PM Hi
I used to export from a sql table to a flat file in .net using
SQLDMO.BUILKCOPY in SQL 2000.
How do I export to a flat file in .net 2 for SQL 2005?
I don't want to pre-create an SSIS package.
I can't find a bulkcopy equivelant in SMO.
The new SqlBulkCopy in system.data.sqlClient appea...more >>
Need SQL programmer help for SPCA Posted by J.R. Sitman spcaLA at 10/28/2006 6:39:02 PM I'm the MIS Director for The Society To Prevent Cruelty To Animals Los
Angeles. We are a non-profit and all of our funding comes from the public.
We have no government assistance. We have an Access database that was being
converted by a volunteer SQL programmer. Unfortunately his time has ...more >>
Import Excel into table where table name is parameterized Posted by David Shorthouse at 10/28/2006 5:10:19 PM Folks,
I just configured an upload application in pure asp for client Excel files
along with user-selectable sheets and subsequent field matching to a
specified, server-side column name and order. So far so good. My idea is to
now design a dts package that will accept the Excel file name, s...more >>
Sql server datatype Posted by RS at 10/28/2006 12:13:01 PM Hope someone can help with this
I want to capture 1-1/1000 into a field without rounding decimals.
The answer is .99009
However doing this calculation in sql server does not get me this and always
rounds
the answer. How can I prevent this.
Thanks in advance...more >>
ALTER COLUMN datatype question Posted by Keith G Hicks at 10/28/2006 11:38:05 AM I need to change a column's datatype via:
ALTER TABLE Custs ALTER COLUMN CustNotes TEXT
(the type used to be varchar(1000).
However, I need to test if the type is already text before running the
alter. This is the idea:
if Custs.CustNotes datatype <> "text" then
ALTER TABLE Custs A...more >>
something is broken Posted by Paul Pedersen at 10/28/2006 8:22:54 AM I'm using MSSQL 2000.
I have a table with a half-dozen contraints. In Query Analyzer if I right
click on some of the constraints and choose "Script to new window as
create", I get a create statement for the wrong constraint! If I try that on
other constraints, Query Analyzer suddenly quits ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Deletion Posted by Sundara Murthy at 10/28/2006 5:54:01 AM Hi all,
I need ur help.
I have data like this.
Table name : Inventory
------------------------------------------------------------
ID Name WareHouse Qty
-----------------------------------------------------------
1 Lemon ...more >>
Locking question redux Posted by Derek at 10/28/2006 5:53:27 AM
Sorry for asking this question again, but I haven't received an answer
to what
I think is a simple answer to an easy question
if i'm in a transaction
begin transaction
{some code here}
select from sometable (serializable,tablockx)
{more code}
commit
are (serializable, tabloc...more >>
Intgrated Security SQL 2005 - can't connect to first DB? Posted by Jason at 10/28/2006 3:16:39 AM Fresh install of SQL Server 2005 client and tools.
I create a new database . I check security and and it looks the same as
msdb
>From VS.NET>NEW REPORT I can connect to all the standard dbs like
master, msdb etc, but my new db, I cannot giving me error:
A connection cannot be made to the ...more >>
SQLCLR UDA Part Deux Posted by Mike C# at 10/28/2006 12:31:46 AM OK, so I have a small UDA that needs to store the data it reads in
temporarily in an ArrayList before performing calculations on the values.
It works fine for small numbers of rows, but breaks down with an error like
this:
A .NET Framework error occurred during execution of user defined rou...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |