|
Hi there. Just use ORDER BY with your numeric field -
SELECT * INTO TargTable FROM SourceTable ORDER BY MyNumericField
|
|
|
|
|
All i want to know is, is SQL a interface like Access or is it just a server manager for databases... i downloaded SQl express and MySQL and nither had any GUI i could find unless i did something wrong. i just want a program to make databases as easily as access with more functionalty, as access can only hold 500-1000 records per file, efficently...
"Love, Life and Option Explicit"
|
|
|
|
|
SQL Express and MySQL are database servers. You have to use tools like SQL Server Management Studio Express to have any kind of gui similar to Access. MySQL has tools like MySQL Tools which help build databases, queries, etc. If you are looking for something like Access Forms, then you have to program a front-end in VB or C#.
ThePmanLives wrote: access can only hold 500-1000 records per file
Are you sure? Because I have a client who has 130,000+ records per table and about 50+ tables and he insists on Access.
|
|
|
|
|
I guessed as much, by the interface, just wanted to be sure i wasnt being stupid or anything. I'll look into SQL Server Management Studio Express, if not i will just use access. i have no problem with that. i use VB .net 2003. It should work fine with that.
the 500-1000 figure was given to me by a friend of mine. he may have ben referring to '97 office. I inteend to use 2000.
"Love, Life and Option Explicit"
|
|
|
|
|
My client uses Access 2000/2003 so that could be the reason. I don't know about older versions of Access.
Good luck with SQL Server Management Studio.
Paul
|
|
|
|
|
SQL is a standardized declarative language for interacting with relational database systems. It literally stands for "Structured Query Language" and was originally developed by IBM in the 70's. As of 1987, it was standardized by ANSI and ISO, and has gone through a number of revisions since.
Typically a RDBMs will have a command-line interface of some sort (if not a full blown GUI) that accepts SQL commands. You can download one for Sql Express from Microsoft here[^]. I've heard MySQL's command-line interpreter is much better than its graphical tools, but I don't know that from my own experience.
|
|
|
|
|
If you like the GUI of Access but want the power of SQL use both.
You can link Access to SQL tables and have the best of both worlds...
http://www.sqlservercentral.com/columnists/kKellenberger/accesstosqlserverlinkingtables.asp[^]
You will need a GUI to create the original SQL table, search the web there are others apart from the standard offering or you can generate tables in code.
Have fun...
When people make you see red, be thankful your not colour blind.
|
|
|
|
|
Access is an aplication.
SQL server (express) is an OLE database server. That means it is made to handle calls from other programs.
OLE = Object Linking and Embedding. A Microsoft technology which allows you to link elements from different applications within each other.
|
|
|
|
|
Hello,
I'm new to database programming. I'm currently reading Pro ADO.NET 2.0 from Apress. The book has been great so far, but when he get's to his first example, he supplies a script file to set up a simple data source. So, i have this .sql file that i don't know what to do with. when I double click it, it just opens in notepad. Yes, i'm a doofus. please help me! 
I'm running a local instance of sql server 2005 standard.
thanks!
Ian
|
|
|
|
|
Hi Ian. If you're running Sql Server 2005, you should have access to the Query Analyzer program, yes? Open the .sql file in Query Analyzer, then execute it (F5 will do it)
|
|
|
|
|
i can't find the query analyzer. I'm going to reinstall and give that a shot. Thanks!
Ian
|
|
|
|
|
SQL Server 2005 does not come with Query Analyser. That was a feature of SQL Server 2000.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
 My mistake. 
Thanks Colin.
|
|
|
|
|
Open Microsoft SQL Server Management Studio
Connect to the SQL Server
In the tree on the left open the databases folder
Right click on the database you want to query and select New Query...
In the main pane you can now type SQL. You can execute the SQL by pressing F5 or using the Execute button.
Does this help?
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
The system already has a default instance of MSDE2000 installed. I would liket to upgrade this to a default instance of SQL server 2000. Is this possible without uninstalling the MSDE? The SQL installation asks me for an instance name and disables the default instance (since it already exists in MSDE)??
|
|
|
|
|
Hi,
Can I get previous and current values of row in trigger for update operation.
Regards,
Shah A.
|
|
|
|
|
Use updated.colname
Live Life King Size
Alomgir Miah
|
|
|
|
|
Thanks for the reply Alomgir.
Can you pls elaborate? I think updated.colname will give the value after the execution of query. How can I get the previous value, so that I can compare both.
Regards,
Shah Adarsh.
|
|
|
|
|
I got the answer . deleted table contains the old record and the inserted table contains the newer one for update operation trigger.
Regards,
Shah Adarsh.
|
|
|
|
|
Hi there,
I am just trying to create an ENDPOINT to define a Web Service in Sql
server 2005. Here is my code
Create ENDPOINT AWService
STATE = STARTED
As HTTP
(
PATH = '/ADVENTUREWORKS',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = 'DEVI\SQLDM2005'
)
FOR SOAP
(
WEBMETHOD 'GetProductList'
(NAME = 'AdventureWorks.Dbo.GetProductList'),
DATABASE = 'AdventureWorks',
WSDL = DEFAULT
)
and when i run this T-SQL its complaining about
Msg 7807, Level 16, State 1, Line 1
An error ('0x80070057') occurred while attempting to register the
endpoint 'AWService'.
I am trying this code to run on Windows XP pro and Sql Server 2005. Any
clue why its complaining about this ?
Thanks
-D
|
|
|
|
|
Hi,
I'm using update trigger for inserting a record in a table(say table2) when the value of certain column(Column2) is changed in table1. My code executes UPDATE query on table1 everytime when any column is updated.
My SP is something like
UPDATE table1 SET Column1 = @Column1, Column2 = @Column2
WHERE ID = @ID
I have checked the following condition in Trigger
IF UPDATE(Column2)
INSERT INTO table2...........
So even if Column1 is updated the INSERT query in trigger will be fired.
So the record is inserted into table2 everytime the update query is executed on table1, irrespective of which column has changed.
Regards,
Shah A
|
|
|
|
|
As far as I can see in you UPDATE statement, both Column1 and Column2 are updated, so Column2 is always updated. Even if you put back the same value in Column2, as far as SQL is concerned, it is updated.
--------
"I say no to drugs, but they don't listen."
- Marilyn Manson
|
|
|
|
|
Yes but how can I compare the previous and current values for Column2 in the trigger to know that it has changed.
Thanks for the reply Marilyn.
Regards,
Shah Adarsh.
|
|
|
|
|
I got the answer . deleted table contains the old record and the inserted table contains the newer one for update operation trigger.
Regards,
Shah Adarsh
|
|
|
|
|
Hi:
I am connecting to my SQL server from my windows application localy using either SQLConnection or ODBCConnection and they are working fine but when i try to connect to the server from another PC in the Lan i cannot connect through SQLConnection from my application.
but what have i tried is to connect using odbcConnection and ODBCComand and it connected normally.
What Do i need to setup in the client computer So it Can connect from the Windows Application Normally By using SQL Connection and SQLCommands?
Do I need to setup:
1- A new ODBC System DSN with a SQL Server Driver!!
2- SQL Service Manager (How Do I Get It)
3- Define a new DB user for Clients (I am using it with ODBC Already)
4- Connection string in my application (I am using "Data Source=jedfin-nb0077;Initial Catalog=inventory;User ID=sharifin")
5-In the FORM in QUERY ("SELECT Count(*) FROM [jedfin-nb0077].inventory.sharifin.inventory_item")
Please Help and Thanks in Advance.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
