___ erkimt ___ DataBindTable Incompatible with SqlDataReader does not implement IEnumerable ______ qstntxt ___
I have a problem displaying the data in a column that is in the
I have a table, where I am bringing two different results with the query below:
select sum(qtde_pontos) from dbo.tbl_cc_ponto where re = '9289'
and natureza_operacao = '2'
and data_lacto >= '2012-01-01'
and data_lacto <= '20...
DECLARE @Year INT = 2005, @Month INT = 7
SELECT --SequenceNo = ROW_NUMBER() OVER(ORDER BY OrderDate),
Year = Year(convert(int,OrderDate,111)),
case Month(convert(int,OrderDate,111))
when 1 then 'Janeiro'
when...
I am querying the database (sql server) for user and password validation with laravel 5.4 but the query is being run as case-insensitive.
In the database it is:
pwd = Aa12A
Input receives:
password = aa12a
The result is:...
Good morning, fine, guys?
Next work with database, and we have some problems with SQL SERVER 2014 x64 in Windows 10. I am doing the installation normally and changing the network configuration, in TCP / IP, to a specific port that we use....
I need to migrate a database (from SQL Server to PostgreSQL and I'm creating an ETL interactive in PHP to make this change), which is about 10 years, some 2 million records in the table clientes no has verif...
I made a C # program of simple registrations using SQL Server 2008 database.
When I went to install another computer, I came across the following error:
A network-related or instance-specific error occurred while establishing a connecti...
I have the following code:
protected void btnSalvarDestaque_Click(object sender, EventArgs e)
{
if (fuFotos.HasFile)
{
string strname = fuFotos.FileName;
fuFotos.PostedFile.SaveAs(Server.MapPath(".") + "//Content/Destaq...
I need to group the data of a SELECT by the a.afo_vch_NmrCtf field, because the data is being returned as follows:
When I use GROUP BY the following error is returned:
Msg 8120, Level 16, State 1, Line 2
Column 't...
I'm trying to attach a database from a .mdf file generated by Visual Studio, at the time I created the identity database, however I'm trying to attach that database to sql server and it's giving a mismatch error. version
How do I at...