Questions tagged as 'sql-server'

Tagged questions
1
answer

Should I declare scalar variable?

I have a method created in a mapper that I use to verify the username and password for a login, the code is as follows: public Usuario buscarUsuarioPorNombreYContrasenia(string xNombre, string xPass) { var param...
asked by 28.12.2016 / 01:53
3
answers

Casting of dates stored as Varchar

Good, everyone again requesting your support as I have a question about Casting a date, which is stored in the DB as Varchar with the following format 20161105 0207 , I need to make a cast of this DateTime , the first 8 digit...
asked by 13.12.2016 / 02:35
1
answer

Uniqueidentifier vs conventional id (SQL Server)

Good morning, today I want to ask a question about performance (time) on what is more efficient, if you have a conventional id, type INT , or have a column type UniqueIdentifier . With respect to the statement they are practically...
asked by 15.12.2016 / 16:47
1
answer

Error with project interface

Buens, some have an idea of why the graphical inteface of a project can change drastically when uploading to IIS7 (windows and), I have a project and when I run it locally everything is fine, but in IIS the interface changes and some functions t...
asked by 20.10.2016 / 19:38
1
answer

How to insert in a SQL server table a field that is not auto-incremented?

I have a table that has an "id" field but it is not defined as auto-incremented within the DB, there is a possibility that when inserting a record, it indicates that the "id" is going to be a self-incremented field using C #.     
asked by 17.10.2016 / 19:27
1
answer

update with two tables

I want to make an update to the reference table the field I want to update is the active_type and it is only in the table (active), which joins active and reference is the field (reference). The active table has several example sequences (223...
asked by 25.10.2016 / 00:50
1
answer

Switch from PostgreSQL to SQL Server

What happens is that I have a PostgreSQL script and I need to pass it to SQL Server. Does anyone know a tool that is effective?     
asked by 16.10.2016 / 15:19
1
answer

Why does this error occur? Input string was not in a correct format in c #?

Good morning: Peace with everyone ...    Error Searching in textbox is not controlled FromException, Input string was   not in a correct format. the folio is numeric type, when searching in my textbox if it does, but when you remove every...
asked by 23.09.2016 / 16:29
2
answers

Bitacora of a database?

I need to create a trigger that registers the insert, update, delete that happen in a certain table. For this, I have the following code in which, within the trigger for insert that I already have defined, I miss an error in saying that the name...
asked by 01.11.2016 / 20:32
1
answer

How to recover sql server base deleted from object explorer?

There is some way to recover a deleted database from the sql server object explorer     
asked by 04.10.2016 / 00:03