Questions tagged as 'sql-server-2012'

Tagged questions
0
answers

Select from a table inside a cell of another table [closed]

Can not you% construct a table that contains one result of another table in one of its columns? The master key would be the reference.     
asked by 01.02.2016 / 20:27
1
answer

SQL Server 2008 Management Objects: Can I uninstall?

Please, it's a simple question. I'm starting to study SQL and downloaded the 2012 Express version. With it came SQL Server 2008 Management Objects. Can I uninstall without any concern or is it important for the operation of 2012? Thank you in...
asked by 14.04.2015 / 04:35
3
answers

SELECT on a table using NOT EXISTS SQL (SERVER 2012)

I'm trying to make a Select tb1 using Where NOT EXISTS (select* tb2) I'm trying to select the row in tb1 that does not exist in tb2 to INSERT later. However when doing test on select it is not returning the lines that do not exist in t...
asked by 14.06.2017 / 18:45
2
answers

Duplicate keys

** Improving the Post for a better understanding of what happened. Person, good afternoon. I created a 'customer' table in the sql server and put the email field as vachar (50), unique and accept null Why logic, there are not 2 emails equa...
asked by 08.09.2018 / 19:55
1
answer

Avoid saving duplicate data

In my project I have a rule that does not save and does not show in Grid duplicate data. For example, on the system I read an XML and save the tags information to a table in my database so that this information is displayed in a Grid ....
asked by 29.06.2015 / 14:23
3
answers

SqlServer Select in XML field

I need some help with the situation below: In my SqlServer 2012 table I have a field with xml values, I would like to make a select of the data from that field and show the result in columns form. Image 1 <row> <ID_Cota...
asked by 04.05.2016 / 12:57
1
answer

SQL query to return only if upper case

I would like to make a query in a column and that the return would be only the capitalized words that match the searched criteria (user input), regardless of whether the criteria was typed in uppercase or lowercase. CREATE PROCEDURE uspConsult...
asked by 26.03.2017 / 22:23
1
answer

SELECT with intermediate table returning all values in the same field and separated by commas

I have the tables (and their relationships) in the diagram below: I need to do the following: Bring all the fields of the TBCADCRE table and an extra column named ADQ with all the TIPADQ that the user has (can have a maximum of 6) separate...
asked by 23.08.2018 / 23:39
1
answer

When the Trigger SQL server is fired After Insert?

When a trigger is triggered after an insert and the insert is within a transaction, does the trigger execute at the time of the insert or at the end of the transaction?     
asked by 07.03.2018 / 21:18
1
answer

Select does not return broken value

I have the following command: SELECT CAST(450/4 AS DECIMAL(15,2)) Return : 112 where the right one would be 112.5 Why this? NOTE: My SCRIPT is in a procedure, but roughly my problem is in this select     
asked by 17.03.2018 / 21:42