Best answeres tagged with sql-server

1

answer

Accessing SQL Server 2008 data from MySQL

Does anyone know if I can access data from a SQL Server 2008 database from a MySQL database? It would be something like Linked Server, but otherwise.

asked by 11.09.2017 / 19:35

1

answer

Dump Database

Is there a way to tell if a database has been DUMP ?

asked by 12.09.2017 / 04:06

1

answer

Encrypting Function Script and Procedures in MSSQL

One question, I have some custom functions and procedures, and I do not want my client (who has access to the bank) to mess with their script. Does anyone know of any native way of MSSQL to encrypt these codes?

asked by 01.08.2017 / 16:15

1

answer

Creating Trigger

I need to develop a trigger where any change that occurs in one of these fields below the Task table should send the task information to the Instruction table. TASK TABLE TarefaID Vencimento Status Caminho ModuloID 170123...

asked by 31.10.2017 / 13:14

2

answers

Search XML field information in SQL

I need to search inside a field where I store an XML The XML is from a CT-e and has a series of tags in it and I need to find a data inside a specific tag. Below the table structure TheXMLhasthefollowingstructureandwithinitthefieldInee...

asked by 18.10.2017 / 17:34

1

answer

Using Case When with LeftJoin

I am putting together a proc, but depending on the value of a parameter, I would like the left join to be different. I have tried the querys below: This works, however, else as null or even else , if the parameter COD_...

asked by 07.08.2016 / 22:45

2

answers

How to use the like in a field comparison in different tables?

How can I use LIKE for a comparison of two different table fields? I need to compare the first 5 characters of each field. I tried SUBSTRING and with LEFT , however, the performance gets pretty bad. Here are two ways I applied, with the c...

asked by 22.02.2017 / 13:40

1

answer

Converting an nvarchar data type to a datetime data type resulted in a value outside the range

Line of code INSERT [dbo].[Shop_Goods] ([TemplateID], [Name], [Remark], [CategoryID], [Description], [Attack], [Defence], [Agility], [Luck], [Level], [Quality], [Pic], [MaxCount], [NeedSex], [NeedLevel], [CanStrengthen], [CanCompose], [CanDrop...

asked by 21.07.2016 / 17:00

2

answers

Concatenate values from the same column

asked by 28.06.2016 / 19:34

1

answer

How to throw custom T-SQL exception?

I have a tigger for CPF validation, and I want to throw an exception if the entered CPF is invalid. About throwing exceptions I've been reading this # But what I want is to throw a new exception, an exception that does not exist in the syst...

asked by 26.06.2016 / 16:30

Questions tagged as 'sql-server'