Questions tagged as 'sql-server'

Tagged questions
1
answer

How to set a default value created by the user when creating a table (SQL Server)?

I created a default value for my database: CREATE DEFAULT [dbo].[zero] as 0 However, I can not create a table using this default value. How do I set this value at the time of creating a table? For example: CREATE TABLE TESTE ( num int DEF...
asked by 02.12.2014 / 12:52
1
answer

Query ordering - sql server

I need to sort my query so that the column "CenterNameConsolidation" conforms to the logic applied in the column "AllNormal" could anyone help me please? WITH CentroNiveis AS ( SELECT cen.Id,...
asked by 16.04.2015 / 00:56
1
answer

SQL Server and JSP connection error

I'm trying to connect to SQL Server using JSP. But the connection is not made. Connection Class: package DAO; import java.sql.*; public class Conexao { public static Connection conectar() { try { Class.forName("net.sourceforge.jtds.j...
asked by 08.11.2014 / 18:53
1
answer

How to calculate database usage in Microsoft Azure?

I'm developing a platform where there are two parts, one administrative and one open to the public. The administrative part will insert users and some other things. Already the user will access and interact with the platform, making some evaluat...
asked by 26.11.2014 / 14:50
1
answer

Inserting datetime into SQLSRV using PHP

I'm working with PHP and SQLSRV. I need to insert a date into a field of type Datetime and I can not do it at all. At least not the ways I have found in Internet searches. The last one I tried was this, because they said it worked:...
asked by 30.09.2014 / 14:39
2
answers

ReportView without DataSet

I am finishing my TCC and I have a question regarding Reports with ReportView of Visual Studio 2013. I'll basically explain with how my application works. The connection to the database is made through a ConnectionString declare...
asked by 08.10.2014 / 15:49
1
answer

How to list sql server databases in a combobox [closed]

How to list SQL Server databases in a combobox from a C # application     
asked by 07.10.2014 / 18:48
1
answer

Sql CE 3.5: Probile in DataContext Generation

When you try to generate the DataContext to a WindowsPhone 8.1 project, through the SQL Server Compact toolbox interface at: -Generate Code (EF / LINQ to SQL / SyncFX) > > Add Windows Phone DataContext to current Project (needs 3.5) li...
asked by 02.09.2014 / 19:24
1
answer

Write fk shortly after pk is generated with entity

I have a system and in this system there are some tables that are associative. As soon as I write to the DB the main table, I need to ensure that the new PK generated is written to three other tables, but you have to ensure that it is generated....
asked by 28.08.2014 / 18:34
1
answer

add values and houses after the comma

Good morning, I have a problem here and I would like a help from you, I have a select here that brings the load of one student per subject, for each student he repeats the 2x disciplines and the different time load so I can not group, how do I a...
asked by 19.09.2014 / 14:34