Questions tagged as 'sql-server'

Tagged questions
1
answer

Problem with different encodings between databases

I'm creating an application that needs to grab some data that is in a SQL Server database with iso-8859-1 encoding, and insert into a MySQL database with utf-8 encoding. Some words with accents are giving error when inserting into MySQL datab...
asked by 04.08.2015 / 14:29
1
answer

How NOT to cascade records with 1-n relationship using Entity Framework?

I have a table Menu which can have many Categories and these Categories can only have a Menu : public class Menu { public int Id { get; set; } public string Name { get; set; } public virtual ICollection&l...
asked by 20.08.2015 / 20:07
1
answer

Problem running runnable JAR: Unable to load class [com.microsoft.sqlserver.jdbc.SQLServerDriver]

I am facing the following problem: we are in the development phase of a project, which involves the following technologies, SQL Server, Hibernate, maven, quartz and java. After the end of one of the coding phases we tried to generate a runna...
asked by 23.10.2015 / 16:06
1
answer

See table by foreign key in C #

So, I have a Pizzaria project and I have some tables, such as: Customer Registration, Employee Registration, Order Master and etc. I've already created a Client and Employees table and that's OK. In the Order Master table there are two fields th...
asked by 04.10.2015 / 23:39
1
answer

XML for Database Columns

I have a table that holds an XML in one of its columns, however I need to do a select by placing each XML item in a column. The problem is that I do not want to create another table, I want something, even if it is temporary, just to make it eas...
asked by 08.10.2015 / 20:28
1
answer

Conditional formatting in a gridView

I have a gridView where all the bank information is loaded from my SQLServer . My question is this. How do I change the font color when a date is less than the system date (for example, to redirect the accounts that are due)?...
asked by 12.08.2015 / 23:42
1
answer

Calculation of time logged in SQL

I have a system where user logs in and out of the tool several times in the day during their working hours. I need to calculate the amount of time it was logged: The columns LOGOUT and LOGIN are in seconds. SELECT DATA,USUARIO...
asked by 07.08.2015 / 01:20
1
answer

Disable date in Datepicker from SQL Server table

I have a system in Classic ASP, where I have a scheduling schedule. I need to disable the dates included in the holidays and compensations table (meeting_id and date). I do not know how to do this select to populate an array of unavailable dates...
asked by 06.08.2015 / 16:28
1
answer

Insert table data with foreign key

Knowing that I have a table with the fields: [ARQUIVO_GUID] ,[XARQUIVO] ,[TAG] ,[EXTENSAO] ,[URL] ,[IS_STREAM] [ULT_ARQUIVO_VERSAO_GUID] FK [TIPO_DE_ARQUIVO_GUID] FK [DIRETORIO_GUID] FK The last 3 fields are foreign keys to other tables, h...
asked by 05.02.2015 / 21:56
1
answer

IF in StoredProcedure within a select, remove sp_executesql @query

I have a StoredProcedure that unfortunately only because of an IF it stopped being a select and turned everything into a VARCHAR statement and then I execute it, losing one of the main benefits of MSSQL being compiled. I modified SP just to...
asked by 16.01.2015 / 12:24