|
|
|
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 Best Practices - SQL Transactions Posted by Don Miller at 4/30/2006 8:41:13 PM I have a web app (ASP) that does all updates, inserts by calling
transaction-supported COM+ components (with the transaction started in the
ASP page, i.e. transaction=required) that use ADO to call stored procedures
(that usually involve single tables). If there is any error (missing SP,
paramet...more >>
UNICODE question Posted by Ranginald at 4/30/2006 8:26:39 PM I have an INSERT statement that breaks when I try to use an apostrophe
s.
INSERT INTO tblProduct (name) VALUES('John\'s Store ')
name is varchar(20).
What is the correct formatting to produce the text John's Store
?
Thanks.
...more >>
SQL Server 2005: error: 26 - Error Locating Server/Instance Specified Posted by maneeshkhare NO[at]SPAM gmail.com at 4/30/2006 4:13:59 PM I have the following setup:
1. ASP.NET 2.0 web app hosted on a web server (inetpub directory
hosting physical files of the web site on a different drive name, E:
than the SQL Server Instance, which is on C:)
2. SQL Server on the same server, with security settings enabling
ASPNET group and grou...more >>
Splitting a String Posted by scott at 4/30/2006 2:52:03 PM I've got a field that contains a Name and Type seperated by a slash. The
only consistant "rule" of the EXAMPLE RECORDS is that each record is
seperated by a slash. As you can see, some contain numbers and some don't.
I'm failing miserably because of lack of knowledge of string functions.
Ca...more >>
SQL 2005: Replication: location of snapshot files? Posted by Mark Findlay at 4/30/2006 1:05:27 PM When viewing an instance's Replication properties in SQL 2005, clicking on
the "Snapshot" icon in the left side shows the options for the "location of
the snapshot files". The location can be a default folder or a designated
folder. Such as C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL...more >>
How do I make a field automatically get its values from another fi Posted by Sam at 4/30/2006 12:37:02 PM Hi,
In my table I have a "PaymentDate" field which is used to store payment
schedules for our clients. I want to add a new field in the same table and
call it "UpdatedPaymentDate" field as most of the time our clients don't
stick to original payment schedules.
How do I make the default v...more >>
Calculating Hours, Mins over 24 hour periods Posted by scott at 4/30/2006 12:26:00 PM Below I'm returning the decimal duration [decDuration], a HH:MM:SS format
without "padding" 0's [realDuration], and a HH:MM:SS format with "padding"
0's [realDuration2].
If you run my EXAMPLE, in RESULTS below you'll see that [decDuration] and
[realDuration] work fine, but [realDuration2] l...more >>
how to prevent 2 users from running the same front end process at the same time Posted by Keith G Hicks at 4/30/2006 12:13:05 PM I have a process in my application that should only be performed by one user
at a time. Some folks have suggested that the way to do this is to have a
table in the db that has a column to store the name of the user that's
running the process (a flag of sorts) so that if another user tries to run...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
COPY to a .txt file Posted by Roy Gourgi at 4/30/2006 11:34:53 AM Hi,
How do I copy the rows in my table into a .txt file comma delimited.
I tried COPY mytable TO '/presentation/myfile' WITH DELIMITER ','
but it does not work
TIA
Roy Gourgi
...more >>
how to ALTER COLUMN ? Posted by Helmut Woess at 4/30/2006 12:00:00 AM Hi,
i do a create:
CREATE TABLE myTable ( id int IDENTITY(1,1) NOT NULL)
and now i want to remove the IDENTITY definition from colum id
using ALTER myTable ALTER COLUMN id ... ??
so that column id has definition as when i do a:
CREATE TABLE myTable ( id int NULL)
How can i do this?
th...more >>
bug in string processing if the GO keyword is inside the string Posted by martin at 4/30/2006 12:00:00 AM I encoutered a strange behavior using the exec command and I could repreduce
the behavior with the print command:
the command:
print '1
2
3'
is doing it's jub, but if i add go inside the string I get the floowing
error:
print '1
2
go
3'
Server: Msg 105, Level 15, State 1, Line 1
U...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |