| 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 SQL Server EM/Query Analyzer Access Posted by dm4714 at 5/27/2005 3:59:08 PM Hello -- we have SQL Servers running in a Service Bureau environment. How
clients frequently use applications at their sites to access our SQL Server.
Unfortunately, some of our clients are more sophisticated than others and
know about Enterprise Manager and Query Analyzer, which they can try...more >>
Quick question Posted by Joh at 5/27/2005 12:00:00 AM One quick question....I have a MedicalCause table and it contains 12
billions of records and I wanna do partitioning that table and wanna create
view as well as index on that view but the problem is the that SQL server
doesn't allow to create an index on view which contain "union" and I have to
...more >>
ORDER BY CLAUSE Posted by Joh at 5/26/2005 1:55:27 PM
Working Fine : select top 5 * from MedicalHistory
Doesn't work : select top 5 * from MedicalHistory order by 1
Doesn't work : select top 5 * from MedicalHistory order by 4
Doesn't work : select top 5 * from MedicalHistory order by 2
MedicalHistory is basically a Partition view.... ca...more >>
Problem ! Posted by Joh at 5/26/2005 1:46:55 PM Here is the quick question, i have created MedicalHistory Partitionned view
and it's working pretty good.. when I write this select top 1 * from
MedicalHistory ... result comes in a second but when I write this query..
select top 1 * from MedicalHistory order by 1 desc... result will not come
ti...more >>
Constraints Posted by Joh at 5/26/2005 10:00:20 AM Can any one tell me regarding the foreign key constraints like I wanna
findout which columns doesn't contain the foreign key constraint so that I
can create it....
Thanks in advance.
...more >>
replication with Java Posted by inder at 5/25/2005 11:43:03 PM Hi all,
I'm trying to develop a Java application that will manipulate and
transfer data from sql server X to sql server Y. I'm pretty new to this
sort of thing, but how can my Java application be notified when a record is
updated/inserted into X so that it can be stored in Y? Does Ja...more >>
Alignment result Posted by Joh at 5/25/2005 12:00:00 AM USE PUBS
GO
CREATE FUNCTION [dbo].[GetSpace] ()
RETURNS int AS
BEGIN
RETURN (SELECT max(len(fname)) + 1 FROM employee)
END
GO
SELECT top 5 fname + SPACE([dbo].GetSpace() - LEN(fname)) + lname AS
Expr1, [dbo].GetSpace() AS Expr2, LEN(fname) AS Expr3
FROM dbo.employee
When I...more >>
MSSQL client install Posted by InaFog at 5/24/2005 3:45:28 PM I think my mind is going. I once new how to do this but have somehow
forgotten. We have SQL 7.0 loaded and has been running for several years.
Also the SQL client tools are loaded and are working fine. What I need to
know, is how to install , MSSQL client, on a PC that needs the SQL client to ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help! Don't understand transactions Posted by bthouin at 5/24/2005 12:00:00 AM Hi guys,
I'm having troubles with transaction control.
I recently decided to add transaction control to some operations on an
app I am developing (Dreamweaver MX 2004, ASP, VBScript, ADO and
SQLServer 2000).
I started by doing a test web page with an update of up to 3 different
tables...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |