Questions tagged as 'sql-server'

Tagged questions
1
answer

Call method of C # in javascript

I created a method that calls data from a database in C #. How can I call this method in JavaScript? Follow the code [WebMethod] public copa recuperaDados(int cAno) { var con = ConfigurationManager.ConnectionStrings["Data So...
asked by 19.05.2018 / 03:05
0
answers

Elastic transactions with MS SQL Server

Considering the following code snippet: using (var scope = new TransactionScope()) { using (var conn1 = new SqlConnection(connStrDb1)) { conn1.Open(); SqlCommand cmd1 = conn1.CreateCommand(); cmd1.CommandText =...
asked by 13.06.2018 / 15:53
2
answers

Help with handling employee schedules

I have a situation regarding the lunchtime of the employees of the company; I need to limit the number of employees who can have lunch at the same time, at least together within 15 minutes, so if I have 10 employees leaving for lunch at 12:00, t...
asked by 10.04.2018 / 18:29
0
answers

How to give an update determining a sequence to be changed?

Good morning! I have a rather boring situation here at work ... I would like an idea to solve this problem. There is a case that often happens that is basically the following, When a client fails to perform the cash map on the day as in examp...
asked by 18.04.2018 / 15:44
0
answers

StoredProcedure in SQL Server by passing a C #

I would like to pass a list of parameters to a procedure, how to do this process? I did some research and found that it is possible to create a TABLE TYPE and use it in the procedure parameters, but I could not use it, for example. CREATE T...
asked by 06.04.2018 / 17:35
1
answer

Is it possible to consume data from a webservice inside a SQLServer directly?

I have to migrate one database in MySQL to another in SQLServer. In this migration, I have the following problem: not all address records are complete but I have the zip code of most of them. My idea then is: Use the link site service to c...
asked by 16.04.2018 / 21:37
0
answers

MV Azure Configuration and SQL Server

I need to develop a system for a medical clinic and this system will be accessed by 2 Receptionist and 2 Physicians. Home Initially the System is not complex but tends to grow as the Clinic will hire more Physicians. Home I want to develop in AS...
asked by 17.03.2018 / 20:36
1
answer

Join two IFs or more

I need to join some if 's and I'm having trouble, I have already tried using union , but to no avail. The query I'm running is: IF (select count(Estado) FROM tbl_1 where Estado != 'WIP' AND Estado !='on hold') > 0...
asked by 20.03.2018 / 16:40
0
answers

Extract file from the database (varbinary) and use it on the web

I have files saved in a column of my bank ( SQLSERVER ) of type varbinary and need to recover these saved files in this column and > show - them in a modal or download - them ; however, I need to do this using JS . Can someone help...
asked by 21.02.2018 / 16:14
0
answers

LCK_M_IX in SQL Server database

Well, I have two separate client bases in SQL Server 2008, and both are using the same system, which uses BDE to connect. I have an application Scripter to do SQL queries on the databases. Problem On both bases, I run select * from...
asked by 20.02.2018 / 13:56