|
|
|
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 Delete records permission Posted by Max at 1/5/2007 10:24:38 AM
Hello,
I have a couple of tables in a SQL Server 2005 database back end and I want to delete some records through a query from a MS
Access 2003 front end. I get an error in MS Access saying "Could not delete from specified tables". There are multiple users of the
back end and each one lo...more >>
copy from one sql to another Posted by raul at 1/4/2007 7:38:59 PM I have two sql servers - mssql2000 & mssql2005-
question.. how do I copy sql2000 database to sql2005? they are both in the
same subnet.
also, how do I copy whole database from sql2000 to append into a sql2005
data file with same tables, structure, etc?
thanks,
raul Rego
...more >>
Stored Procedure to Delete from 2 tables Posted by Vayse at 1/4/2007 4:24:39 PM Hi
I want to delete from 2 tables. Can I do this in the one stored procedure?
I've tried:
CREATE PROCEDURE MONTHLY_Pre_Delete
@EnterUserName as varchar(50)
AS
Delete From ZZZ_Monthly_Pre
WHERE UserName = @EnterUserName;
Delete From ZZZ_Monthly
WHERE UserName = @EnterUserName
GO
But ...more >>
SQL Server Licencing Posted by NigelA at 1/4/2007 11:56:35 AM A client of mine has recently acquired SQL2005 on one server. They also have
about 5 other servers running SQL2000
Licencing for the server and for client access is very clear but I can't
seem to find a clear definition of the way the licensing for the client
tools, i.e. SQL Server Management...more >>
If in SQL? Posted by Vayse at 1/3/2007 3:29:52 PM Hi
There is a ClientAge field in months. In my query, I'd like to return 'N'
for New if the ClientAge is 12 or less. If over 12, I'd like to display 'E'
for Existing.
How do I do this? I've tried using the IIf statement,
IIF(Client_Type<13, 'N', 'E')
but that doesn't work.
What should I use...more >>
Select Query Posted by Jim in Arizona at 1/3/2007 11:27:53 AM I'm trying to query rows from a column that is ntext. I want to remove
all those rows that are blank. These blank rows are just blank, not 'null'.
I can't use DISTINCT on a text or ntext column, as I found out.
I tried something like this:
select computers_comments
from survey06
WHERE c...more >>
Question about SQL 2005 versions... Posted by Leszek at 1/1/2007 2:45:40 PM Hello,
I need some explanation with limits of SQL Server 2005 Express Edition
(which is free of charge)
I've read comparison table from here
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
and I cannot see there any information about limits in concurent
connections...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |