Questions tagged as 'sql-server'

Tagged questions
1
answer

SQL Server 2012 - Login for SQL Server Authentication

At the installation I put a password and wrote it down. When I login for SQL Server authentication the login field is blank, I just wrote down the password I do not know the login. I tried the same as Windows authentication, but it did not work....
asked by 05.06.2017 / 00:23
1
answer

Error executing SQL "Create Trigger ..." within a C #

Goal: Run a create trigger script using a string inside C #. Problem 1: Table not found (because the script does not indicate in which Table to create the trigger). Attempt2: Start the string with "Create Trigger on [dbo]. [Table]". Pro...
asked by 14.06.2017 / 14:23
1
answer

I inserted an html into a table using sql server

How could an insert into a table an HTML code? Example: insert into TB_CONTEUDO (CONT_TITULO, CONT_HTML, CONT_COCA_FK_ID, CONT_META_TAG) values('Teste','',17,'') CONT_HTML = html of a page     
asked by 02.06.2017 / 21:46
2
answers

Store procedure is not working correctly

I created a StoreProcedure named, CancelNote, which, by using cursors, returns the products to the stock, passes the status of the item to canceled. It is working, however, not setting the "status" value in the [status] column. If someone can he...
asked by 30.05.2017 / 21:12
1
answer

Search for values with priorities

I'm trying to search and I can not find the right logic to filter the results I want. I have a table with all the due dates for certain equipment. My problem is related here: Equipments (1, 22, 23) are from the same group, so if one of...
asked by 23.05.2017 / 13:47
1
answer

Delete in sql - Inner Join

How is the syntax of a query using Inner Join delete in sql, to compare two-table code and exclude to be equal? Sales item table. in the item sale table, a sale has been registered whose code is 4. To execute the reversal, if applicable, the...
asked by 27.05.2017 / 20:56
0
answers

The "Bank" database is not accessible. (ObjectExplorer)

I created a new windows 10 local account. With this new account I can not access the database. Because the old Windows 10 account was in trouble. This is why I created a new local windows account. (New user) Former local windows account was "...
asked by 25.05.2017 / 20:35
1
answer

How to do a remote configuration of the Sql server?

Good afternoon, I need to develop a C # system that needs to use the same database on three separate computers, so I need to allow my SQL Server 2008 R2 to allow remote connection to the computer that will locate the database.     
asked by 19.05.2017 / 14:53
1
answer

Bring the word HISTORICAL when the Line Date is shorter than the previous dates,

I have a query where I should record the rows with error with the word History, the rows that bring the date LESS than any of the dates of the previous rows should display the word HISTORICAL, Can you help? the column in question is TYPE, T...
asked by 24.05.2017 / 03:31
0
answers

Code Igniter - How to call a procedure that is in another database?

I have a SQL Server where we have several databases and their schemas. So that's fine, but I need to access a stored procedure that is in the X bank. I have tried this: $ this-> db-> query ("cadunico.dbo.CadUnico_Educacao_Consultar"); but whe...
asked by 10.05.2017 / 21:18