| Groups | Blog | Home |
|
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 31 Query read + update Posted by Jac at 8/8/2004 11:21:02 PM Hi,
Is it possible to write one query that do a read and update in the same time.
I want to read a value and at the same time augmenting that value.
Now I do it in 2 querys.
Select number from lastnumbers where code = 'BRF'
Update lastnumbers set number = number + 1 where code = 'BRF'
My...more >>
Help with Query Posted by ajmister at 8/8/2004 10:53:05 PM Hi
I have two tables
table coverage_a
(
f_name char (15),
l_name char (30),
year char(4),
month char(2),
start_date datetime
)
data in coverage_a table
joe cooper 2001 12 20020216
joe cooper 2001 ...more >>
DIfference of two tables Posted by Steve at 8/8/2004 10:00:16 PM Hi,
Is there a way that I can find the difference between two
tables. Using example here.
There are two tables here and the difference between them
is second row. (Cust_Table_A is loaded with new/updated
info. & Cust_Table_B has old info.)
Cust_Table_A
Cust_id Cust_Name Cust_Ad...more >>
SQL Select Syntax Help Posted by Gerald S at 8/8/2004 9:50:33 PM Hello,
I have an sql query question. I have 3 tables, Master M, Detail1 D1,
Detail2 D2.
M D1 D2
==== =============== ===============
M-ID M-ID D1-ID D1 M-ID D2-ID D2
------ ------- ------- -----...more >>
Relationships between tables located in different databases Posted by Huggle_Bubs at 8/8/2004 8:45:03 PM Is there any way that you can create a relationship between two tables that
reside in different databases?
One database stores tables common to more than one area of a business. They
are hardly ever updated, and are used primarily as lookup tables for combo
boxes etc....
Is what I am as...more >>
Single INSERT statement creates Duplicate Entries! Posted by Suler Abou at 8/8/2004 7:24:58 PM Hi,
I'm having a problem with an SQL statement, I have a statement that goes
like this:
"INSERT INTO table VALUES('TransID','CID',etc...);"
it basically adds new data to a table. When the form is posted it adds
the data just fine. However, when you try to add more new data it adds
the da...more >>
Summing tables in a UDF Posted by Andrew at 8/8/2004 4:31:59 PM I am having a problem translating a custom function
developed in Sybase into a SQL Server UDF.
I keep getting a 208 error - 'invalid object' when I try
to run call the function in Query Analyzer even though it
compiles without errors in the Enterprize Create Function
module.
The origin...more >>
Change values received to a stored procedure Posted by Raanan Avidor at 8/8/2004 3:50:00 PM Hi.
I have the below stored procedure.
In the @id_Type I get those values:
'IL'
'US'
'Whatever'
I need to insert into the W_Personal table the values:
if 'IL' then 'ID'
if 'US' then 'SSN'
if 'Whatever' then 'Whatever'
How do I do it?
CREATE PROCEDURE sp_imp_W_Personal
(
@Worker_ID ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to find out if a login has permission for an obj? Posted by ryu at 8/8/2004 2:48:50 PM Is there a way for me to find if there is a way to find out whether a login
has permissions for a db obj using only TSQL?
...more >>
Query against stored procedures Posted by Jacky Luk at 8/8/2004 2:14:32 PM How do you query against binary fields in SQL? (SQL Server/mySQL)?
I have tried the following, to no avail
select from s_proc where contents = '?ASdaljk'
But it always returned a null set, thanks
Jack
...more >>
FOR XML RAW Posted by Itzik at 8/8/2004 12:06:26 PM HI
This is my Stored procedure
"SELECT ID , TEL FROM WORKERS FOR XML RAW"
I TEL column iz NULL it is't create TEL child, only ID child created
can i solve it with definition of XML ?
...more >>
Moving Data To A mySQL Server Posted by marcoc NO[at]SPAM infosoftconsultants.com at 8/8/2004 11:42:09 AM I have a SQL 2000 server with many tables. I need to
continuously export any changes to table "A" from the SQL
server to the mySQL server. What would be the best and
easiest way to accomplish this.
Any help with this would be greatly appreciated.
Thanks...more >>
Relationship Between Indexes and Statistics Posted by hdsjunk at 8/8/2004 10:07:00 AM I have been using the Index Tuning Wizard to create
indexes on some of my queries. I noticed that the script
it generates has "Statistics" being created as well. Can
anyone tell me what these do, and what effect it would
have on the index if they were not added?
Thank you!...more >>
Reading Transaction Log Files Posted by Chris Bilson at 8/8/2004 8:53:24 AM This is going to sound old to anyone reading this newgroup regularly,
but I am really curious how some third party tools are able to read SQL
Server T-Log files, and wish I could do it too. Being able to read T-Log
files is invaluable in certain debugging and trouble shooting
situations, and...more >>
Start SQLServerAgent job Synchronously Posted by Nathan Holmes at 8/8/2004 3:07:03 AM Is there a SQL command that allows you to start a SQLServerAgent job such
that control doesn't return to the caller until after the job has completed?
sp_start_job lets me start a job (self-evidently), but it's an asynchronous
call and the caller resumes processing as soon as the call is made....more >>
Insert from table 1 to table 2 Posted by Aleks at 8/8/2004 12:05:03 AM Sorry for bothering so much, thing is I am converting an old database to a
new one and I am not exactly a SQL master, anyways here it is.
OLD TABLE: DELETETHISOLDCOMMENTS
UserId = This is an ID
Comments = text
NEW TABLE: Casecomments
COMID = This is the ID of the table, in this case I thin...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |