You appear to be asking a question about something you found on an article. The chances of an author happening on a question about their article is extremely low. Go to the article and ask your questions in the forum at the bottom. Oh, and don't...

JPEG

streaming

server

Motion JPEG streaming server demo

2 Apr 2024 by Member 16235344

Brother Ragheed Al-Tayeb, I am using the Motion JPEG Streaming Server Demo version for 1 of my project it is working as design, the only issue I am having is the screen size, it is 50% of the window in the browser, Chrome, FireFox etc. Can you...

JPEG

streaming

server

Motion JPEG streaming server demo

2 Apr 2024 by Dave Kreskowiak

You posted this in a public forum with over 15 million users. The chances of Ragheed stumbling across this post is close to zero. If this is concerning an article he posted, there is a forum at the bottom of that article. Ask your question...

JPEG

streaming

server

SSRS report keeps asking for username and password for the datasource

12 Mar 2024 by carlitosd19

OK, I find a way to fix this: 1-Set you connection string inside the Data Source in the General Tab (include your username and password) 2-On the Credentials Tab, set "Do not use credentials" 3-Save the report and reopen and run it. that's all :)

SQL

SSRS

server

How to Transform Binary Files into Powershell Script(s) in Order to Copy them Silently on a Server

2 Mar 2024 by Federico Di Marco

A tool which creates one or more Powershell scripts which in turn recreate one or more binary files

I had url http://website.aspx make a control center page in aspx from there button click go to that url make card of that mainpage.aspx in controlcenter.aspx

29 Jan 2024 by Mayank Kushwaha 2022

public partial class ControlCenter : System.Web.UI.Page { GetData GetConn = new GetData(); //protected PlaceHolder cardContainer; protected Panel cardContainer; protected void Page_Load(object sender, EventArgs...

How to resolve the exception and the crash are originating from the runtime itself for RDLC report application

22 Jan 2024 by Dave Kreskowiak

First, that's not an error. That's Trend Micro's anti-virus software preventing your site from working because it's suspicious of something in your code. If Trend has been removed from the machine, or otherwise disabled, you have another...

How to resolve the exception and the crash are originating from the runtime itself for RDLC report application

21 Jan 2024 by SNI

We have report application (.rdlc) which was running fine but suddenly it is giving error for Trend Micro User-Mode Hook Event Module error and post check we have observed that w3wp.exe was not running. Post trying manually this exe is failed...

A DIY Web Enabled Water Meter

16 Jan 2024 by deangi

An ESP32 is used to track water usage and serve web pages with water use data

Express server slow response in chrome, but not in firefox

8 Jan 2024 by Blainecode

API respond time in Chrome: 20.37ms API respond time in Firefox: 0.5ms - 1ms as expected. OS: Fedora Linux 38. What I have tried: I have an Express server and a client in the AWS which EC2 free service, but my server's respond time have...

On browse dummy text gets added to the url

15 Nov 2023 by Richard Deeming

You have configured "cookieless" session state: HttpSessionState.IsCookieless Property (System.Web.SessionState) | Microsoft Learn[^] The added text is your session identifier. It was never a particularly good idea. You should disable...

On browse dummy text gets added to the url

15 Nov 2023 by kedar001

Dear all, facing issue while browsing the Site I have configured the virtual directory in IIS 8, OS (Server 2012 R2) on browse, dummy text (highlighted part) gets added in the URL. ...

IIS 8.5 Access Denied when stopping App Pools

15 Nov 2023 by Member 16140669

For the permission error "Filename: redirection.config\r\nError: Cannot read configuration file due to insufficient permissions\r\n\r\n", I added a new user called IIS IUSRS (put it in the name check area and check it to get the correct name) and...

Remove customerid1 if first time selected then not display customerid1

6 Oct 2023 by Mayank Kushwaha 2022

protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) ...

SQL

ASP.NET

server

Unable to update windows server 2012

9 Aug 2023 by Member 16068130

Was trying to apply windows monthly patches via windows update on a Windows 2012R2 server. Windows update fails with error code 80072EF3. I resolved it be setting the system proxy (with the netsh command) and configuring the proxy setting in...

Windows

server

biztalk

How do I create download link to a file outside of blazor project.

24 Jul 2023 by NewButTryingHard

I have data drive with folders of .mp3 files with .csv as database (written by another program to a data drive) I created a Blazor Server app that displays the .csv data in a table, including the path to the file. How can I create a link in the...

Blazor

server

How do I create download link to a file outside of blazor project.

23 Jul 2023 by Dave Kreskowiak

You cannot create a link direct to a file outside the apps own directory. This is for security reasons. You can, however, create a link to a code on the server-side to tell it which file to download and that code would have to read the file and...

Blazor

server

Conversion failed when converting the varchar value '@' to data type int.

10 Jun 2023 by Luz Angelica Benavides

Tengo un error a la hora de probar el store procedure. Sin embargo desde el principio se declaro como int. (Translates to - "I have an error when testing the store procedure. However, from the beginning it was declared as int." What I have...

SQL

server

Conversion failed when converting the varchar value '@' to data type int.

9 Jun 2023 by OriginalGriff

Remove the quotes if you want to use variables: WHERE USUARIOS.rol_id=@rol_id and USUARIOS.id_usuario=@id_usuario and USUARIOS.clave=@clave and USUARIOS.estado=1 Quotes delimit string literals, so you are trying to compare an integer with...

SQL

server

How can use machine learning in c#.net

27 Apr 2023 by Harsh Seo

You can use machine learning in C# by leveraging popular machine learning libraries such as ML.NET, Accord.NET, and TensorFlow.NET. These libraries provide pre-built algorithms and tools to help you build, train, and deploy machine learning...

SQL

.NET

server

How can use machine learning in c#.net

27 Apr 2023 by Member 15418280

How can use machine learning in c#.net . What will be the use case of machine learning in dot net c#. What I have tried: I tried to explore to find out the use case.

SQL

.NET

server

How do i scan open udp port in autoit?

24 Apr 2023 by Fatin Fatima Abdullah

I am working on a program for TCP/UDP port scanning. TCP is working fine and well but it seems like I have no idea on how to achieve the UDP port scanning using the AutoIt.Since the UDP port is connectionless I am using UDPOpen function to bind my $PortIP and $PortStartNumberB....

How do i scan open udp port in autoit?

24 Apr 2023 by Member 15987316

May be it help Local $port If $CmdLine[0] == 0 Then MsgBox(0x0,"Err","arg is empty") Exit 1 Else $port = $CmdLine[1] EndIf Func _MyPortExists($port) Local $sRead, $sBuffer, $CMD_PId $CMD_PId = Run(@ComSpec & ' /c netstat -an |...

How do i...create the trail balance with opening balance and closing balance..closing balance will become opening balance on selected date range.from two tables one is account second is transection

4 Apr 2023 by samhasan

Suppose I have two table same as above Accounts ACCTID ACCTNAME ACCT TYPE Opening Balance Date 12 CASH ACCT DEBIT 1200 1-4-2023 13 BANK ACCT DEBIT 1300 1-4-2023 14 SUPPLIER ACCT 1 CREDIT 1400 1-4-2023 15 SUPPLIER ACCT 2 CREDIT 800 1-4-2023...

SQL

server

How do i...create the trail balance with opening balance and closing balance..closing balance will become opening balance on selected date range.from two tables one is account second is transection

4 Apr 2023 by Gerry Schmitz

Debit or credit is a type of balance; not an "account". Account types include: Assets and liabilities; short term (e.g. cash; payables) or longterm (loans). A certain account may tend to have a debit or credit balance, but it can also go the...

SQL

server

convert MS SQL Stored Procedure to mysql Stored procedure

28 Mar 2023 by Member 15964861

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --exec GetUserDetails 'mkumar9699@gmail.com','1234','Yes' CREATE proc [dbo].[GetUserDetails] @Email varchar(100), @Password varchar(max), @IsActive varchar(3) as Declare @UserExist int,...

SQL

server

convert MS SQL Stored Procedure to mysql Stored procedure

28 Mar 2023 by Santhosh23

Hi ALL,I have a MSSQL server database with loads of Tables,Views and Stored procedures. I tried to convert with a tool. But it converted tables only(not sp or view).Let me know a way to migrate whole the db to mysql.Plz help me.thanks,

SQL

server

How can I use internal database

21 Mar 2023 by Max Speed 2022

hi,guys i publish my program in c# VS,i have a database(sql server) that connected to my program,when i publish my program and use that in another pc i must install sql server in another pc and create a data base for running my program,how can i...

SQL

server

How can I use internal database

21 Mar 2023 by Chris Copeland

If you're not particularly interested in having multiple applications connect to your database server at once, and this is just for a standalone application, you might want to consider using a different database such as SQLite[^]. This simply...

SQL

server

I need a help for solving SQL query

14 Mar 2023 by An@mik@

Consider the two tables Table Definitions Table: dbo.Tickets Cinema Month TicketsSold 1 01/31/23 5 1 02/28/23 10 2 01/31/23 15 2 02/28/23 20 3 01/31/23 25 4 01/31/23 30 Table: dbo.Retail Cinema Month RetailSold 1 01/31/23 10 1 02/28/23 15...

SQL

server

I need a help for solving SQL query

14 Mar 2023 by CHill60

You need to left outer join your CTE results to the Retail table something like thisselect a.*, ISNULL(b.TicketsSold,0) as RetailTickets from cte a left outer join retail b on a.Cinema = b.Cinema and (b.[Month] is null or b.[Month] = a.[Month])...

SQL

server

Granting permissions to local user account to issue custom command to windows service from ASP.NET web application

13 Feb 2023 by InTech97

CONTEXT My client has an ASP.NET web application running in IIS 10 on Windows Server 2016. The web application needs to access files on network shares on different servers in a WORKGROUP environment. So, I created the same local user account on...

How can I join join more than two SQL table columns in C#

6 Feb 2023 by OriginalGriff

Try something like this:SELECT a.LEADER AS [A Leader] ,b.LEADER AS [B Leader] ,c.LEADER AS [C Leader] FROM TableA a JOIN TableB b ON a.ID = b.ID JOIN TableC c ON a.ID = c.ID And also read up here: SQL Joins[^]

SQL

DataGridView

server

How can I join join more than two SQL table columns in C#

6 Feb 2023 by Joel Silva 2022

I have a column named LEADER in 16 tables in my sql database I'd like to join all the tables to show the Leader column and the table it belongs to in datagridview. What I have tried: SqlCommand cmd = new SqlCommand("Select...

SQL

DataGridView

server

Get Server Date in Microsoft Access BD

4 Feb 2023 by Christian Torrico

Hi,i wanted to ask if there was some way to get the server date from a Microsoft Access database.I know about Date() and Time() methods, but in SELECT they give me local time. Can you give some help with this?

Get Server Date in Microsoft Access BD

4 Feb 2023 by Member 15914427

If it is a local server you can, try this procedure Private Sub btnServidorLocal_Click() ' Reference Windows Script Host Object Model Dim cmdShell As New WshShell Dim cmdEjecute As WshExec Dim cmdInstruccion, hora, dia, tem As String ...

increment the employee salary 15% if he has 2 years of experience? table name=employee_info columns are emp_id;emp_name;salary;dateofjoin. using SQL or SQL SERVER

19 Jan 2023 by Member 15899199

i. Add a new column named bonus which is 15% of their salary.

SQL

server

increment the employee salary 15% if he has 2 years of experience? table name=employee_info columns are emp_id;emp_name;salary;dateofjoin. using SQL or SQL SERVER

19 Jan 2023 by Abdul Imran

please reply me fast ......i have a requirement as below..increment the employee salary 15% if he has 2 years of experience?table name=employee_infocolumns areemp_id;emp_name;salary;dateofjoin.using SQL or SQL SERVERplease reply me some one fast...i am waiting eagerly.

SQL

server

How to insert multiple textboxes in a table row by row with button click

17 Jan 2023 by hasan25x

Hello, i want to insert values at the same time for each row. Example: Stock ID | MODELID | Quantity HP. İ3. 2 Stock ID |. Model | serialno HP. İ3. 15142526 HP. İ3. ...

SQL

ASP.NET

server

How to insert multiple textboxes in a table row by row with button click

17 Jan 2023 by Mohamed Elanssary

It sounds like you're trying to insert multiple rows of data into two different tables at the same time, and that you've successfully inserted data into the first table but are having difficulty doing so for the second table. One way you could...

SQL

ASP.NET

server

I can’t login to autocount accounting

5 Jan 2023 by azahari100

When i try to login to autocount. It show a notification “ A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: O - No process is on the other...

server

database

I can’t login to autocount accounting

5 Jan 2023 by OriginalGriff

We can't help you with that - you will need to contact autocount tech support and askl them. Only they will (or should) have any access to their login database.

server

database

I am getting double data from my query on a table.

8 Dec 2022 by Ozzie Mozzie

I am getting double data (double columns) from my query on a table. I am unable to fathom why this is happening. Have tried all kinds of methods but no change. The original table only has a single row of data in each row. // Now let's try to...

SQL

dapper

server

I am getting double data from my query on a table.

8 Dec 2022 by Richard Deeming

That's an extremely dangerous stored procedure. If your tableName parameter can be influenced in any way by the end-user, then your code is vulnerable to SQL Injection[^]. At the very least, you need to validate the table name in the stored...

SQL

dapper

server

How do I extract indian rupee sign ₹ from a number or string

8 Dec 2022 by Sridhar Babu 2022

when the expression when (CHARINDEX('₹', @promo_text) > 0 and ISNUMERIC(SUBSTRING(@promo_text, (CHARINDEX('₹', @promo_text)+1),3))=1) then try_cast(try_convert(money,(substring(@promo_text,(charindex('₹', @promo_text)+1),3))) as decimal) need ...

SQL

server

I am getting double data from my query on a table.

7 Dec 2022 by OriginalGriff

We can't tell what exactly is happening: but the most likely problem is that tableName does not contain what you think it does - so start there. Use the debugger to examine exactly what you pass into it, and single step the method to see exactly...

SQL

dapper

server

How do I send data to specific client from another client with a server in middle[C#]

4 Dec 2022 by Member 14623639

I have searched everywhere but couldn't find as they are all answering to send message to all clients. What I want to achieve is multiple clients request to server to request data from another client and other client sends data to server telling...

How do I write script with case

1 Dec 2022 by Member 15850642

I wrote Sql Server query for northwind I want output without null values What I have tried: use Northwind select productid, productname, case when unitsinstock >100 then 'no order' when unitsinstock between 1 and 10 then 'yes order' end AS...

SQL

server

How do I write script with case

1 Dec 2022 by OriginalGriff

Add an ELSE clause: SQL CASE Expression[^]

SQL

server

Send data to client in Python

12 Nov 2022 by gary@36

I have the following server code slightly modified from pymotw website. I am trying to send the data to client bearing port no. 10000 without recieving. But unsucessful. Is there a way to send data based on a triggered event? What I have tried: ...

Python

server

How do I prevent logon scan for my mssql server

6 Nov 2022 by GinCanhViet

I just checked the Event Viewer and saw multiple requests trying to login my mssql server, with multiple random IDs and passwords (sa, mssql, hawai, etc). All from multiple IP addresses How can I prevent that or what can I do to protect my...

SQL

hacking

server

How do I prevent logon scan for my mssql server

6 Nov 2022 by Richard Deeming

Make sure your firewall is configured to block access to the ports used by MS SQL Server - typically TCP 1433, 4022, 135, and 1434, and UDP 1434. If you really need to access it from outside of your network, then look at setting up a VPN, or...

SQL

hacking

server

C++ server client chatting

27 Oct 2022 by Member 11351616

client server messaging same pcs but doesn`t work seperate computers.What I have tried:Client.cpp#include#include#include#include#include#include#include#include#includeusing namespace std;#define IP...

C++

server

How to get max id from shift_details (table) in SQL server in WPF C#

24 Oct 2022 by CHill60

Based on the SQL you have posted it looks as if you are trying to get closing_date and employee_id from shift details for the row containing the maximum sd_id. There are many ways you can achieve this 1. Declare a variable, assign the max sd_id...

SQL

WPF

server

How to get max id from shift_details (table) in SQL server in WPF C#

24 Oct 2022 by prashanth manoj

Select closing_date,employee_id from shift_details group by MAX(sd_id) What I have tried: SELECT MAX(sd_id) AS sd_id FROM shift_details

SQL

WPF

server

Code execution stops abruptly

2 Oct 2022 by nandakishoreroyal

I have scheduled my job in server, which it will be running continuously. After processing some time, process is stopping abruptly with out any error. What could be the reason? Processing data day a by day, after processing each day data , I...

Code execution stops abruptly

2 Oct 2022 by OriginalGriff

There is nowhere near enough information for us to help you in any real way: we have no access to your code or the system it is running on. So you will have to fall back on old fashioned methods, and add logging to your app to try to narrow down...

How to list table from two database.

2 Oct 2022 by Member 13548480

I have two database having identical schema and same table in both database. I want to iterate both database and want to compare each table in both database. My problem: How to iterate both database and where to put if condition to check whether it is same table from both database or not. What...

How do I extract indian rupee sign ₹ from a number or string

11 Sep 2022 by Maciej Los

Check this out: DECLARE @v NVARCHAR(30) = N'₹1234 discount'; select @v AS InitialValue; select CAST( SUBSTRING(@v, CHARINDEX(N'₹', @v) +1, CHARINDEX(' ', @v) - CHARINDEX(N'₹', @v) ) AS DECIMAL(8,0)) AS Rupees; SQL batch[^]

SQL

server

How do I extract indian rupee sign ₹ from a number or string

11 Sep 2022 by OriginalGriff

Basically, change your database. Don't store numeric values as strings at all: store them as INT, FLOAT, or DECIMAL - and the latter is the most appropriate for currency values. And remove the currency symbol in your presentation code when you...

SQL

server

How do I show mapping between two tables in SQL server

31 Aug 2022 by Riya Yadav 2022

I want to know how mapping is done between two tables .Can I use "full join" for that?? What I have tried: I TRIED USING FULL JOIN THERE BUT IT DOESN'T SHOW MAPPING BETWEEN TWO TABLES IN SQL

SQL

server

How do I show mapping between two tables in SQL server

31 Aug 2022 by CHill60

This CP article might help Visual Representation of SQL Joins[^] Alternatively, if you are trying to determine how the database is designed and which columns are foreign keys you can use this tool - SQL Server Database Diagram Tool in...

SQL

server

How do I show mapping between two tables in SQL server

31 Aug 2022 by Dave Kreskowiak

What do you mean by "SHOW MAPPING"? JOINs combine multiple tables to execute a query using related data. In order for a JOIN to work, the tables have to have some column(s) in common, or "related". If want some help with this, you're going to...

SQL

server

Hello. I need a computed field im my view to subtract a.[vendas ultimo ano]-2.stkactual and b.[vendas ultimo semestre] -artigo_2.stkactual thanks in advance for any help,

20 Jul 2022 by miguel santos 2021

SELECT a.artigo, a.descricao, Artigo_2.unidadebase, b.[vendas ultimo semestre], a.[vendas ultimo ano], Artigo_2.stkactual FROM (SELECT DISTINCT dbo.linhasdoc.artigo, ...

SQL

server

Hello. I need a computed field im my view to subtract a.[vendas ultimo ano]-2.stkactual and b.[vendas ultimo semestre] -artigo_2.stkactual thanks in advance for any help,

20 Jul 2022 by Richard MacCutchan

There is no reason why you cannot have a calculated field in a view, as far as I know. Take a look at SQL CREATE VIEW, REPLACE VIEW, DROP VIEW Statements[^]. But the main thing you need to do is to build the view from the ground up, rather than...

SQL

server

Column name using variable in where clause

8 Jul 2022 by Member 15701181

Is there a way to bring variable values in where clause? See link below in fiddles example. I want the code1 to be unique. What I have tried: Schema: CREATE TABLE test ( id INT, code1 varchar(5), cityname varchar(24), clue varchar(255)...

SQL

server

Column name using variable in where clause

8 Jul 2022 by Dave Kreskowiak

No, you cannot put the column name as a parameter. You can, however, build the SQL query statement dynamically and EXECute that instead.

SQL

server

Search results in SQL server using loop in where clause

3 Jul 2022 by Hamza M. S. Abazeed

Good afternoon, I'm trying to complete a small project using SQL Server, but I'm having some troubles ;/ I'm trying to Serch in SQL Server table, where I have a statement (one word or many words) I have a table two tables: - Products (P_ID...

Search results in SQL server using loop in where clause

3 Jul 2022 by Dave Kreskowiak

You cannot use a LOOP expression in a WHERE clause. The WHERE clause expects to see only conditional expressions. You can build the SQL statement in a variable, use the LOOP clause to build up a WHERE clause with multiple OR expressions, then...

How so I sum and filter two SQL tables on delphi 7 using ado query

30 Jun 2022 by joao pedro Jun2022

I have two sql tables wich are : Torcamentos_new Fields : cod_orcamento int uniqueidentifier Some more fields date etc Torcamento_aux Fields : cod_orc int Quantidade int Preco_unit ...

SQL

server

How so I sum and filter two SQL tables on delphi 7 using ado query

30 Jun 2022 by Wendelius

If I understand the question correctly you can for example use windowing aggregations, common table expression, and LEAD together to achieve the result. For example the following query select cod_orc, quantidade, ...

SQL

server

IIS 8.5 Access Denied when stopping App Pools

2 Jun 2022 by pmcm

I have an application that deploys code to various target servers. Recently Windows 2012 servers have been added as target servers but the application's agent service (which is installed as a service on each target) returns an 'Access denied' message when trying to perform any tasks linked to...

Server Error in '/' Application. Object reference not set to an instance of an object.

29 May 2022 by praveen_07

My application is not able to pick connection string from web.config file.Quote:Server Error in '/' Application.Object reference not set to an instance of an object.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack...

System.net.sockets.socketexception: 'no connection could be made because the target machine actively refused it 127.0.0.1:49778'

21 May 2022 by NoName900

I'm trying to connect a server using socket, and i got this exeption: System.Net.Sockets.SocketException: 'No connection could be made because the target machine actively refused it 127.0.0.1:49778' this is the code: private static bool...

server

System.net.sockets.socketexception: 'no connection could be made because the target machine actively refused it 127.0.0.1:49778'

21 May 2022 by Greg Utas

127.0.0.1 is your own machine, so the reason is almost certainly that (a) you haven't started a server which has invoked listen (TCP) or recvfrom (UDP) on port 49778, or (b) more likely, your firewall rejected the connection for security reasons,...

server

Sql server oledb irowsetfastload .NET

19 May 2022 by PIEBALDconsult

The stupid widget keeps messing with the capitalization! SQL Server OleDb IRowsetFastLoad .net I am working on developing a simple ETL tool. Performance isn't really very important overall, but at the moment I'm testing it with a large CSV file...

How to generate IDS like 0001,0002----0010

28 Mar 2022 by Surendra0x2

Hw to generate id like 0001,0002....0010How to generate a column records like 0001, 0002, 0003...........,0010For ex:--------id--------00010002||||0010Somebody can know this, pls help me...

SQL

server

How to generate IDS like 0001,0002----0010

28 Mar 2022 by Member 15488009

This worked in ms sql but How to use this into oracle

SQL

server

Sql injection attacks possible using resource(.resx) file

19 Mar 2022 by shanmugarajaa

Hi Friends, In my project, I have maintained all SQL query in resource (.resx) file. my doubt is: - Sql injection attacks possible using resource(.resx) file. - If sql injection is possible then how and where to maintain all sql queries. Please let me know best solution for the above...

SQL

server

Software Techniques for Lemmings

17 Mar 2022 by Greg Utas

Are we about to go over a cliff?

design-patterns

server

Robust C++: Operational Aspects

15 Mar 2022 by Greg Utas

The well-tempered server

How to receive HL7(MLLP) message on a TCP/IP server C# ?

9 Mar 2022 by Member 15560521

I want to receive data sent by an Instrument(Cell Counter) which acts as a Client and Sends Data in HL7(Uses MLLP Protocol) Format to a LIS Server Which i am Developing in c#. However My server works fine when receiving normal Text messages. I've...

TCP/IP

server

How to receive HL7(MLLP) message on a TCP/IP server C# ?

9 Mar 2022 by _Asif_

MLLP is Minimal Lower Layer Protocol used in transmitting Health Level Seven (HL7) messages via TCP/IP. And your code does not follow that protocol. If you have had googled, you would have found tons of articles elaborating what MLLP is and how...

TCP/IP

server

Full text search SQL server with parameter

27 Feb 2022 by Lazard Ali

I have a problem using the sql server full text with parameter Alter Procedure[dbo].[SelectFullName] @fullname nvarchar(16) As Select*from [dbo][NamePersonTB] Where CONTAINS (fullname,'"*@fullname*"') What I have tried: CONTAINS...

Full text search SQL server with parameter

27 Feb 2022 by Richard Deeming

You are searching for records which contain the string "@fullname". If you want to search for records which contain the value of the @fullname parameter, you need to concatenate it into the search term: CREATE OR ALTER PROCEDURE...

Error "cb.apply is not a function" on centos 7

24 Feb 2022 by raman18

I am trying host a ReactJS application on a virtualhost on CentOS 7 server. After cloning the project on the server, I tried to build the project. But after running "sudo npm install", i got following error: npm ERR! Linux 3.10.0 npm ERR!...

Error "cb.apply is not a function" on centos 7

24 Feb 2022 by Andre Oosthuizen

Extraxt from here (covering other platforms like MS, Ubuntu etc) and in your case Linux - Possible Solution For linux users: uninstall NPM, to do it go to /usr/local/lib/node_modules and do: sudo rm -r n npm npx Once uninstalled, re-instal...

'STRING_AGG' is not a recognized built-in function name.

20 Feb 2022 by him_mca

hi team, while executing below query getting the Quote: 'STRING_AGG' is not a recognized built-in function name. AS my server has SQL server version 2016 and my dev mechine having SQL server 2017 Quote: SELECT distinct...

SQL

server

'STRING_AGG' is not a recognized built-in function name.

20 Feb 2022 by Graeme_Grant

A quick google search sql server string_agg 2016 found this solution: STRING_AGG replacement in SQL Server 2016 [duplicate]

SQL

server

C# TCP/IP client is connected to internet or not

18 Feb 2022 by payam purchi

can i get client is offline or online in new thread in server side ? it's mean when a client connected to my server i want check in new thread that The client is still online or not . What I have tried: NetworkStream client.getstram...

TCP/IP

client-server

server

Sql server 2014: 1 row update is very slow

17 Feb 2022 by Herman<T>.Instance

In a SQL Server 2014 database we do a 1 row update by setting 1 bit field to 1 where Id = . This means a seek over the PK. It takes over 50 seconds for that update. Inserts fly in the database, selects perform fast, only updates are...

SQL

performance

server

Sql server 2014: 1 row update is very slow

17 Feb 2022 by OriginalGriff

Answered only to remove from unanswered queue: solved in comments.

SQL

performance

server

Restore an SQL backup database with different name

16 Feb 2022 by Member 3892343

I have backed up an sql database with vb net 2015 and smo. I want to be able to restore the database with different name. An article I found here is in c# which I am novice. What I have tried: I found c# example and had destination name that...

SQL

.NET

server

Restore an SQL backup database with different name

16 Feb 2022 by Member 3892343

from sql server I restore the database with different name from managment studio

SQL

.NET

server

Restore an SQL backup database with different name

12 Feb 2022 by Wendelius

Have a look at the documentation, it contains quite good example for both backing up and restoring Backing Up and Restoring Databases and Transaction Logs - SQL Server | Microsoft Docs[^]

SQL

.NET

server

Restore an SQL backup database with different name

12 Feb 2022 by OriginalGriff

So use an online converter to translate: Code Converter C# to VB and VB to C# – Telerik[^] It won't do whole projects, but it should do enough that any competent VB coder should be able to work it out in combination with the MS documentation.

SQL

.NET

server

Ms SQL server timeout or code transactionscope timeout ?

9 Feb 2022 by antobaro

Dear all, this is my scenario: 1. on my Ms.Sql Server the timeout is set for 10 minutes (see the link) https://manage.accuwebhosting.com/kb-images/increase-mssql-remote-query-timeout/connections.png[^] 2. in my code I have this transaction...

SQL

Microsoft

server

How to get last 30 days data from today's date in SQL server

3 Feb 2022 by ADI@345

i have to get record of all rows from last 30 to todays. i have tried this but isn't working What I have tried: select date_time from dsr_data where date_time >= CONVERT(Varchar(100), DATEADD(DAY,-30,GETDATE()),103) and date_time

SQL

server

Incorrect syntax near ', '.

25 Jan 2022 by Faizymca

Yes Sir, you are right, but I am new to VS 2010, so do not know about configure in Report data. My Report Data display adds dataset... I did change the name of DataSet in this dsPRReport but can't change... how can I see this type? ...

SQL

ASP.NET

server

Incorrect syntax near ', '.

25 Jan 2022 by Faizymca

CS0121: The call is ambiguous between the following methods or properties: 'Microsoft.Reporting.WebForms.ReportDataSource.ReportDataSource(string, System.Data.DataTable)' and 'Microsoft.Reporting.WebForms.ReportDataSource.ReportDataSource(string,...

SQL

ASP.NET

server