|
|
|
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 trigger deleted Posted by Frank Dulk at 3/24/2007 7:32:38 PM In my system I have a table that records the stock movements and another
that records the balance of current stock of the product. The triggers
update the stock balance every time that movement exists in the stock table.
The trigger is the following:
Create TRIGGER [DELETEESTOQUE] ON [Estoq...more >>
Returning rows with duplicate fields Posted by Rick at 3/24/2007 11:12:46 AM I have a database table like this:
Unique Pdf Destination
1 one.pdf a
2 one.pdf b
3 one.pdf b
4 two.pdf x
5 two.pdf y
6 two.pdf z
I want to return all of the rows where a Pdf field has duplicate
Destinatio...more >>
Try Catch in a user function Posted by Jeremy at 3/24/2007 10:27:26 AM Try-Catch blocks aren't allowed in user functions. What do you do instead?
I'm writing a function that casts the input as follows
declare @input as varchar(3)
cast (@input as integer)
I'd really like to gracefully handle cases where the input data is screwed
up.
Jeremy
...more >>
DB Maintenance Plan SQL 2005 on 6300+ Database Posted by Icemokka at 3/24/2007 8:38:51 AM Hi,
We have a SQL-cluster with over 6300 databases, most of them pretty
small in size and usage.
For this reason all these databases are on auto-close ( Otherwise SQL
would need many many gigabytes ).
We've recently upgraded to SQL 2005 because of the Management Studio,
because the EM is u...more >>
Dynamic TODOs in VS2005 SQL files Posted by myronschroner NO[at]SPAM yahoo.com at 3/24/2007 7:48:30 AM Hi all,
I'm using VS2005 for DB Professionals, and in my project I've got a
SQL file in which I want to add a task that will be shown in the
Pending Changes list.
1. Is that the right place that it will show up? (Is this the same as
the "Task List"? Help mentions View:Other Windows:Task L...more >>
INSERT Procedure Posted by Juan Puebla at 3/24/2007 4:37:03 AM Hi,
I'm trying to insert a new row (INSERT INTO) with a SELECT clause. I made
this example to make it clear:
@Name NVarchar(100),
@CountryName Nvarchar(100)
INSERT INTO Clients (Name, IdCountry)
VALUES (@Name, (SELECT IdCountry FROM Countries WHERE CountryName =
@CountryName))
I kn...more >>
equivalent of MySQL's SQL_CALC_FOUND_ROWS function? Posted by Janet at 3/24/2007 2:56:35 AM Anyone know if there's a built-in equivalent to MySQL's SQL_CALC_FOUND_ROWS
function?
...more >>
Group By Week Posted by MikeB at 3/24/2007 12:00:00 AM Hello All, I am new to sql and have a questions. I have the following
table and need to group it by Week. Is there anyway to do this in the SQL
and if so can someone please help me out?
Table 1
id PK int
userid FK int
CategoryID FK to table 2 int
qty int
date smalldatetime
Example ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Visual FoxPro 9 tables to SQL Server 2005 tables! Posted by Ioannis Stefis at 3/24/2007 12:00:00 AM Hi to all!
How can I transform my Visual FoxPro 9 tables in SQL Server 2005 tables?
Thanks in advance
...more >>
Select top .... order by Posted by Ressiv Kire at 3/24/2007 12:00:00 AM Hi,
OK, learned the hard way not to use SELECT TOP 100 PERCRENT ...
but are there any disadvantages in changing the views where this is used
into
SELECT TOP 999999999999999999 ....
Erik
...more >>
Data transfer Posted by simon at 3/24/2007 12:00:00 AM I would like to transfer data from one table in first sql server to the same
table on the second sql server.
But I would like to transfer only data for products, that are marked on
second server, so I must include some logic which data to transfer.
I can do that easily with linked server - j...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |