| Groups | Blog | Home |
|
March 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 |
Filter by week: 1 2 3 4 5 I need help with SELECT statement Posted by Vanessa Lee at 4/14/2005 6:16:33 PM Hi, Could you help me modify the SELECT statement below that would
accomplish my final goal.
SELECT col1, col2 FROM table1 WHERE col3 < @V
In col1 rows have many duplicates
col2 has unique values
col3 can have 5 possible values: 5, 10, 15, 20, 25
Variable @V can be equal to 5 or 10 or 15 o...more >>
Table problem ? Posted by Joh at 4/14/2005 3:57:30 PM I have one table which name is medicalhistory which structure is as follows.
ID int
TId int
TableName nvarchar(100)
FieldName nvarchar(100)
Comm1 nvarchar(4000)
Comm2 nvarchar(4000)
CDate datetime
SCDate datetime
The problem is that when I use the following query like.
...more >>
table corruption I think so ! Posted by Rogers at 4/14/2005 1:26:30 PM I have one table which name is medicalhistory which structure is as follows.
ID int
TId int
TableName nvarchar(100)
FieldName nvarchar(100)
Comm1 nvarchar(4000)
Comm2 nvarchar(4000)
CDate datetime
SCDate datetime
The problem is that when I use the following query like.
...more >>
get the windows user from SQL server Posted by Petxa at 4/14/2005 8:47:52 AM Hello,
I have an application that use SQL server, (the conexion is not by nt
autentification)
I need to know what is the current windows user.
Any help will be appreciates.
Thanks Diego
...more >>
Problem to check for identical Posted by Adam K at 4/13/2005 6:12:36 PM Hi friends,
First of all sorry for my english.
I'll be very happy if someone can help me.
I am doing web page with vb.net and sql server, the problem is with
registration.
I am using user name and password which the user can set. The problem is
that if I already have user with user n...more >>
System tables in SQL2005 Beta2 Posted by M.Sauve at 4/11/2005 2:20:13 PM - select * from sys.sysobjects where xtype = 's' return nothing
- sp_mshelpcolumns 'sys.sysobjects' return nothing
- sp_help 'sys.sysobjects' return this error
Msg 15009, Level 16, State 1, Procedure sp_help, Line 70
The object 'sys.sysobjects' does not exist in database 'DBName' or is
inva...more >>
Obtain Info Posted by Pupo at 4/11/2005 12:00:00 AM Hi
I have SQL 2000 server Sp3 on my network, i want know if is possible obtain
major information from log file, i.e. if a user loggin to db i want know the
time/date to login, operation excute etc.
Can help me please
Tia Pupo
...more >>
Restricting Database Access Posted by Borikoy at 4/10/2005 8:19:03 PM I have a users who uses SQL Query Analyzer to Access our Company live Database.
How can I restrict him/her not to access our live database but instead give
him a right to access the test database only. In the SQL Query Analyzer Drop
down Database list can I make our live database invisible to t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Clients not installing Posted by JasonMeyer at 4/8/2005 10:41:06 AM Getting this error...
SMS Client Configuration Manager cannot connect to the machine
"ComputerName". The operating system reported error 1314: A required
privilege is not held by the client.
Possible cause: The client is not accessible.
Solution: Verify that the client is connected to the n...more >>
Disconnect Issues & RPC Server Unavailable Posted by Cstewart at 4/8/2005 7:57:04 AM We have recently upgraded our main server from NT4 to Active Directory
(Windows 2003 Server). Our SQL Database is 2000 and is running on a Windows
2000 Server Box. We use com+ components to connect to our database. Since
the change on our PDC to 2003 Server AD, we have had several errors su...more >>
Recovery Mode. Posted by Rogers at 4/8/2005 5:49:04 AM I want to ask one question regarding copying the full backup, differential
and then log into another machine and
restore automatically but I want to know about the recovery mode I have to
set on that machine so that only read
and restoration can be take place and Yes I don't want to create t...more >>
can't connect to remote sql server with SBS 2003 Posted by Neil Jarman at 4/8/2005 12:00:00 AM Hi,
I can't make a connection to my host's sql server via EM on a SBS 2003
server.
I suspect this is because of the firewall.
Any help appreciated!
many thanks
NEIL
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |