Well, it's the following, I do not understand where I should start, if I must first select the clients, I'm sure I'll use inner join or some joiner since it uses other help tables. I wanted help to understand how to do this query....
I have a database in SQL Server 2008 R2 with a size of 65GB, and I own it in .BAK as well.
Is it possible to import this database into my azure account?
Hello.
I want to synchronize a table with the Linked Server, however the problem is that the table has composite primary key, and I do not know how to do the check to fetch the record.
Can someone please help me?!
Thank you!
Galera,
I have this piece of XML and I need to remove the value (357122.40) that is between the < vMerc > xxxxxx < / vMerc > However, this value does not have a fixed size.
...<infCTeNorm><infCarga><vMerc>357122.4...
I am trying to generate a report in 'Crystal' on my company's system programmed in VB6.
However, the following error appears in the appendix.
I researched this DLL, but the answers I got did not solve my problem.
I'm waiting.
Hi, I have several servers that I use in my development environment, but I would like to know if colleagues know of any tools or procedures in sql itself that I can only back up the databases framework.
That is, if there is a disaster in this...
I have a C # project and need that when I create your installer it is also installed on the client machine SQL Server 2008. Would it be possible to do this?
To be honest, I do not even know how to start my question. So I'll first put the information I have.
I have the following structure in my database.
I need to do a SELECT that returns me the following:
How can I achieve this?
...
In another question I asked I had found a solution but the sort order works only if the ID's are growing:
USE TESTE
GO
WITH Niveis AS (
-- Membro âncora
SELECT Id, IdPai, convert(varchar(1000), Nome) as Nome,...
I have a sales system in WPF / EF that is in use in different cities, but the database is in headquarters. I'm having trouble when the city link is too slow, resulting in a slow sale.
Can I do a replication of this my database to the local se...