|
|
|
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 Sorting Table and moving to last row in Enterprise Manager Posted by Oscar at 6/5/2004 11:21:39 PM Is there a way to sort a table by order of a specific column in the SQL
Server Enterprise Manager (Just like MS Access does by clicking at the field
name) ?
How can I move quickly to the last row within a table with many rows in the
SQL Server Enterprise Manager? I noticed that the scroll butt...more >>
How to reset the identity value to 1 after all rows have been deleted? Posted by Oscar at 6/5/2004 11:12:20 PM After that I deleted all rows within a table which holds an identity column,
I want to have the next inserted row to start with the ID = 1 value.
However, SQL Server 2K assigns an ID value to the identity column which is
one higher that the ID-value of the last row that was deleted. How can I
re...more >>
a simple (hopefully) sql question. Posted by tracy at 6/5/2004 6:32:21 PM hello,
QUESTION 1:
I have a table with 3 columns: ID, GroupID, Date.
eg:
ID GROUPID DATE
1 10 2004-03-02
2 10 2004-03-01
3 20 2004-03-03
4 20 2004-03-01
...more >>
Running sql commands in text file in C# program Posted by TomTom at 6/5/2004 4:05:41 PM Hi,
I have a text file that include a lot of SQL commands. I would like to know
what would be the best way to run it from a C# program. One way I know is to
run osql but I am guessing there should be a better way. If you know a
better method, can you let me know? Thanks!
TomTom
...more >>
Imporint CSV file using store procedure Posted by Ashish Kanoongo at 6/5/2004 3:46:23 PM I would like to create DTS for Importing from CSV using store procedure, =
in which I would like to update fields conditionally.
Anyone can help in this matter or let me know url/tutorial on this.
Thanks in advance
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus sy...more >>
Problem With Outer Join Posted by Wayne Wengert at 6/5/2004 3:14:33 PM I have three tables, One is "Tournaments", a list (25 rows) of tournaments.
This table includes a TournamentID field (PK), Date, Location, etc. The
second table is "Teams" which is a list of teams in the area. The Teams
table has a TeamID field (PK), Team Name, City, etc. The third table is
"Sig...more >>
"Select Case" in TSQL Posted by Maik Siegel at 6/5/2004 1:07:11 PM Is there something in TSQL like the "Select Case .... End Select" in VB ??
...more >>
default value not working Posted by marwan at 6/5/2004 11:51:00 AM Do anyone knows why this code is not giving what I am expecting?
----------------------------------------------------------------------------
---------
/*if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Table1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo]....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
error: not associated with a trusted sql server connection Posted by Daniel at 6/5/2004 10:11:31 AM I used code in a vb6 application to attach a database to MSDE, but I get an
error that says "Login failed for user 'sa'. Reason: Not associated with a
trusted SQL Server connection." What does that mean? My code looks like
this:
Private Sub Command1_Click()
Dim oSvroot As SQLDMO.SQLServ...more >>
data structure easy question from newbie Posted by george at 6/5/2004 8:56:03 AM I have a PK column table A, let's call it tableAId that relates to a column of the same name in table B. So it is a FK in table B. But less than half of the records in table B have any corresponding record in table A. When I try to create a relationship between table A and B, SQL does not seem happy...more >>
SP Posted by Ramesh at 6/5/2004 8:48:51 AM Hii All
my question may sound really stupid ...Can we create stored
procedures/Tables with the same name in the same database??i was asked this
questn in a recent interview and my asnwer was obvsly no.but that guy was
very firm on his answer that its possible.. is it actly possble???
Reply to n...more >>
Yukon report services and sql 2000 Posted by Mark Goldin at 6/5/2004 7:18:33 AM Can reports developed in Yukon environment be deployed on SQL 2000?
Thanks
...more >>
Very serious bug with Materialized/Indexed views and SQL server Posted by vlidou NO[at]SPAM laposte.net at 6/5/2004 12:20:30 AM Do not trust values returned by materialized views under SQL Server
without frequently checking underlying tables!!!
I already posted this message under microsoft.public.sqlserver.server
and I'm amazed nobody from Microsoft answered about this problem. By
inserting lots of data into our two ma...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |