Questions tagged as 'sql-server-2008'

Tagged questions
1
answer

relate two tables

I would like to know how I can relate two tables to different databases so that every time the value in the table bank1.dbo.table id1 will be changed also in bank2.dbo.table id1, modifying according to the row (id) which is being modified The...
asked by 19.09.2018 / 07:55
3
answers

Difficulty in formulating a query

In a system there are registered plots . users can as plots with FamilyParcela where each user has their own / strong>. plots are common to all. I have 4 tables: User that has classificar PK Parcel that has...
asked by 09.03.2016 / 02:09
1
answer

Increase sql performance

I have this function below that executes this SQL, but the execution time of this SQL is too high would I have any way to decrease the execution time? At the time of loading the page takes about 5 seconds to execute the query below. Would you li...
asked by 02.06.2016 / 19:08
2
answers

Multiplications contained in texts

How to make the multiplications contained in a varchar field? (to get the area in case) +------------------------------------------------------+ | DESCRIÇÃO | +---------------------------------...
asked by 20.02.2015 / 18:24
1
answer

How to set a default value created by the user when creating a table (SQL Server)?

I created a default value for my database: CREATE DEFAULT [dbo].[zero] as 0 However, I can not create a table using this default value. How do I set this value at the time of creating a table? For example: CREATE TABLE TESTE ( num int DEF...
asked by 02.12.2014 / 12:52
2
answers

Doubt with a query (SQL Server)

Good afternoon! I have a set of information in a SQL Server database (I'm still learning SQL Server), and I need to filter the information that is returned to me. They are information of employees of a company (enrollment, cpf, name, position...
asked by 21.12.2018 / 18:18
1
answer

MSSQL Query on Ubuntu 18.04 LTS stopped working

I have a program that has been running on Ubuntu-server 17 for some time. This system performs queries on a database server with MSSQL 2008. I did the installation of Ubuntu 18.04 LTS, and did not change any of the code. However, the query is no...
asked by 24.05.2018 / 17:31
1
answer

Function max E Cast JUnta Sql Server 2008 R2

I need to convert a field from Nvarchar to Float in a search, and get the highest value. This function works SELECT MAX(valor) from [Enops].[dbo].[Tbl_Pulsomedia15_Vazao_Eta_B_Bentes] Where valor <> 'processando' and valor <>...
asked by 17.01.2018 / 11:58
1
answer

Access Database on the client machine from Web Application

Hello, good afternoon. I'm developing a system that has only one code for multiple databases. The system has already implemented almost everything, but when I started to test the connection on the client machine, after I publish it is always...
asked by 08.01.2018 / 19:40
0
answers

database vendor code: 521

I am not able to run these queries in sql 2008 I took the test in 2014 and it worked could someone help me? I'm too close to the bridge to find a solution. Follow the query: SELECT D1_COD, D1_FORNECE, A2_NOME, --1ª COMPRAS-- MIN(COMPRAS.D1_...
asked by 18.04.2017 / 19:57