what is correct way to declare in sql server 2008 r2

Asked Apr 01 '15 at 08:02

Active Apr 01 '15 at 08:40

Viewed 77 times

enter image description here

at line 79...

if query is "select @date = TglMasuk from MT_Pengemudi where id = '2' " I succes view result... but just one result...

I hope i can view.. all result...in my query without "where id = '2' " why without "where" failed like this picture ?

Btw, I created in sql server 2008 r2, variabel Tgl_masuk is date start work in my school, MT_Pengemudi is table name, tipe variabel TglMasuk is varchar.

edited Apr 01 '15 at 08:40

asked Apr 01 '15 at 08:02

SimanisJKT48

This may help: http://stackoverflow.com/questions/3945361/t-sql-set-versus-select-when-assigning-variables – Felix Pamittan Apr 01 '15 at 08:04
`TglMasuk`'s datatype is `VARCHAR` and the conversion to date results in an out-of-range error. – Felix Pamittan Apr 01 '15 at 08:05
You should mention the error in your question instead of "failed like this picture". – Tim Schmelter Apr 01 '15 at 08:06
to Tim Schmelter : if at line 79 I addition condition where... my query succes... if not addition condition my query is failed. to wewesthemenace : i try make set and make selecet... not difference...same is error... thank's – SimanisJKT48 Apr 01 '15 at 08:13
in my case, how i can view result all... without condition like where ? – SimanisJKT48 Apr 01 '15 at 08:15
Why don't you cast to DATETIME while selecting? – Kartic Apr 01 '15 at 08:42
to Kartic : if i casting its working ? ok i try – SimanisJKT48 Apr 01 '15 at 08:48
to Kartic : i failed... – SimanisJKT48 Apr 01 '15 at 08:54

what is correct way to declare in sql server 2008 r2

0 Answers0