|
aditya chitti wrote: how to query a SqL server and retrieve the Records.
SELECT {column names} FROM {table name}
However, I think you probably want more than that - You'll have to be more specific about your requirements.
|
|
|
|
|
Very simple question:
I have SQL 2000 installed, but don't seem to have a procedure sp_add_job:
...
EXEC sp_add_job
go
....
Msg 2812, Level 16, State 62, Server PEER170, Line 1
Could not find stored procedure 'sp_add_job'.
...
what have I missed?
cheers,
Neil
|
|
|
|
|
This proc is in msdb, not master. did you drop msdb?
|
|
|
|
|
Nope, just didn't realise it was located there.
Thanks for your help.
cheers,
Neil
|
|
|
|
|
I work with SqlServer 2000 using an easy SELECT with da datetime field as follows:
SELECT * FROM myTable WHERE date = '1.10.2006'
This works fine on my environmet(German). On the environment of another computer (French) I get the error massage 'The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The cursor was not declared'.
It seems, that the regional country setup of the other computer makes the difference. So i change the settings to German and tryed again. But I become the same error massage.
Is there any datetime-format setting in the SqlServer itselve and where can I find it ?
Thanks a lot *
Alfred
|
|
|
|
|
Don't write your SQL Statements in a culture specific way. Use the ISO date format (yyyy-mm-dd). Or, if the date is coming from an application, use parameters and let ADO.NET do the conversion for you.
|
|
|
|
|
I changed my code. Now it wirks fine...
Colin, I thank you a lot
|
|
|
|
|
I have an SQL statement that works for one database but when I try it on a microsoft access database it doesn't work.
SELECT DIGITS(field1) FROM myTable
The DIGITS() function will convert the field1 from a numeric into a string, but will ensure that the size is maintained. For example, if field1 contained the number 12 and the size of the field was 5 (precision 5, scale 0), this select statement would return 00012.
So my question is, what can I use that is valid in access SQL to accomplish the same goal?
|
|
|
|
|
You can try the Format function. For example,
SELECT Format(field1,"00000") from myTable
should give you all the numbers in field1 with 0 prefixed.
Hope this helps
Chandra
|
|
|
|
|
That is exactly what I was looking for. Thanks!
|
|
|
|
|
Hi,
I have an application that uses ODBC to connect to a SQL Server database. The database includes a number of tables which have columns (of datetime type) to timestamp the row entry with the current date and time. There is no way to get the current date/time from within my application, and so include it in my SQL INSERT INTO statement. Is there a way to have the SQL server automatically insert a datetime value? I have looked at the timestamp column, but I need the actual date and time.
Thanks,
Alice
|
|
|
|
|
CREATE TABLE [MyTestTable] (
[IDColumn] [int] IDENTITY (1, 1) NOT NULL ,
<code>[DateCreated] [datetime] NOT NULL CONSTRAINT [DF_MyTestTable_DateCreated] DEFAULT (getdate())</code> ,
CONSTRAINT [PK_MyTestTable] PRIMARY KEY CLUSTERED
(
[IDColumn]
) ON [PRIMARY]
) ON [PRIMARY]
GO
Or, in the Enterprise Manager's Design Table window, select the datetime column and set the default value to (getdate()).
-- modified at 9:40 Friday 27th October, 2006
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
EricDV wrote: [DateCreated] AS (getdate()) ,
Surely that defines a computed column, in which case the date will update each time you select rows from that table?
What you need to do is create a default value so that if no date is supplied in an INSERT statement it defaults to the time of the INSERT.
|
|
|
|
|
Dammit man! You caught me again! 
I'm gonna have to slow down and think about what I'm posting. 
(Thanks for your correction.)
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
EricDV wrote: You caught me again!
No problem 
EricDV wrote: I'm gonna have to slow down and think about what I'm posting.
Don't worry about it - It happens from time-to-time.
|
|
|
|
|
That sounds like what I need... how do I do that?
Many thanks,
A
|
|
|
|
|
|
Thanks every so much Colin and Eric. I think you've fixed me.
Best regards,
Alice
|
|
|
|
|
Hello im confused. i do not understand the difference between
ADO, SQL, ACCESS, MICROSOFT SQL SERVER, VBA
i need to develop data-base project and do not know where to start and what is the newest methoods
thank you
|
|
|
|
|
Haoman17 wrote: ADO
ActiveX data objects
Haoman17 wrote: SQL
Structured Query Language
Haoman17 wrote: ACCESS
A desktop database procuct by Microsoft
Haoman17 wrote: MICROSOFT SQL SERVER
A server database product by Microsoft
Haoman17 wrote: VBA
Visual Basic for Applications.
Haoman17 wrote: i need to develop data-base project and do not know where to start and what is the newest methoods
SQL Server 2005 with Visual Studio 2005 using C# or VB.NET
Start with SQL Server 2005 Express (it is free) and one of the Visual Studio Express editions (they are free also)
|
|
|
|
|
Thank you, but i dont understand, should i use sql or ado?
|
|
|
|
|
In the nicest possible fashion, if you don't know what these are, you probably should get some reading material before embarking on a database project...
ADO is a method used to connect to a database (superseded by ADO.net in the .net suite of languages).
Friday afternoons - should connect brain before thinking...
ADO contains a set of functions that are used to connect to and query a database. (ADO.net is the newer version of this).
SQL is a language used within a database to query the data.
|
|
|
|
|
You should use ADO.NET. You will also use SQL because ADO.NET is a way of sending SQL from a .NET application to a database.
|
|
|
|
|
Well, then there is NJDX, which is beyond ADO and SQL.
Damodar Periwal
Software Tree, Inc.
Simplify Data Integration
http://www.softwaretree.com
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
