Questions tagged as 'sql'

Tagged questions
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 / 20:55
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 / 18:22
1
answer

Delete repeated records in a sql server table

I want to delete repeated records from my database and leave only 1, any ideas?     
asked by 12.01.2018 / 21:38
1
answer

Query no longer works in Access

I am working in a database with information about courses and I created a query to know how many courses each vendor sold per month. This is the query: SELECT DISTINCTROW tblStudentCourses.SalesID, Format$([tblStudentCourses].[SignDate],'mmmm...
asked by 12.01.2018 / 22:03
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 / 13:54
0
answers

show image having name in database in android

good, I would like to consult, since I did not use the method of saving the image in the db, I would like to show an image that I have stored in the directory of the same application, but I would need to take the name from the database, but look...
asked by 12.01.2018 / 13:12
1
answer

What is the advantage of adding indexes in the tables in SQL [closed]

Hello to everyone at StackOverflow !! I hope you are well. Regarding my query, I would appreciate knowing what is the advantage of using Indices-I understand I can have up to 250 per table-in my SQL tables and if there are cases in which they...
asked by 24.01.2018 / 17:04
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 / 19:57
1
answer

Export to Excel data of a table in SQL

Hi, I'm doing a platform in asp.net with vb language and I need to export data from a sql table giving it a parameter in the application I'm doing, the only one way I could export this data was using a handler (generic driver), but only doin...
asked by 18.01.2018 / 19:44
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 / 16:52