Re: INSERT QUERY NOT WORKING - Database Discussion Boards

Re: INSERT QUERY NOT WORKING

mjawadkhatri26-Dec-10 19:07

mjawadkhatri

26-Dec-10 19:07

i am Using SQL
Msg 195, Level 15, State 10, Line 1
'TO_DATE' is not a recognized built-in function name.

Re: INSERT QUERY NOT WORKING

Pete O'Hanlon27-Dec-10 0:11

Pete O'Hanlon

27-Dec-10 0:11

Are you using SQL Server? TO_DATE is Oracle syntax. The equivalent in SQL Server is CONVERT(datetime, '12/23/2010', 101)

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

Re: INSERT QUERY NOT WORKING

mjawadkhatri27-Dec-10 0:36

mjawadkhatri

27-Dec-10 0:36

Yes I am Using SQL Server 2005
and i need to insert date in dd/mm/yyyy format
how it possible
please help me

Re: INSERT QUERY NOT WORKING

Pete O'Hanlon27-Dec-10 9:31

Pete O'Hanlon

27-Dec-10 9:31

A few thoughts.

Is this field actually a datetime?
Is it a datetime in your application?
What does the format of the date matter?

If the field is a datetime, and it's being passed in as a datetime then you don't need to do anything. Just insert it as it is - the only reason you'd convert it is if you were passing it in as a string, and you should really avoid this and pass it in as a datetime instead. The format of the date is immaterial - just store it in the universal date format; choosing the format is only relevant when you display the date to the user and you should use the users locale to do this.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

Re: INSERT QUERY NOT WORKING

thatraja25-Dec-10 16:28

thatraja

25-Dec-10 16:28

mjawadkhatri wrote:
please tell me ERROR

Actually you should tell us about that. what's the error message?

FYI Oracle to_date usage[^]

thatraja |Chennai|India|

Brainbench certifications
My Dad had a Heart Attack on this day so don't...

Re: INSERT QUERY NOT WORKING

mjawadkhatri26-Dec-10 19:07

mjawadkhatri

26-Dec-10 19:07

i am Using SQL 2005
Msg 195, Level 15, State 10, Line 1
'TO_DATE' is not a recognized built-in function name.

Re: INSERT QUERY NOT WORKING

Ralf.Bue26-Dec-10 5:33

Ralf.Bue

26-Dec-10 5:33

Don't worry, you mixed days and months. There is no 23. month since I know.
TO_DATE('12/23/2010', 'mm/dd/yyyy') or TO_DATE('23/12/2010', 'dd/mm/yyyy')

try it manually before using it: select TO_DATE('12/23/2010', 'mm/dd/yyyy') from dual;

Regards
Ralf

Re: INSERT QUERY NOT WORKING

Hiren solanki26-Dec-10 19:09

Hiren solanki

26-Dec-10 19:09

Your query is allright IF

a) You have only one column in table to insert
b) You have function called TO_DATE created to give you supposed output compatible with column you have
c) Your function taking two parameters as a INPUT.

mjawadkhatri wrote:
this query is not working.. please tell me ERROR

Only SQL can give neither any of us, Sorry for that.

Regards,
Hiren.

My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator.

Re: INSERT QUERY NOT WORKING

Luc Pattyn26-Dec-10 22:49

Luc Pattyn

26-Dec-10 22:49

AND d) the parameters to to_date are consistent.

TO_DATE('12/23/2010','dd/mm/yyyy') is no good.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum

Season's Greetings to all CPians.

Re: INSERT QUERY NOT WORKING

Pete O'Hanlon27-Dec-10 0:17

Pete O'Hanlon

27-Dec-10 0:17

AND e) He's not using Oracle. Roll eyes | :rolleyes:

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

Re: INSERT QUERY NOT WORKING

Bernhard Hiller28-Dec-10 2:50

Bernhard Hiller

28-Dec-10 2:50

The bad thing is that the "S" in "SQL" means "structured", not "standard".
Look at the "SQL Zoo" for the SQL code in many databases, e.g. http://sqlzoo.net/howto/source/u.cgi/tip218780[^]

Re: INSERT QUERY NOT WORKING

Member 1481254724-Apr-20 11:43

Member 14812547

24-Apr-20 11:43

Maybe because of semicolon you have missed.

For your info : Oracle TO_DATE

modified 24-Apr-20 22:18pm.

joining two tables

Erdinc2723-Dec-10 22:34

Erdinc27

23-Dec-10 22:34

i want to join two tables(Firms and People) to show them in datagridview with ascending order in my program side but the thing is that they dont have any common point.so can i join them ?

vemedya.com

Re: joining two tables

Estys23-Dec-10 22:58

Estys

23-Dec-10 22:58

Sure you can, for instance :

select firms.nmbr as nmbr, firms.name as name, "firm" as type from firms
UNION
select people.id as nmbr, people.surname as name, "people" as type from people;

The UNION keyword joins the two result sets.

Cheers

^I _don't like ^my _signature at ^all

Re: joining two tables

Erdinc2723-Dec-10 23:11

Erdinc27

23-Dec-10 23:11

yeah it worked..thanks Estys..one more question it showed the datas as ordered already actually i wished that so it works always like that or i am lucky Smile | :)

vemedya.com

Re: joining two tables

Estys23-Dec-10 23:26

Estys

23-Dec-10 23:26

Without seeing your query, I think that's just blind chance Big Grin | :-D

.

Cheers

^I _don't like ^my _signature at ^all

Re: joining two tables

Erdinc2723-Dec-10 23:51

Erdinc27

23-Dec-10 23:51

my query is here

select firma_adi[Kişi/Firma],telefon1[Telefon No],telefon2[Telefon No],Telefon3[Telefon No],Telefon4[Telefon No],Telefon5[Telefon No] from Firmalar
Union
select kisi[Kişi/Firma],numara1[Telefon No],numara2[Telefon No],numara3[Telefon No],Numara4[Telefon No],Numara5[Telefon No] from Rehber

vemedya.com

Re: joining two tables

Estys24-Dec-10 0:12

Estys

24-Dec-10 0:12

You can order the data with the ORDER BY clause.

If all select statements use the same fieldnames you can use "ORDER BY <fieldname>",
otherwise you can use the form "ORDER BY 2" where the "2" is the position of the field.

Cheers

^I _don't like ^my _signature at ^all

Re: joining two tables

Erdinc2724-Dec-10 0:35

Erdinc27

24-Dec-10 0:35

yeah it works with order too..thanks for your time

vemedya.com

where are stored procedures stored.

khurram_shahzad23-Dec-10 20:34

khurram_shahzad

23-Dec-10 20:34

Where are Stored Procedure stores in MySQL or any other database e.g. SQL Server etc .....

Further explanation of my question,
Such that if i created a database then i know all my data is in this created database ..... but if i talk about creating/using stored procedures then were are they stored.

I.ve searched some example and tutorials for stored procedure ... but i didn't found aobut it.

THANKS

Re: where are stored procedures stored.

Hiren solanki24-Dec-10 0:38

Hiren solanki

24-Dec-10 0:38

khurram_shahzad wrote:
Such that if i created a database then i know all my data is in this created database ..... but if i talk about creating/using stored procedures then were are they stored

They are stored in hidden table of same database.

You could access it using following.

select * from sys.sql_modules where object_id=object_id('Name_of_your_sp')

Regards,
Hiren.

My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator.

Creating view in Access

jadughar23-Dec-10 2:12

jadughar

23-Dec-10 2:12

Hi
I would like to know how to create a view in Access???
In SqlServer there is a folder "Views" where u can create views in a very simple way.

Searching with google i found that in access are used sql queries instead of views, but didn't understand well.

Thanks bye

"For as long as men massacre animals, they will kill each other. Indeed, he who sows the seed of murder and pain cannot reap joy and love." Pythagoras

modified on Thursday, December 23, 2010 8:19 AM

Re: Creating view in Access

Hiren solanki23-Dec-10 3:04

Hiren solanki

23-Dec-10 3:04

jadughar wrote:
I would like to know how to create a view in Access???

For that there's word 'Queries' Access .

jadughar wrote:
In SqlServer there is a folder "Views" where u can create views in a very simple way.

View is nothing but the result of query. In SQL you can see the result as Views, But it isn't a physical data. It's just returned result of query.

jadughar wrote:
Searching with google i found that in access are used sql queries instead of views, but didn't understand well.

View in SQL = Queries in Access.

Regards,
Hiren.

My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator.

Re: Creating view in Access

jadughar23-Dec-10 4:58

jadughar

23-Dec-10 4:58

ok..Thanks for the answer! Thumbs Up | :thumbsup:

"For as long as men massacre animals, they will kill each other. Indeed, he who sows the seed of murder and pain cannot reap joy and love." Pythagoras

Recursive query "SQL Server 2000"

peropata22-Dec-10 23:37

peropata

22-Dec-10 23:37

I am working with "SQL Server 2000 SP3 2000.80.760.0".

How to write recursive query for next example ? (I use .net c# to query database, and my knowledge of SQL is limited ...)

All queries are done from the same table (lets call it "parts_table").

Let say I start with "part_ID" = 1001 --> query returns 120 "subpart_id" (1002, 1004, 2030 ...)
then I execute same query 120 times and get n subparts for each of 120 subpart_ID from first query and so on
until there are no subparts left. As you can see the number of queries can increase very fast ...

Table: "parts_table"

id part_id subpart_id
1 1001 1002
2 1001 1004
3 1002 2150
4 1002 3250
5 1004 1250
.

Part description for "part_id" is in separate table "part_info". I use join to get info for "part_id" ...

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.