Questions tagged as 'sql-server'

Tagged questions
1
answer

Granularity in Database [closed]

I need information about what it is and how it is handled Fine granularity , especially in SQL Server . Thank you very much     
asked by 21.01.2018 / 18:18
1
answer

powershell: how to run an array in a query?

How can I change the word buin in my query to those in the array? $DB_NAME_M = "<A>(<B>)"; $TIMESTAMPP = Get-Date; $TIMESTAMPP = $TIMESTAMPP.ToString("yyyyMMdd"); #Arrays $DB_ARRAYY = @( "elquisco", "imelbosque", "macul", "larein...
asked by 15.01.2018 / 21:55
0
answers

Help, I can not connect from Netbeans with Sql Server

I've been making several attempts but it has not worked. My connection string is this: public String conectar() throws ClassNotFoundException { try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String...
asked by 16.01.2018 / 14:31
0
answers

I can not make PHP 5.6 connection to SQLSERVER

I've tried to run sqlserver with php but I have not been successful. It does not show me in phpinfo(); that the driver likes. I have this configuration:    System: Windows 10 Pro 1709 64 Bit   Compiler: MSVC11 (Visual...
asked by 16.01.2018 / 19:22
2
answers

Help to consult several tables

I need to extract the data from several tables, for which I made a selection of the question to which the people signed up and the ID of that question corresponds to id 22 of the table "Responses". Now, once filtered, I need to know who were the...
asked by 24.01.2018 / 14:54
1
answer

How to update a database based on a DataGridView on VB.net?

I am loading a dataset directly to a DataGridView, it has the option to edit its records (in the DataGridView), but when finished it gives the option to save the changes, my doubt is how to save only those that were modified directly to the data...
asked by 24.01.2018 / 18:43
1
answer

Concatenate Time and minutes in SQL server

I have the following query: CONVERT(TIME,convert(varchar,F.T2InHour)+convert(varchar,F.T2InMinute),108) What I want is the following in F.T2InHour I have the Hour and In F.T2InMinute I have the minutes, I want to join them and...
asked by 17.01.2018 / 20:57
1
answer

Optimize tables in Database

Good morning, I'm modifying an app where access to different user types is required, the app has a table for each type of user (if the app works) but if you create N types of users you would have to create N tables which I do not see as feasible...
asked by 18.01.2018 / 17:52
1
answer

Impossible to install Reporting Services 2017 [closed]

I have a computer with Windows 10 and SQL Server 2017 Standard installed. I'm trying to install the Reporting Services (I see that the installation is now independent), but when I run in executable that is downloaded from the Microsoft website,...
asked by 09.01.2018 / 17:12
1
answer

Load variables depending on selected item MVC C #

Inquiry Good, I would like to save variables by default after selecting an item in a select (to then insert them into the database). In my case the select "State of work" (which is loaded by call to database). The idea is that depending on th...
asked by 08.01.2018 / 22:25