|
|
|
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 Update row from values in another row in same table Posted by xMan at 10/13/2007 6:54:00 PM I would like help in writing an Update query that updates a row by its key
from values from another row by its key. There are many columns (10) to be
undated, but for this example I will settle for updating a single column. For
example:
CREATE TABLE [tblTest] (
[Rev] [int] NOT NULL ,
[I...more >>
Bulk insert on 2000 only works with varchar but not nvarchar Posted by huohaodian NO[at]SPAM gmail.com at 10/13/2007 6:49:11 PM Hi,
I just found out on my 2000, when I do a bulk insert, if I create the
table with field type of nvarchar, it always fail with error Server:
Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error
(truncation), but if I change the type to varchar, bulk insert works
perfectly ...more >>
Query not exit record Posted by huohaodian NO[at]SPAM gmail.com at 10/13/2007 6:38:04 PM Hi,
I have two tables, one temporary inserted from a bulk insert with
over 100000 user records, another one used by main application that
also has over 100000 records, now, I am try to find the best approach
to query or find the users who are in second main table but not in the
temporary tab...more >>
Attached SQL DB in VS2005 - Cannot open the DB Posted by RBC at 10/13/2007 3:31:00 PM Dear to Whom this Concern,
I have received a VS2005 web project with attached SQL DB, I can run the web
project (F5), Insert, delete, edit in DB, rebuild the project without any
errors; but I can not open the attached DB in VS2005.
If I double click on the DB in Solution Explorer in VS2005...more >>
Is there a way to "freeze" timestamp values Posted by Mike Kraley at 10/13/2007 2:36:02 PM I am using a timestamp (rowversion) column in some of my tables. Other
programs track these values to know what rows have changed since their last
update.
But when I want to make, for example, a schema change to the database that
adds a new column, and then I need to run an update query to...more >>
Using triggers to keep databases in sync Posted by hurricane_number_one NO[at]SPAM yahoo.com at 10/13/2007 11:59:37 AM I have a bunch of locations that have software running their own
database servers, then a central location that I want to poll each
location and have copies of all their databases. Right now I just run
a nightly backup and download every backup file to the central
location. I'd like to keep th...more >>
How to make use of SQLCMD within a Windows Service Posted by SqlBeginner at 10/13/2007 6:47:01 AM Hi,
From a windows service app I want to make use of SQLCMD utility so that I
can call a .sql file via that utility.
Any pointers regarding this would be of great help.
Regards
Pradeep...more >>
How To Supress Multiple Recordsets in T-SQL Posted by Charles Law at 10/13/2007 12:00:00 AM I have written a stored procedure that returns a recordset (or rowset, or
dataset, or whatever it is known as nowadays). However, in order to obtain
this recordset I need to run some dynamic T-SQL first. The only way I can
run it is using EXEC/EXECUTE, and so it returns the recordset to the ca...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Quick data uploads from remote machines Posted by Mark at 10/13/2007 12:00:00 AM Hi
Sorry if this is a little off topic, wasn't sure of the best place to post.
I'm converting some code that uploads data (xls and csv) to an Access
backend. The backend is being migrated to SQL Server and I'd appreciate some
pointers/oppinions about the best method to bulk upload the data...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |