Questions tagged as 'sql-server-2008'

0
answers

Subtract in PM and AM format in Sql Server 2008

Thank you in advance. I'm going around trying to subtract PM from AM The difference of format AM to PM the result is correct; however when rest of PM to AM the result is not the expected one The insertion in the BD I do it this wa...
asked by 22.06.2017 / 00:24
0
answers

DataGridView filter and sort columns

I would like to be able to filter and sort columns of a DataGridView, just as it is done in Excel. Could you indicate if this should be done by programming, for example to filter: Include an arrow in the Head of the Column and there put an event...
asked by 17.05.2017 / 00:33
1
answer

Query to associate the field of a table with its default value

I am doing a large query to generate a data dictionary, where I am indicating to each field of the table if it is fk, pk, if I have designated a default value (CONSTRAINT-- DEFAULT ()). And it is in the latter that I can not associate the field...
asked by 21.03.2017 / 16:53
3
answers

Subtract 3 days from sql dates with c # [duplicate]

public List<DateTime> fechas3() { List<DateTime> list = new List<DateTime>(); List<DateTime> fec = new List<DateTime>(); SqlConnection cone = new SqlConnection(connect); cone...
asked by 07.12.2016 / 20:32
1
answer

PHP, SQLSERVER and JS

The code does not work does not throw me any kind of error I do not know what is wrong I hope you can help me. The validation does not work with js, nor does it show me the echo of the connection function valida(){ var cod,nom,rut,fon,...
asked by 23.12.2017 / 06:49