|
|
|
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 query between two database Posted by Agnes at 10/9/2004 11:50:34 PM I got two database A & B, and two tables table_A & table_B
I need to write a query to check (select numberId from table_A where
numberid not in (select numberid from table_B)
My problem is the tables are located in two database, How should I write
this query in SQL Analzyer ??
Thanks a lot
...more >>
Creating a stored procedure Posted by Jon Paskett at 10/9/2004 9:33:29 PM I want to create a stored procedure that can be executed from a web page
that will change the value of a field to its opposite value. What type
should it be?
SELECT table
Set field = !field
where ID = @ID
I'm looking for a NOT operator I think.
...more >>
Dulicate Rows Posted by Tome73 at 10/9/2004 6:49:07 PM I have two tables,
Table_buildings
Building_code
Name
Table_Phones
Building_code
Phone
There are two phone numbers for each building is there a way to return a
query where the building name and each phone are in one row.
Like this:
First_building, phone1, phone2
...more >>
Displaying Records in a Hierarchy Posted by AKG at 10/9/2004 6:23:09 PM Hi,
I need to display data (items purchased in a month) in a
hierarchy like below:
2004 10
Dec 05
Nov 03
Jul 02
2003 07
Nov ...more >>
Trimming extra spaces: Posted by Tome73 at 10/9/2004 6:19:02 PM Within the data I am using there are extra spaces at the end of some entries,
Using SQL how would I remove them?...more >>
Maximum number of tables Posted by S S Venkatesh at 10/9/2004 5:55:15 PM Hi
I am maintaning each table for a customer and number of customer
keeps on increasing. How should this be handled if the number of tables
keeps on increasing?
How many tables can a database have? ( I am using sql server 2000)
Can i create another database in another server if the data...more >>
Need help... Failed to reserve contiguous memory of Size= 65536. Posted by David at 10/9/2004 5:52:25 PM I have MS SQL 2000 Server SP3 cluster in active/active mode, windows 2003
with 4GB of RAM and 2 Intel Zeon CPU of 2.80 Ghz.
In the SQL Server Logs appear a lot of messages like this...
WARNING: Failed to reserve contiguous memory of Size= 65536.
Buffer Distribution: Stolen=2570 Free...more >>
INFOS - Management errors in SQL procedure Posted by M L at 10/9/2004 5:26:52 PM Hello World,
I'm searching informations about SQL Server.
What are the different solutions to manage errors like exception PL/SQL
management with Oracle ?
Thank's in advance for any information about tis subject.
M L
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Passing a DML to UDF Posted by anonymous NO[at]SPAM discussions.microsoft.com at 10/9/2004 5:21:12 PM Is it possible to pass a DML (Select * from TestTable) to
a UDF and have that DML parameter execute? If so, how?
Also, will this work:
sp_help fnTest('Select * from TestTable')
fnTest is a UDF that passes a string and returns a
derived table...more >>
Cloning a SQL Server table Posted by Arun at 10/9/2004 4:43:18 PM Hi,
Is there any way I can create a table identical to an existing table. I'm
not particularly interested in copying the data. But I just require the
table.
Thanks in Advance,
Arun
...more >>
Clear template in Store procedure Posted by Agnes at 10/9/2004 3:56:47 PM One day, I create stored procedure, and save the content as 'template',
Now , everytime i new stored procedure, it always show the old template,
How can I delete the template ???
I try to save a blank content as template, but it is fails, it also show
some ascii code As i new stored procedure
T...more >>
ASP / SQLServer connection Posted by Peter Morris at 10/9/2004 2:14:09 PM Hi, I'm having trouble connecting to SQLServer in my ASP program.
here's the code
<%
dim objConnection, ObjRecorSet, strConnection, strOut, objCmd, objParameters
Set objConnection = Server.CreateObject ("ADODB.Connection")
strConnection = "DSN=SQL_Tracker;Database=Tracker;UID=sa;PWD=;"
obj...more >>
what happened to the T-SQL reference on Microsoft's site?!?! Posted by Dave at 10/9/2004 2:01:28 PM Hi all,
I had a link to the T-SQL command reference on Microsoft's site that had
worked just fine for the longest time and now the link says everything has
moved.
I navigated for about 30minutes trying to find the darn thing with no luck,
I just keep getting useless links with nothing but "FL...more >>
INFOS - Input /output with SQL Server Posted by M L at 10/9/2004 11:52:11 AM
Hello World,
I'm searching informations about SQL Server.
Exist an equivalent Oracle Package utl_file_dir to read or writes files from
an SQL Server script procedure ?
Thank's in advance for any information about tis subject.
M L
...more >>
SQL 2000 multi-row trigger question Posted by ed at 10/9/2004 11:06:14 AM We are using triggers in our application to populate audit fields. I have
yet to find sample trigger code that handles a multi-row update in which a
primary key field is being updated.
Create Table T1 (Account int, ApprYear int, F1 int, Ts datetime, Employee
varchar(8))
Account and ApprYear...more >>
query Posted by RickN at 10/9/2004 10:25:03 AM Have a table such that
columna columnb
1 dog
2 cat
3 horse
4 cat
I want to write a query where I bring back a distinct list of columnb values,
along with any of the associated columna values.
Thanks,
--
Rick...more >>
SQL SERVER Rollback Problems Posted by Sajan Rajagopal.M at 10/9/2004 5:06:30 AM I have included a query (procedure) inside a begin and
rollback. The Query got Hanged and i stopped the
execution. Upon Stopping the query didnt get rollbacked
instead it got executed and i had lost few data as there
was a delete scripts inside my query.After that i executed
the ROLLBACK a...more >>
Store Procedure Posted by Jesus Cardenas at 10/9/2004 3:36:19 AM I've an inventory program where I need to know what can I do in the
following situation :
the inventory has 10 pcs from part number X,
let say user1 and user2 request both at the same time part X to use, the
program shows 10 pcs availabel for both user,
in case that they both(user1 and user...more >>
Table design issue Posted by babz at 10/9/2004 3:23:02 AM I have two tables Client and ClientLoc.
Client
ClientNo Char(4)
ClientName Varchar(50)
ClientDesc Varchar(100)
ClientTerm Varchar(100)
ClientStartDt Datetime
ClientEndDt Datetime
ClientLocation
ClientNo Char(4)
Area Varchar(100)
CityId Int
CountryId Int
And I have two histo...more >>
locking rows Posted by Jesus Cardenas at 10/9/2004 2:57:16 AM When programming in Clipper DBF's, you can lock a row to modifie it(multi
users program), I need to know a way to do the same in MSSQL...
in clipper there is a function called rlock it could tell whether you could
edit a row or not.
Because I'm upgrading my program from DBF's to MSSQL and as a r...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |