|
|
|
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 Triggers and transactions...any way to defer trigger execution? Posted by Jonathan Furman at 10/10/2004 11:29:45 PM Hello everyone. I was hoping that someone could give me a quick answer to a
trigger question. The question is: do AFTER UPDATE and AFTER DELETE triggers
always fire exactly when the UPDATE or DELETE statement is issued,
regardless of any pending explicitly defined transactions?
The reason I as...more >>
Need Help DTS Failed Posted by Adi at 10/10/2004 10:47:02 PM Hi,
i m facing this error when running DTS on IDENTITY(1,1) Field.
how can this field increment automatically ???
ERROR:
---------
Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. (M...more >>
unmatched rows Posted by Richard Wilde at 10/10/2004 9:13:10 PM I have a clubs table a members table and a categories table.
Clubs is linked to members via idClub. Many members to one club
Categories is linked to members via idCat. Many members to one category
I want to be able to code a query that will return any categories that have
not been assigned t...more >>
Check if a table has a specific column Posted by Agoston Bejo at 10/10/2004 8:26:10 PM What I'm trying to do is check if a table has a column called 'X' and if it
hasn't then add it to the table.
How can I check (from a stored procedure) whether a column is in the table?
...more >>
parameters, MS Graph Posted by zlatko at 10/10/2004 8:02:17 PM Does anybody know how to pass parameters to the stored procedure (or in-line
function) that is used as row source for MS Graph in a form of Access
Project ???
There is no Input Parameter property on the MS Graph....
Thanks.
zlatko.matic1@sb.htnet.hr
...more >>
Changes made in Query Analizer don't show in Enterprise Manager Posted by Agoston Bejo at 10/10/2004 8:00:39 PM If I run e.g. a table-creating sql statement then the changes won't show in
Enterprise Manager no matter how many times I refresh. They only show if I
restart Enterprise Manager.
1. Is there a way to get EM to reflect the changes made in Query Analizer?
2. I couldn't seem to find a way to ru...more >>
how can i write the sql statement? Posted by anonymous NO[at]SPAM discussions.microsoft.com at 10/10/2004 7:46:54 PM I have a table like this:
code dept money
a dept1 2560
b dept1 2584
c dept1 36852
d dept1 36952
a dept2 2503
c dept2 3685
a dept3 589
d dept3 560
How can convert it to the table like this:
dept1 dept2 dept3...more >>
Passing parameters to MS Graph in Access Project Posted by zlatko at 10/10/2004 6:40:35 PM Does anybody know how to pass parameters to the stored procedure (or in-line
function) that is used as row source for MS Graph in a form of Access
Project ???
There is no Input Parameter property on the MS Graph....
Thanks.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Colun values not retrieved? Posted by Mauricio Freitas [MVP] at 10/10/2004 6:39:52 PM I have an ASP script which works fine on MS Access
Replaced this with MS SQL, and most of it works fine. Except that for a few
columns, regardless what I do, I never get a value. For example even a
SELECT * FROM USERS WHERE USERID=123... If I do this on SQL Query Analyzer I
see all columns....more >>
How to optimize the SQL query? Posted by kjsgrp NO[at]SPAM gmail.com at 10/10/2004 4:47:02 PM Hi Friends !!
My problem is that I have two tables, say...tblMasterOrder &
tblMasterCustomer.
The main fields in these Tables are
tblMasterOrder:-
OrderId Int -- This is a Primary key
CustomerId Int -- This key is linked with tblMasterCustomer
OrderDetails Varchar(100)
etc etc
tblMast...more >>
inserting text problem? Posted by Raed Sawalha at 10/10/2004 3:59:49 PM Dear:
I have a database with following columns
ClientID char(12)
BlockReason varchar(256)
Report varchar(4000)
the problem here in Report column , the report generate by the Visual C++
application is not fixed lenght sometimes may be 4000 length sometimes 8000
length ,...etc
how can ove...more >>
Primary Key: I am trying to understand--please help if you can Posted by Mavis Tilden at 10/10/2004 2:08:55 PM Hi all,
So I've been reading the newsgroups, and reading a few books trying to learn
SQL and SQL Server 2000. The books tell me I need a Primary Key, and that
every table should have one. I know (I think) that a Primary Key is a
special field that uniquely identifies each record or row with...more >>
Best Newsgroup for DMO? Posted by Jon Robertson at 10/10/2004 1:46:07 PM What is the best newsgroup to post a question about DMO? I expected
this would be, but there's been no response. This group seems to be
discussions on database design and "proper" SQL syntax. Certainly not
what I expected for "sqlserver.programming".
Thanks
--
Jon Robertson
Borland Ce...more >>
Database-level password Posted by F. Halmi at 10/10/2004 1:11:23 PM Hi!
How do I set a database-level password on an SQL Server database?
Thanks F. Halmi
...more >>
Attach/Detach database Posted by vul at 10/10/2004 11:37:53 AM I need to copy my SQL Server 2000 database from my development machine to
the server of one of the client. By using Enterprise Manager I was going to
detach db from my server, create a database with the same name on a new
server, detach it, replace files on the new server with my copies and attac...more >>
An Uncooperative Self UPDATE Posted by Robert Robichaud at 10/10/2004 2:02:06 AM I'm trying to copy the values in 4 fields into another record in the same
table. My code is as follows:
UPDATE [OrderDetailsFreeFormat Temp]
SET ProductID = [FromTable].[ProductID],
Description = [FromTable].[Description],
[Unit Price] = [FromTable].[Unit Price],
[Unit Weight] = [FromTab...more >>
T-SQL Compiled? Posted by nospam_mytrash9 NO[at]SPAM bellsouth.net at 10/10/2004 1:09:56 AM In the October '04 issue of SQL Mag Michael Otey wrote an editorial called
"Making Sense of CLR"
(http://www.windowsitpro.com/SQLServer/Article/ArticleID/43680/SQLServer_43680.html).
He stated "And because CLR objects are compiled, they run faster than those
written in T-SQL, which is interprete...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |