Questions tagged as 'sql-server'

Tagged questions
1
answer

Query Doubt - Group Data

I have a question about how to group the data as follows. I have a table named ALUNO_LEGADO , as below: I need to assemble a query to catch all the students who failed in all the subjects enrolled in a given year. Eg: Select student...
asked by 12.10.2015 / 17:48
1
answer

Deploy WindowsForms with .mdf database

I made a program in Windows Forms (C #) in layers. Model DAO BLL Interface Create in the Model Project a Bank (Generator.mdf) and its Context (edmx). Now I want to publish, and how do I get the .mdf file to come with publish?...
asked by 11.08.2015 / 04:52
1
answer

Questions about the datagridview

Hello, I have some questions about the datagridview of visual studio, I would like to know how I can change the values of the columns that appear to the foreign key of the sql server by the value of the table that is referenced to the primary key...
asked by 10.07.2015 / 02:56
1
answer

Automated Deploy - Version Maintenance for Multiple Clients

What is the best way to automate deploy? Having 1 deploy for each client, what is the easiest way to keep all of these deploys? database migrations and all version handling? In an example we have 100 clients     
asked by 09.09.2015 / 02:40
1
answer

Starting SQL Server 2008 Express r2

Well, I have a problem: I formatted my computer and I can not start SQL Server 2008 Express R2. When I click on the icon to boot the following message appears:   Microsoft SQL Server Management Studio - An error occurred while trying to acces...
asked by 29.07.2015 / 18:47
1
answer

How to execute a procedure in a select?

What I tried was the following, and my procedure returns only a select: SELECT * FROM t_usuarios WHERE nome like '%jeniffer%' AND cd_usuario IN (exec usp_lista_emprestimo_em_atraso) ORDER BY...
asked by 31.05.2015 / 21:04
2
answers

Combobox come blank VB.NET with INNER JOIN

I have the problem here and I have not found the solution yet, I am loading data in a combobox using a DATASET from an INNER JOIN done in a database SQL SERVER . So far so good that as soon as I get the cong, I would like the other combobox...
asked by 18.05.2015 / 00:26
1
answer

Use SMO in SSMS

Is it possible to use SMO SQLDMO within SSMS (SQL Server 2008 R2 version)? Use functions like list instances within the network similar to ListAvailableSQlServers() of SQLDMO?     
asked by 18.05.2015 / 19:04
1
answer

Set default value for column of an existing table

Is it possible to set a column's default value for an existing table? I'm trying the following way, but the column always gets null instead of the default value that was entered. IF NOT EXISTS (SELECT * FROM SYSCOLUMNS C INNER JOIN SYSOBJEC...
asked by 03.07.2015 / 15:03
1
answer

How to populate a code column for query with repeated values

I have a query where I have multiple data return from each user. But when I perform a search, I have the returned data as a return. I know that this repetition of the data occurs because I do not contain a single data (not repeated) in this q...
asked by 13.03.2015 / 12:45