sql query lo doubt

[The QUEEN]

[quote author=galigannarao link=topic=234947.msg2923514#msg2923514 date=1315513497]
yaa baa we can do that. directga select query nundi insert cheseyochu.but the [color=red]column names should be equal[/color]
[/quote]
@gr33d or dis @gr33d  CITI#H@

[krldr871]

[quote author=galigannarao link=topic=234947.msg2923529#msg2923529 date=1315513617]
nenu Artificial Intelligence  H&T@ H&T@ H&T@
[/quote]
naku koncham kakkurti ekkuva..AI Machine learning and databases..anni  CITI_c$y CITI_c$y CITI_c$y CITI_c$y

[galigannarao]

[quote author=The QUEEN link=topic=234947.msg2923531#msg2923531 date=1315513638]
@gr33d or dis @gr33d  CITI#H@
[/quote] sorry2 column count anaboyi

[mettastar]

In MS SQL Server

SELECT *
INTO new_table_name
FROM old_table_name

[nenuinthe]

[quote author=The QUEEN link=topic=234947.msg2923531#msg2923531 date=1315513638]
@gr33d or dis @gr33d  CITI#H@
[/quote]no need of column names..column datatypes must be same

[The QUEEN]

[quote author=galigannarao link=topic=234947.msg2923541#msg2923541 date=1315513719]
sorry2 column count anaboyi
[/quote]naa query correct or wrong  CITI#H@

[galigannarao]

[quote author=John Galt link=topic=234947.msg2923537#msg2923537 date=1315513691]
naku koncham kakkurti ekkuva..AI Machine learning and databases..anni  CITI_c$y CITI_c$y CITI_c$y CITI_c$y
[/quote]nenu B.Techlo sariga sadavaledu baa, i love that anyway anduke &D_@@ &D_@@ &D_@@ &D_@@ &D_@@

[Ranga_The_Donga]

[quote author=HS link=topic=234947.msg2923417#msg2923417 date=1315512714]
CREATE TABLE #mytemptable(CustomerCircuitnum int, RequestedDueDate date,OrderMarkedCompleted date)

Insert into #mytemptable(select cust_circuit_num,
      in_service_request_date,order_compl_date from CIRCUIT_ORDER)



Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'select'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near ')'.
CITI#H@ CITI#H@
[/quote]

Insert taruwatha "into" teeseyi......


Insert  #mytemptable(select cust_circuit_num,
      in_service_request_date,order_compl_date from CIRCUIT_ORDER)

idhi try cheyyi

[krldr871]

[quote author=galigannarao link=topic=234947.msg2923548#msg2923548 date=1315513772]
nenu B.Techlo sariga sadavaledu baa, i love that anyway anduke &D_@@ &D_@@ &D_@@ &D_@@ &D_@@
[/quote]
@gr33d @gr33d @gr33d  AI lite kani..machine learning and databases important baa..pedda companies ki machine learning chala important..and databases okataina ravali..so nerchukunta  :0012391: :0012391: :0012391:

[htnamus]

[quote author=BEZAWADA ROWDY link=topic=234947.msg2923526#msg2923526 date=1315513591]
INSERT INTO #mytemptable(CustomerCircuitnum int, Requested DueDate date,OrderMarkedCompleted date)
SELECT cust_circ uit_num,in_servic e_request _date,order_compl_date  from CIRCUIT_ORDER

try it
[/quote]


create table #temptable(CustomerCircuitnum int,RequestedueDate date,OrderMarkedCompleted date) 
Insert into #mytemptable(CustomerCircuitnum ,RequestedueDate,OrderMarkedCompleted)
select cust_circuit_num, in_service_request_date, order_compl_date from CIRCUIT_ORDER



Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #2: Cannot find data type date.

[img]http://www.desigifs.com/sites/default/files/bemmi1.gif?1290061581[/img]

[C Nation]

CREATE TABLE #mytemptable(CustomerCircuitnum int, RequestedDueDate date,OrderMarkedCompleted date)

Insert into #mytemptable
select cust_circuit_num,
      in_service_request_date,order_compl_date from CIRCUIT_ORDER

[htnamus]

[quote author=John Galt link=topic=234947.msg2923557#msg2923557 date=1315513832]
@gr33d @gr33d @gr33d  AI lite kani..machine learning and databases important baa..pedda companies ki machine learning chala important..and databases okataina ravali..so nerchukunta  :0012391: :0012391: :0012391:
[/quote][img]http://www.desigifs.com/sites/default/files/Brahmi_Dandam.gif?1290059970[/img]me idaru sachifondi ee thaadu lo me disco oddu nayinoooooo

[Ranga_The_Donga]

braces kuda teeseyi...


Insert  #mytemptable
select
cust_circ uit_num,
in_servic e_request _date,
order_compl_date
from CIRCUIT_ORDER

[Virat Kohli]

[quote author=HS link=topic=234947.msg2923564#msg2923564 date=1315513874]
[img]http://www.desigifs.com/sites/default/files/Brahmi_Dandam.gif?1290059970[/img]me idaru sachifondi ee thaadu lo me disco oddu nayinoooooo
[/quote] CITI_c$y CITI_c$y CITI_c$y CITI_c$y CITI_c$y CITI_c$y CITI_c$y CITI_c$y CITI_c$y

[galigannarao]

[quote author=HS link=topic=234947.msg2923559#msg2923559 date=1315513839]

create table #temptable(CustomerCircuitnum int,RequestedueDate date,OrderMarkedCompleted date) 
Insert into #mytemptable(CustomerCircuitnum ,RequestedueDate,OrderMarkedCompleted)
select cust_circuit_num, in_service_request_date, order_compl_date from CIRCUIT_ORDER



Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #2: Cannot find data type date.

[img]http://www.desigifs.com/sites/default/files/bemmi1.gif?1290061581[/img]
[/quote] *7*^ *7*^ *7*^ second pagelo chudu nenu already refly icha solution