I have a view with a column of type varchar and I am trying to convert this column to a type date time my code is here:
update temp_vertical_dashboard
set data = convert (datetime,data,101)
temp_vertical_dashboard is my view and date is the...
Hello, I need some help!
I need to do a query and bring the NIF's, without repeating.
I do it like this:
SELECT DISTINCT NIF FROM CustomerRegistrations
But I want to bring in more columns from this table as well. But I can not do this:
SE...
I created a simple CRUD using the ASP.NET MVC and I can save my records normally. If I looked in the database, my date ( DataCriation ) was stored like this:
2017-06-01 00: 01: 23,750
But when I try to edit the same record with a...
IF (count (UCID)> 1, count (UCID), '0') , it brings me approximately 500 record lines, being numbers 2 above, I want to be able to do a COUNT in that IF to display those 500's in a separate column.
Anyone have a suggestion?
Thanks in advance....
I need help to create a Trigger in SQL Server that takes a value INTEIRO , and two STRING(FK) , inserted in a tabela X , and check if the second value is 1 or 2 , if for 1 it must add this value INTEIRO...
Good morning.
I have a table with columns Version , Updated , LastChanged .
I want to make a query to select the highest value of the version, with its LastChanged , corresponding to Updated = 1;
I did, but it d...
Good morning ..
I have table [BCT_PESSOA] with PK [ID_PESSOA] this table has relationship with table [BCS_USUARIO] with column [ID_PESSOA]
I would like to return all records in the [BCT_PESSOA] table that...
Good evening
I installed Microsoft SQl Server Management Studio 2008 on my machine for local testing, but I can not access it.
Even though it is free, how can I instantiate access, will I have to reinstall the bank?
Following error:
Good evening! When I try to insert a record in SQLServer through my application I am getting a truncated data message. The problem is that there are many columns that this screen fills and I have no idea which one is being truncated. Is there an...
Good afternoon.
I have a procedure, in it I have several filters.
one of these filters is @ST_TIPO
-When I get by BSP Parameter I want to filter only by PT.ST_TIPO = 'BSP'
-When I get by Parameter ' DIS ' I want to filte...