|
|
|
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 RE: Async execution Posted by PeyoQuintero at 10/3/2004 11:27:14 PM Hi there:
Does anyone know how tu run a transact sql statement (or a SP) as a
background task without using SQL server job scheduling?. For example run
it from the command line using isql / osql but being able to close the
window. I am interested in leaving a long job running an not being c...more >>
Sql server not showing on startup Posted by Ganesh at 10/3/2004 8:49:51 PM Hi There,
I've problem with sql server, it's not starting up service, i can not see
icon, but sometimes it works why what's the problem
Thanks
...more >>
Why are the increments of transaction logs different on different SQL Servers? Posted by moonriver at 10/3/2004 8:23:40 PM I run an identical database application both loading &
deleting a great deal of data on two individual SQL Server
2000. All the settings are the same. The recovery models
on both SQL Servers are set to FULL as well. On one SQL
Server, the daily increment of transaction log is only
1MB. How...more >>
Is it possible to write and add in to sql server analyzer? Posted by Julia at 10/3/2004 7:38:43 PM
Is it possible to write and add in to sql server analyzer?
Thanks.
...more >>
Which database design is better Posted by dummy NO[at]SPAM 163.com at 10/3/2004 5:40:36 PM I have two tables, something like
Table Store
StoreID PK
StoreName
Address
Table Employee
EmployeeID PK
StoreID FK
Name
Address
Clearly there is one to many relationship here.
Now I need to specify an Employee of the store (who is a key person in
this store) for each store...more >>
Stored Procedures v Views Posted by Marek at 10/3/2004 3:47:03 PM Hi,
New to SQL 2000 - previously an Access person - pretty good at it too!
My question is about using a stored procedure or Views to return a
recordset. I have an Access database that I am converting in SQL. I have
some VBA code that generates a whole load of rows and displays the result...more >>
Deadlock Problem Posted by jallen_12342000 NO[at]SPAM yahoo.com at 10/3/2004 2:59:58 PM Hi,
I've got a deadlock problem. I have 2 simple stored procedures
below. One stored procedure does a simple select on the table
("stuff"), the other does an update on the table "stuff". I even
have put with (nolock) on the select statement, and yet still getting
a deadlock, here are ...more >>
How to insert a banner between news? Posted by Ragnar Heil at 10/3/2004 2:09:27 PM
I get a news-list with 4 items back from a SQL-query. That already works
fine.
Now I want to insert a banner after the 2nd news. Let's keep it simple,
if blnBanner = true then
<img src....>
end if
SQLQuery: "SET ROWCOUNT 4 SELECT COUNT(*) FROM mytable"
how can I do it?...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
how to find the filegroup name from the table name ? Posted by Satya at 10/3/2004 7:33:03 AM Lets say the table X is created on filegroup Y as
"create table X(col1) on Y"
and i only know this table name X . No idea about the Y .
So what query i should fire to find out which filegroup this table X belong
to ?
I want to know Y from X .
Please help .
Thanks ,
Satya ....more >>
Filter by date (month x) Posted by Guy Brom at 10/3/2004 2:20:15 AM Hi all,
I'm using a datetime column with getdate() value as the default for new
INSERTed values. I'm wondering how I can filter my SELECT list to show only
records from the current month, past month and past 2 months. Is there any
general method that will allow me to query month mm/yyyy ?
...more >>
Deduct a figure from a field? Posted by Reapes at 10/3/2004 1:38:15 AM
Hi All,
Can anyone tell me if it is possible to deduct a fields value by one from
within an UPDATE statement?
i.e. something like (this doesnt work):
"UPDATE PRODUCTS SET QUANTITY = -1 WHERE PRODUCTID='123456'"
Many thanks
Reapes
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |