|
|
|
March 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 |
Filter by week: 1 2 3 4 5 UPDATE server_table INNER JOIN local_table Posted by Ron Hinds at 4/7/2004 4:33:56 PM I've been converting a large Access 97 app to use SQL 2000 for the BE. I
have solved pretty much all of the performance scenarios except this one:
updating a server table and joining it to a local table, e.g.:
UPDATE server_table INNER JOIN local_table ON server_table.field1 =
local_table.fiel...more >>
SQLDMO will not register via regsvr32 Posted by jmeehan at 4/7/2004 2:46:03 PM I am trying to install SQL-DMO using the instruction to register the SQL-DMO components on a client computer. I am using the SQL-DMO components to find all the SQL servers on the network. This list is used by the user in making their connection. When I execute the REGSVR32 SQLDMO.DLL command the f...more >>
error executing query Posted by Warren at 4/7/2004 10:51:04 AM I have a database running on MSDE it was working fine. Recently when I try to select from the database I am getting the following error after a few records have been returned. All of the tables are giving this problem. Not sure what to do
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionChec...more >>
SQL server setup guide Posted by IT at 4/7/2004 10:48:13 AM Hello,
I am new to SQL server but not to databases. I am looking for a step by step
tutorial on how to install and setup SQL server. Any ideas please?
Cheers
...more >>
Registering SQL Server - Warning - The client and server codepages do not match. Some ANSI character mappings may not be possible. Posted by Dave Spencer at 4/6/2004 1:31:10 PM I get the following message when I try to register a SQL Server in EM.
Warning - The client and server codepages do not match. Some ANSI character mappings may not be possible.
This is not an issue that is going affect my work, but just want to know how to fix it. Using rebuildm I changed the C...more >>
how to detemine a client is alive? Posted by frank at 4/5/2004 7:11:04 PM can i use this method -- inserting a new row into table!...more >>
does anyone know file backup operation? Posted by frank at 4/5/2004 7:11:03 PM in work , I usually use full backup .
i think file backup will be more useful ,but the information of it is rare
if anyone use it before ....more >>
.sql File Posted by Noorali Issani at 4/5/2004 6:54:01 PM Dear Professional
I want to export the stored procedures, functions and tables into
textfiles.sql Like if there are 100 tables then it will create 100 sql files
and if there are 200 stored procedures then it will create 200 sql files,
how can I do this task.
Thanks
NOOR
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Share the folder from MS DOS Posted by Noorali Issani at 4/5/2004 4:49:32 PM How can we share any folder from MS DOS command, can any body tell me
regarding this
Thanks
NOOR
...more >>
How do I find I am administrator? Posted by Sunny at 4/5/2004 3:26:18 PM This is the first time I will be using SQL server although I have good
experience in FoxPro and ACCESS database, I have limited knowledge of SQL
server.
We have installed SQL server 2000 on WIN2K. Our IT people has installed
Enterprise Manager on my win2000 workstation. How do I find I am in a...more >>
optional parameters in stored procedures ? Posted by Chris at 4/3/2004 11:50:14 AM Hi,
I have a stored procedure :
CREATE PROCEDURE sp_MySelect
@ID int,
@city varchar(6),
@ccountry varchar(6)
AS
SELECT * FROM MyTable
WHERE
(ID = @ID or (@ID is null))
AND (City = @city or (@city is null))
...more >>
CAL and POS software Posted by microchp at 4/3/2004 10:01:05 AM I have a client that is migrating to SQL Server as the D/B for their POS software. The software uses a Pool Manager to exchange data with the D/B. The pool maintains 3 active connections to the D/B per module instance. The POS clients connect to the Pool Manager. Considering that their are only ...more >>
Stored procedures Posted by Chris at 4/2/2004 7:17:10 PM Hi,
I have a stored procedure and one of the parameters is of format
smalldatetime.
What is the format of the parameter when I call the SP ?
CREATE PROCEDURE sp_My_Insert
@org int,
@aDate smalldatetime,
AS
INSERT INTO MyTable(Org, ADate)
VALUES (@org, @aDate)
GO
How do I call this S...more >>
DateTime in UTC format Posted by Keshav at 4/2/2004 10:20:43 AM Hi All,
I have the following table structure=20
CREATE TABLE [test]=20
([dd] [datetime] NULL)
I have a stored procedure to insert values to the above table. The SP is =
invoked from a .NET application written in C#.=20
I have to store date time in UTC format.I am able to convert local da...more >>
sp_dropsubscription Posted by Noorali Issani at 4/2/2004 9:34:37 AM I have used the following commands for removing the article, first command
executed sucessfully but second command gave me an error, can any body tell
me ?
sp_dropsubscription 'LMS' , 'Category','NOOR\NN', 'LMS',1,1
The command(s) completed successfully.
sp_droparticle 'LMS' , 'Authentica...more >>
Triggers - Urgent Posted by Noorali Issani at 4/2/2004 9:15:03 AM I have one problem regarding activation of trigger.. basically I made one
procedure and through that procedure I am inserting data into one table
named "ALERT" and I have made trigger on Alert table on the insert event,
what that trigger is do just inserting the data into another table against
s...more >>
SQLServer Client products Posted by Senthil at 4/1/2004 2:56:06 PM There is a sqlserver running in a different machine.
What are the client tools available for me to access them (I have to buy them or they are free)
Thanks
Senthil...more >>
Domain to Workgroup connections Posted by Mark Hutchings at 4/1/2004 3:21:11 AM Hello everyone,
Here's the setup:
I'm trying to get an basic ADO application on my
workstation (Win2K Pro, on a domain), to talk to SQL 2000
on a server (Win2K Server, on a workgroup all by itself).
The SQL server is using Windows Authentication.
Any ideas how I can get this to work?...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |