Posts by Durval Ramos • 33 points
6 posts
-
1
votes1
answer5001
viewsA: Remote procedure call failed. [0x800706be]
This issue is related to an incomplete update that did not update all the components needed to run one or more SQL Server services. Install the latest SQL Server 2008 R2 Service Pack to fix this…
-
0
votes1
answer655
viewsA: Script for Run in Function
In SQL Server it is not possible to run stored procedures within Functions, but you can add conditions to perform different SELECT instructions for each database. Follow a T-SQL script for you to…
-
0
votes2
answers320
viewsA: SQL Server - Doubt update and relation between tables
Just by complementing "the correct answer" of Caffé, your UPDATE is actually performing a "CROSS JOIN" with the "material" table because it is not defining the records that should be affected in its…
-
0
votes2
answers1940
viewsA: Update with select in time table
Raimundo, To perform an "UPDATE" statement with a temporary table, you will need to link the information between the table that should be updated (I believe that in your case the ideal is to use the…
sql-serveranswered Durval Ramos 33 -
0
votes2
answers384
viewsA: How to mount a select that brings information of which column is PK, which is not, and which is FK
To use in an SQL Server database, the ideal is to use the "Information_schema" but on the tables: Follow a T-SQL script for your use: SELECT KCU.table_name, KCU.column_name field_name,…
-
2
votes1
answer415
viewsA: How to send data from one table to another with the Deleted command
You need to set the "affected" column in the DELETE you want to get. In this case, use the instruction "Deleted.Suacoluna". Below is a T-SQL script for you to adapt your need: CREATE TRIGGER…