|
|
|
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 not to Rollback But transaction is Rollbacked Posted by mohamadzadeh_n NO[at]SPAM rayvarz.com at 12/11/2004 9:54:46 PM Hi
I have a database that its size is greater than 2 gig.
I want to create a new table and then alter it with transaction. I
dont rollback my transaction but when i Alter table i get this error :
"Column name 'MultyMediaDoc' does not exist in the target table"
I think my transaction is Rollback...more >>
How can I get the current connections on SQL Server? Posted by Wael Soliman at 12/11/2004 9:49:29 PM
Hi
I want to know how many users connected to the SQL server
Best regards
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
scripts for sql server 7, 2000 and higher Posted by vadim at 12/11/2004 8:34:26 PM Hi,
I distribute SQL scripts with my app that create table, indexes, triggers,
etc... For now I can not install certain features of sql server 2000 in the
scripts because they are supposed to run on both sql server 7 and 2000
because some customers have 7 and others 2000 versions.
My questi...more >>
TSQL equivalent of VBA Posted by smk23 at 12/11/2004 4:09:04 PM Greetings and thanks. How would I code
IIf(IsNull([col1]),"", [col1])
in SQL? I presume that I need a CASE statement which I can write, but how do
I check for whether the column is null or not?
TIA
--
sam...more >>
pbm with begin tran Posted by AR at 12/11/2004 2:40:45 PM Hi,
Here is one problem with BEGIN TRAN AND COMMIT TRAN
My Table structure is shown Below. It's used for Scheduling the training
Sessions for different Students.
The problem is that Whever 2 students simultaneously register for a seat, it
allows that seat to both. even if the
remaining sea...more >>
drop index @variable Posted by Joe Doherty at 12/11/2004 2:26:02 PM Hi,
Can someone tell me why the following statement fails?
declare @indexname varch(50)
set @indexname = 'myindex'
drop index @indexname
Is there any way round this?
Many thanks.
Joe
...more >>
Passing large amounts of text to append to an NText field on the s Posted by jlybbert at 12/11/2004 1:39:09 PM I'm using an MSACCESS 2000 Project with SQL server 7.0.
I need to pass the contents of a comment field to the Server and append this
information to the comments field (NText) there after the closing statement
is appended.
Thank you in advance,
Jeff
Here is the current stored procedur...more >>
Backup Issue! Interesting or weird - you decide! Posted by venAdder at 12/11/2004 12:55:01 PM I run this query in query analyzer
dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
'I get following error.
Server: Msg 3202, Level 16, State 1, Line 1
Write on 'c:\temp.dat' failed, status = 64. See the SQL Server Error Log For
More details.
Server: Msg 3013, Level 16, S...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
open_tran = 1 Posted by Ken at 12/11/2004 10:55:35 AM We use i-net sprinta jdbc driver and use pooled connections. What I've
noticed is that when connections are not being used and are in sleeping
state Open_Tran in the sysprocesses table is 1 and not 0. Anyone know
why? We commit our transactions.
...more >>
Padding strings Posted by Brian Burgess at 12/11/2004 10:36:35 AM Hi all,
Can I pad a string with '0'? For instance, I want to convert a numeric
value to a fixed length string (3 chars). If I 'CONVERT(CHAR(3), 1)', the
returned value is '1' instead of '001'.
Any way to handle this?
Thx in advance..
-BB
...more >>
Locks - simple question Posted by Jo at 12/11/2004 7:51:16 AM Can anyone tell me the difference between these
statements? I want to ensure that the max value selected
remains the max until I've finished my transaction and it
seems that in this case they do the same thing?
Thanks,
Jo
Select @id = max(id) from tTest (HOLDLOCK)
and
Select @id = max...more >>
Viewing Query Plan Text and Data Posted by babz at 12/11/2004 4:17:02 AM Hi
How to view Query Plan and data at the same time. I am using
Set ShowPlan_text off
It showing only the execution plan not the data. How to get the both?
...more >>
set based guru's help wanted Posted by Alex at 12/11/2004 4:14:22 AM
hi,
i have 2 tables s1 and s2. i want to 'consume' column 'q' of s1 with
column 'q' of s2 using only set based operations, without cursors or
while loops.
--ddl:
create table #s1(id int, q int)
create table #s2(id int, q int)
--sample data:
insert into #s1 values(10, 2)
insert into...more >>
Best Design Practice? Posted by Leon at 12/11/2004 4:10:22 AM I'm building a database that has maybe four unique tables Student,
Advertiser, Employee, maybe Account. Three of the four table (Student,
Advertiser, Employee) have something in common in which they all contain
fields such as emailAddress, password, role, isAccountActive, etc. which
allow th...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |