|
|
|
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 Where is ROWID in Sql Server 2005 like Oracle ? Posted by Luqman at 5/21/2006 11:28:42 PM Where is ROWID in Sql Server 2005 like Oracle ?
For example: Select firstname,rowid from mytable
Best Regards,
Luqman
...more >>
help with an update Posted by Shiva at 5/21/2006 11:20:59 PM Table A
---------
Listing_Number | Sort_Order
=====================
2000 | 1
2000 | 3
2000 | 4
2000 | 6
2000 | 9
I want the Sort_Order ordered like 1,2,3,4,5,6 etc. for every
listing_number. Could someone help with this problem ASAP. This is SQL
Server 2000.
Thank you,
Shiva
...more >>
SQL 2005 performance and scalability Posted by Syam at 5/21/2006 10:58:02 PM Hi,
Is SQL 2005 better with respect to the performance and scalability than SQL
2000. What would be the difference again if we use 64 machines. Could some
one direct me to some link which will provide me some clarity between 2000
and 2005 with respect to the performance and scalability.
...more >>
Select same column multiple times Posted by Jaydee at 5/21/2006 9:16:01 PM Table data:
CaseId Name NameType
123 Joe I
123 Tony O
123 Mike S
I need to output the names by nametype in the same grid for the one caseid eg.
CaseId Staff Owner Instructor
123 Mike Tony Joe
Is there a simple way of ...more >>
Querying table from remote sql server Posted by AC at 5/21/2006 8:55:00 PM Hi,
I have 2 sql servers running on different machines:
Sql Server A: SQL Server 2005
Sql Server B: SQL Server 2000
I need to query tables in Sql Server B from Server A.
I've run the following on Server A:
exec sp_addlinkedserver 'sql', 'SQL Server'
exec sp_addlinkedsrvlogin 'sql', FALSE,...more >>
WHERE clause Posted by Adrian at 5/21/2006 7:32:22 PM Say column_two has the values: one, two, three, etc
column_two is set to: text
WHERE column_two = three
is not correct: what should the syntax be?
Thanks,
Adrian.
...more >>
Option seaching criteria in sproc and it's performance Posted by Baron Ng at 5/21/2006 7:22:02 PM I'm new to SQL...so I have the following questions
I have a sproc for searching in a table
create procedure SearchSalary
@Name varchar(8) = null,
@Gender char(1) = null,
@FromDateOfBirth datetime = null,
@ToDateOfBirth datetime = null
As
BEGIN
SELECT * from tblSalary
WHERE (@...more >>
length of an image column Posted by Tarren at 5/21/2006 5:31:47 PM Hi,
I want to write a proc that will tell me the length of the data stored in
the image column, but it looks as though
select myimagecolumn as filedata, len(myimagecolumn) as filesize
from mytable
len(myimagecolumn) will not work, since that function cannot work with image
datatype.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Count in Join Posted by sacsan NO[at]SPAM gmail.com at 5/21/2006 6:18:24 AM i have a questing relating to sql, i have a table that has student
enrollment, and i need to find out how many students have enrolled in
the same number of subjects as that of student who's id is '0102',
note the subject could be different , but the final number ie. count.
has to be the same
th...more >>
sql 101... Posted by RAB at 5/21/2006 5:21:07 AM What is the difference between an 'instance' and a 'database'?
Thanks,
RABMissouri
...more >>
MSDE... Posted by RAB at 5/21/2006 5:19:51 AM How do I determine what tables a database has using the command line
and osql?
Thanks,
RABMissouri
...more >>
SQL 2005 : Caclulating a CompanyCode : Where should this be done? Posted by Russell Mangel at 5/21/2006 1:46:03 AM Hi,
In order to insert a new Company into our Companies table, I must create a
unique 5 character *company code*.
Let's say I have to insert a new Company called "Joe's Coffee Shop #1", I
would need to generate "JCS01". It is a good chance
that the database could have another "Joe's Coffe...more >>
What is the best way to do this in SQL 2005 ? Posted by Russell Mangel at 5/21/2006 1:11:59 AM I recently replaced an SQL 2000 server with the new SQL server 2005 (sp1).
The old server had C# console application which was scheduled (using task
scheduler), which simply downloads an XML file (from a Web Site), containing
currency exchange rates. The C# application then just reads the XML...more >>
Problem with DTS Posted by imtiaz at 5/21/2006 12:00:00 AM I am using a DTS package to import data from primary server to secondary
server to update the changes occured in few tables and both located in a
different location. The problem is that whenever this DTS fails to execute i
will loose even the existing datas in secondary server since it delete the...more >>
Is it possible to view queries run on sql server by particular user ? Posted by Luqman at 5/21/2006 12:00:00 AM I want to know, what queries User A ran on sql server today, is it possible,
or any option like Audit Trail ?
Best Regards,
Luqman
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |