|
|
|
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 multiple values Posted by Emre Guldogan at 12/19/2004 8:46:45 PM UPDATE Customers
SET
( CompanyName , ContactName ) =
(SELECT 'Name ', 'Sora'
FROM Customers )
WHERE CustomerID='ALFKI'
it does not work on mssql ,
is there an equivalance for mssql ?
thanks
...more >>
usage of updlock Posted by Hassan at 12/19/2004 8:43:42 PM I see a lot of our sprocs developed by developers have select statement with
the updlock. Why would they be doing that ? I know you might be wondering
why I cant ask them directly but thought I not embarass myself and ask you
guys.. Thanks
...more >>
Advice needed Posted by Hassan at 12/19/2004 8:21:08 PM Say in a sproc definition we have
Create proc x
as
declare @abc int
set @abc = 1
select col1,col2 from table1 where col3 =@abc
So the question is
would there be a whole lot of advantages if we just did it this way
Create proc x
as
select col1,col2 from table1 where col3 =1
Obvio...more >>
Conditional SQL Posted by Carlos at 12/19/2004 7:56:35 PM Hi,
I need to write a conditional sql, so that if the value of one field in a
recordset is say = 1 then the sql runs
Select * from table where ... bla bla ...
But if the value of that field in the recordset is = 2, then it runs a
different sql like
Select field1, field2 from table 2...more >>
SQL Query Posted by VBB at 12/19/2004 6:47:02 PM I have two tables namely Student and Subject respectively
Please find below the data for each table
Subject
---------
Physics
Chemistry
Biology
Maths
Student(Students attended the exam and their marks)
---------
ID Subject Marks
--- -----...more >>
Composite Key Quesion Posted by Russell Mangel at 12/19/2004 6:44:09 PM I am creating a new SQL2000 database (Imagine that ;)).
After quarreling with our Purchasing Department, I must create a composite
key instead of a simple int PK with Identity Increment. Sigh! Life is never
simple.
The table will now look like this:
=============
Invoices
=============
I...more >>
What are filegroups and how are they used? Posted by Ed_P. at 12/19/2004 6:03:01 PM I know the definition of a file group in sql 2000 is that they allow you to
group/organize database objects. However, I have yet to see an example of
where this can come into play. Can someone give me a little more insight as
to when you can use filegroups and maybe some examples as to it's ...more >>
How to Limit Resultset Using Custom Sort Posted by Ian P. at 12/19/2004 4:35:01 PM We have a 10 digit primary key value in this format: M000123456. This order
for this key is first determined by positions 3 and 4 in this example, then
positions 1 and 2. So a brief sample of correct ordering would look like
this:
M000001501
M000011501
M000021501
M0000016...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
OUTPUT Problem Posted by CJ Taylor at 12/19/2004 3:29:50 PM Hey Everyone,
I searched through the group and couldn't find anything that really answered
my questions so thought I would post this and see what comes of it.
I have a procedure, being called from another sp that has an output
parameter of ID. Here is basically whats happening
MyProced...more >>
DB Normalization Posted by Ed_P. at 12/19/2004 2:51:02 PM Hello,
I have just taken my first stab at trying to normilize a testdb that I have
created in SQL 2000. I want to get feedback and or tips and hints on whether
or not I've normalized this DB to the 3rd. Form. Below you'll find the
information on the Tables I've created. Thanks in advance...more >>
Change Login Posted by scorpion53061 at 12/19/2004 1:56:14 PM Yes I know your not supposed to but I need to change my SQL Server
account from windows authentication to SQL Server Authentication and set
the username and password I want used.
How can I do this?
Thanks for your help.....
...more >>
Administring a small database Posted by Mark Goldin at 12/19/2004 11:36:38 AM I have been developing for SQL for years.
Now a friend of mine is asking me if I can help him to administer a small
database.
What would be a minimum of taks (Backup for example) that have to be set?
I am thinking to design a few DTS packages to handle these tasks.
Am I on a right track?
TIA...more >>
SPID Posted by Leila at 12/19/2004 9:33:58 AM Hi,
Is it possible to force SQL Server to check that if a particular SPID is
alive or it has been disconnected(maybe crashed). assuming that no other
user has connected to obtain that spid again.
Thanks,
Leila
...more >>
HELP: moving DB to another server probs :( Posted by Kevin GPO at 12/19/2004 9:09:15 AM
I exported my database so that I can move my website to another server
PC. Upon importing into the new MySQL server I get this error messsage.
I had a look at MySQL website but to no avail I still did not know what
it means or how to solve it. Please can someone help me solve this bug.
M...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |