Questions tagged as 'sql-server'

Tagged questions
1
answer

Filter data from a gridview according to a second table

Dear, I have the following doubt, in visual basic, with database sql server, I want a datagridview to show me the data of a table in my database called auto_marks_list, but it leaked without showing the marks of the cars that are stored in an...
asked by 29.11.2017 / 19:55
0
answers

How to get the value of a combobox

Good afternoon I have a question about the use of values in the combo box. In the combobox I have to show the names of the coffee and accessory, but the value it takes is its id. Something like this: Well, what I'm trying to ac...
asked by 26.11.2017 / 01:43
0
answers

doubt in FREETEXTTABLE and its KEY

I am using FREETEXTTABLE, however, when I try to do the inner join, the result is empty, showing me nothing at the end, although it does not make me an error either, it simply marks everything as empty. SELECT * FROM FREETEXTTABLE(dbo.tabla1,*...
asked by 27.11.2017 / 10:45
1
answer

How to convert from string to varbinary?

I am working in the c # language and I would like to know how to convert a string data to varbinary since I am doing a query to a database (SQL Server) and it returns the data in string and one of those data I need to assign it to a variable tha...
asked by 19.11.2017 / 02:14
1
answer

how to modify primary key in a table?

This is the problem: I have a product table (with data) and it is related to the detail-selling table (idproduct). Is it possible to update the primarykey of the product table even if that data is already in use in the detail-selling table?...
asked by 09.11.2017 / 02:37
0
answers

Connect sql server windows authentication

I have an instance of sql server, which can be connected either by windows authentication or by sql auhthentication: public static void main(String[] args) { Connection conn = null; String driver = "com.microsoft.sqlserver.jdbc.SQLSe...
asked by 15.11.2017 / 10:39
0
answers

KEEP IDENTITY IN MY DATABASE

I am developing a management project for a toy store and I have had problems when implementing transactions and it is that when I make a bad insertion of a stored procedure (by the way) my transaction does not display anything ... So I thought a...
asked by 05.11.2017 / 05:49
1
answer

I am having trouble verifying a field inserted into a table in a SQL database with a parameter

In the part of else where it says //Si tiene registros vamos a comparar el parámetro con el campo rfc I have doubts if if the comparison is made like this, the query if it brings me the data well, and the rfc that I try to enter is...
asked by 01.11.2017 / 00:39
0
answers

Write and read permission to all SQL Server 2008 R2 users

Good morning, I have a bd to which I want to give all users access and permission to write and read. I do not want to do it manually (I want to do it by means of a query) and I want to program something for each time a user is added to SQL, thes...
asked by 30.10.2017 / 19:23
1
answer

Save data from a JCheckBox in SQL Server?

I have the following JCheckBox: and I need to collect the data of each of them to insert in the table with a "yes" if they select it, and "null" if they did not select it, someone has an idea how can I do that ???? Here I leave the c...
asked by 30.10.2017 / 03:30