|
|
|
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 How to perform a Update/Insert - in SQL 2005 Posted by KarenM at 12/16/2006 11:45:03 PM I have a source table and target table of the same structure.
My source table is a staging table I want to read records in my source
table and if the record does not exist in the target table do a insert
if the record is already in the target table I want to do a update if
the non-key fields h...more >>
Just wondering... Posted by Shocky at 12/16/2006 11:43:14 PM Am using SQL Server 2000.
I just came across the following.
Consider the below query
select distinct.tbl.Col1
from tab1 tbl
The above select statement works fine (Notice the dot after distinct :
DISTINCT.TBL.COL1)
However if i remove the table alias it does not work
select dist...more >>
Dynamic sql with text data type? Posted by Adam J. Schaff at 12/16/2006 6:24:01 PM Hello. I have a table containing a column of data type "text". It contains a
where clause which I want to select and append to a select statement. I then
want to execute the entire thing dynamically using EXEC.
The problem is, I cannot declare a variable as "text". How, then can I
execute m...more >>
Encrypting in SQL Server 2005 to hide data for sysadmin? Posted by jonas.berling NO[at]SPAM knowit.se at 12/16/2006 11:21:44 AM Hi!
Would it be possible to use encryption in SQL Server 2005 and make it
impossible for the sysadmins (incl. 'sa') to decrypt the data? We
thought of certificates protected by a password, but we would then have
to pass the password as a parameter to our stored procedures and all
the 'sa' nee...more >>
Run DTS from .NET application by using DTSRUN Posted by Citrosa NO[at]SPAM gmail.com at 12/16/2006 10:55:38 AM Hi,
I run a DTS from my VB.NET application by using DTSRUN. The result of
this is well sometimes, but at most of time, the data in a table is
well, but another table is empty. Could you please help me? Thanks.
Linda
...more >>
Extra unused tables in database Posted by Sandy at 12/16/2006 9:48:00 AM Hello -
A fellow developer and I were talking about the effects of extra tables in a
database that are not used and whether or not they would affect performance.
In this hypothetical, the extra tables are never accessed. (I am not talking
about extra columns in a table that may be used by...more >>
Anybody know when SP2 for SQL 2005 is coming out? /EOM Posted by Ronald S. Cook at 12/16/2006 9:20:09 AM
...more >>
how to get Day of the week Posted by Ather Mian at 12/16/2006 12:19:39 AM Hi,
I am using SQL Server 2005. I have table which contains inventory balances
by day. And it contains a date column like 12/16/2006 . I need to write a
query which fetches balances for last 52 Thrusdays . If the balance is 0 on
Thrusday then take the day before it where the balance is ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |