Posts by Alberto Cláudio Mandlate • 399 points
20 posts
-
1
votes3
answers6516
viewsA: How to convert varchar to Numeric in SQL?
Surely in the table where the CPF is varchar there is some record that has a value of the non-numeric type. Pay attention to the spaces in the field. You can make use of the functions Ltrim() and…
-
0
votes2
answers2827
viewsA: SQL Server Create a filter in a Datetime field, bringing the previous 24 hours (not counting the current time)
Long live, 1st we must be very careful when dealing with dates. Although the code SELECT GetDate()-1 automatically understand that it is -1 day, could perfectly consider -1 second, minute, hour,…
-
0
votes2
answers95
viewsA: Query including multiple tables
SELECT Resultado.mae,Resultado.Pai FROM( SELECT DISTINCT 1 As Ordem,mae.nomepessoa as Mae,''as Pai FROM dbo.bpm_pessoa As mae JOIN dbo.bpm_pessoarelacionamento As maerelacionamento ON…
-
2
votes2
answers325
viewsA: How to insert data into another database with Linked Server
Boas, Since the 2 Servers are SQL Server 2012, why don’t you use SQL Server Native Client instead of OLE DB. Ole DB works with more widespread features of various Database engines. Quite different…
-
0
votes2
answers115
viewsA: Select all customers and check if you are carrier and supplier
--Fornecedores Select C.CliCod As [Código], C.CliNom As [Nome],'Não' As Fornecedor,'Não' As Transportadora From T0158 Union All --Fornecedores Select F.ForCod As [Código],…
-
0
votes2
answers453
viewsA: Trigger with null value
CREATE TRIGGER VERIFICA ON cliente AFTER INSERT AS BEGIN IF Exists( Select inserted.campoSChave From inserted Where telefone is null Or endereco is null ) Begin RAISERROR ('Campos nulos', 11,1);…
-
0
votes2
answers751
viewsA: Maximum size, connection limit and which version of SQL Server should I use in my desktop application
When you are developing a solution (or an application), you should take into account a few points: How many users will make simultaneous use of the Database What is the volume (in MB/GB) of…
sql-serveranswered Alberto Cláudio Mandlate 399 -
0
votes3
answers282
viewsA: How can I do "Inner Join"
Using T-SQL would be SELECT Tabela1.Campo1,Tabela2.Campo1,Tabela2.Campo2 FROM Tabela1 INNER JOIN Tabela2 ON Tabela1.Campo1=Tabela2.Campo2
-
0
votes2
answers51
viewsA: Error Backing Up Windows Forms Database
Take into account some points: The address indicated in the backup command is always considering as a departure the view from the server where the instance is installed The user configured in SQL…
-
1
votes2
answers235
viewsA: Case in Where using SQL Server
Include the option on WHERE WHERE (IsNull(@opcao,'') In ('S') And NFDataEmis Between lme.LogMovEstqDataHora And ppme.ParcPagMovEstqDataVenc) Or (IsNull(@opcao,'') In ('N') And ec.CategCodEstr Like…
-
1
votes1
answer51
viewsA: Error creating Diagrams in Sqlserver Studio 2014
Hey, are you the comic book owner? The problem may be related to whether or not you are the Owner. Try BD Detach and Attach.
-
0
votes5
answers17754
viewsA: How to solve accent problems with ASP.NET MVC?
I have the solution to your problem, follow the following steps: 1. Open the file containing accentuated words; 2. Go to the File->Save As; 3. And there press the little arrow button Save and,…
-
1
votes1
answer55
viewsA: View coding
I have the solution to your problem, follow the following steps: 1. Open the file containing accentuated words; 2. Go to the File->Save As; 3. And there press the little arrow button Save and,…
-
6
votes6
answers49720
viewsA: Convert DATA dd/mm/yyyy hh:mm:ss to yyyy/mm/dd
DECLARE @data datetime=GetDate() SELECT concat(YEAR(@data),'-',MONTH(@data),'-',DAY(@data)) As data_convertida Concat function is valid only from SQL Server 2012 if you do not have this SQL use as…
-
1
votes3
answers7027
viewsA: Is Sql Server Agent (SQLEXPRESS) on Local Computer started stopped?
Good, The SQL Server Agent (Sqlexpress) is not the main service of SQL Server. You must start the service SQL Server (Sqlexpress) which is quite different from Agent. The SQL Server Agent is…
sql-serveranswered Alberto Cláudio Mandlate 399 -
1
votes1
answer44
viewsQ: Change WCF address in Windows Universal App from development to production environment
I am developing an application in Universal Windows App (for Windows 10, Windows 10 Mobile, etc), which basically this application makes the consumption of data that are in the service running in…
-
0
votes2
answers62
viewsA: Doubt using RIGHT JOIN in Sql Server
Use CROSS JOIN if you don’t want to search for a relationship between them.
-
1
votes2
answers685
viewsA: Schema permission in specific user
Properties of your SCHEMA > In the left tab click on Permissions > click on Search (to search the user) > below are the user permissions on Schema
-
5
votes2
answers1544
viewsA: Export SQL Server 2014 Database
Boas Carlos, It is important to know what version of it is. You can copy these files and send them to it, but it is necessary to stop the SQL Server service. You can also make a Backup and send it…
-
0
votes1
answer57
viewsA: Doubt about file storage on server
It all depends on the solution you want to implement and what resources you already have. Storing in the Database is a good idea, it has no great impact on performance (contrary to what many people…