How converting in sql to datetime from varchar

[anhmaker]

I tryed convert

Code: Select all

DECLARE @str VARCHAR(250) = @YEAR +'-'+ @Month + '-01'; -- 2014-02-01
-- and DECLARE @str VARCHAR(250) = @YEAR +'-'+ @Month + '01'; -- 20140201
SET @StartDate = CONVERT(DATETIME, @str, 112);

but do not wark!
----------------------------
[Customer Explanation]



----------------------------
[General Info]

Application: Stimulsoft Reports.Net
Framework: v4.0.30319
Version: Version: 2013.3.1800 from 22 November 2013
MachineName: ALBERT
OSVersion: Microsoft Windows NT 6.2.9200.0
UserName: Низамутдинов Альберт

----------------------------
[Exception Info]
Message: Conversion failed when converting date and/or time from character string.

Source: .Net SqlClient Data Provider

StackTrace:
в System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
в System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
в System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
в System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
в System.Data.SqlClient.SqlDataReader.get_MetaData()
в System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
в System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
в System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
в System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
в System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
в System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
в Stimulsoft.Report.Dictionary.StiSqlAdapterService.GetColumnsFromData(StiData data, StiDataSource dataSource)
в Stimulsoft.Report.Dictionary.Design.StiDataStoreSourceEditForm.tbRetrieveColumns_Click(Object sender, EventArgs e)

----------------------------
[Assemblies]
mscorlib, Version = 2.0.0.0
Stimulsoft.Base, Version = 2013.3.1800.0
Stimulsoft.Report, Version = 2013.3.1800.0
Stimulsoft.Report.Design, Version = 2013.3.1800.0
System.Windows.Forms, Version = 2.0.0.0

[HighAley]

Hello.

The error is on the SQL server side.
Please, check your query before using it.
Read this article on the MSDN http://msdn.microsoft.com/ru-ru/library/ms187928.aspx

Thank you.

[anhmaker]

I understood the reason. When get all collumns for datasource in designer set into parametrs in sql query variable names.
Thanks!

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.