Server

Steps to install Microsoft SQL Server 2008 Express Edition (Standard or with Advanced Services)

9 Aug 2011 by Jesus Carroll

This brief article show how to install quickly Microsoft SQL Server 2008 Express Edition Standard or with Advanced Services

SSRS Multi-Data Source DPE (Data Processing Extension)

23 Oct 2011 by jkrebsbach

A way to combine data from two different sources into one datasource for SSRS reporting

How to find a specific string from stored procedures, triggers and functions in database

4 Feb 2012 by RasikaLB

You can find queries to find a specific string from MSSQL Server

database

Create a local server in C#

28 Oct 2012 by Thomas Daniels

A tip about how to create a local server in C#.

how to find all tables in given database

13 Aug 2014 by Gupta Poonam

select * from INFORMATION_SCHEMA.TABLES

How to extract overlapped polygons and calculate the overlapped area and write an API for it?

21 Oct 2017 by mahmood kabi

extract overlapped polygons and calculate the overlapped area and write an API for it

Creating a Redis Client using the .NET System.IO.Pipelines and Kestrel Sockets Libraries

29 Apr 2021 by Matthew Dennis

A Redis Client written from the ground up using System.IO.Pipelines, Span, etc

error in stored procedure

27 Nov 2011 by RaisKazi

Not only your Stored Procedure has a syntax Errors but it also has a logical mistake. You are inserting a record and then checking if that record is present or not. [Edited - For spelling correction.]Change your Stored Procedure as below.set ANSI_NULLS ONset QUOTED_IDENTIFIER...

Smps Wire Cut Lan cable Cut, MotherBoard crash ,Database server

26 May 2012 by Richard MacCutchan

1. Don't do it when the server is running.2. Don't cut the wire.3. Same as 2.4. Get a more resilient system and disk array.These are all environmental problems and you cannot program round them other than taking some action in your clients if they cannot connect to the server. Some...

My experience with ASPOSE

22 Oct 2014 by D. Forbes

Switching from native Word to Aspose's .Words component stabilized our server, and improved the speed of our product.

MS-Word

third-party

how to calculate 100/30 ans is 10/3

10 Nov 2014 by _Maxxx_

What you need is a fractions classFortunately someone wrote one[^]

Upload Files Or Images To Server Using Node JS

10 Dec 2016 by Sibeesh Passion

In this post we will see how we can upload files or images to server using Node JS. Here we are going to use Visual Studio for our development and preceding NPM packages for our easy development. express multer body-parser We will briefly explain the use of these packages.

Concatenate a string and decimal in a Linq query

15 Jul 2016 by larry118

I am writing an application in VS2010, Framework 4.0, C# and silverlight 4.I have a simple class and Linq Query.The class is:public class pmDues { [Key] public int DuesID { get; set; } [DataMember] public string dues_type { get; set; } ...

Video Tip:- Improve SQL Server performance by using SQL server profiler

16 Oct 2011 by Shivprasad koirala

If you want to quickly get index suggestions and improve performance in SQL Server, then Profiler and tuning wizard is the first place to start.

Convert Date function in dd-mm only

17 Apr 2012 by Abhinav S

You can do this both in SQL Server or in the ASP.Net C# code.In C# ->String format = "dd-MM";String dateStr = date.ToString(format);In SQL Server ->SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) AS [DD MM]

How to insert the identity

8 Jun 2012 by abhinavvijay

you can use below statement if you have only three record in your tableDBCC CHECKIDENT (tableName, reseed, 4)

how 1 6 2012 can be converted into 1june2012

19 Jun 2012 by Manas Bhardwaj

Look at this solution in SQL:DECLARE @date NVARCHAR(10) = '1 6 2012'SET @date = REPLACE(@date, ' ', '.')SELECT CONVERT(VARCHAR, CONVERT(DATETIME, @date, 104), 6)Here are the diff. formats supported by SQL...

Client -Server C# Project

21 Jul 2012 by Espen Harlinn

Have a look at Windows Communication Foundation[^] and WCF Data services[^]You may find this article helpful: Advanced using OData in .NET: WCF Data Services[^]Best regardsEspen Harlinn

How to update a row with another row if column values are null in SQL

17 Aug 2012 by ManojKumar19

Update row column with another row column in same table SQL only if it is null.

How do i solve a question asking for 'Most' ?

4 Oct 2012 by Dylan Morley

With aboslutely no idea what your database structure looks like, I'll have to guess....but a GROUP and COUNT will work.SELECT Year(EmployeeStartDate) AS YearHired, COUNT(EmployeeId) AS EmployeeHiredCountFROM EmployeeDetailsGROUP BY Year(EmployeeStartDate)ORDER BY ...

inserting xml to sql server

2 Dec 2012 by __TR__

Try this. It is a slight modification to the query posted by AmitGajjarSELECT x.y.value( 'Name[1]', 'NVARCHAR(20)' ) AS Name, x.y.value( 'Color[1]', 'NVARCHAR(20)' ) AS Color, REPLACE(REPLACE(CAST (x.y.query( 'Detail[1]') AS NVARCHAR(50)), '',''),'','') FROM...

XML

SQL Query passing null and value in where clause

5 Mar 2013 by ZurdoDev

Select * from Testwhere Type = @type and (Institute = @Inst OR @Intst IS NULL)

update query with in while loop

17 Dec 2013 by OriginalGriff

You want a JOIN:UPDATE A SET A.intro_advisor_id=U.advisor_idFROM tbl_advisor_dummy AJOIN tbl_advisor_dummy UON U.advisor_name = A.introducer_name

diff bet. select * and select column name in sql query

4 Sep 2014 by Wendelius

This sounds a bit like a homework....Anyhow, there are quite a few differences. To name some from the top of my head:the amount of columns is differentthe order of the same columns returned may be differentthe second one may fail because of wrongly typed column namethe second one may...

Table added to every database I create

6 Jan 2015 by Zoltán Zörgő

You have created that table in the model database. That one is replicated on every database creation. Please noted, that in SQL Server not the database, but the instance is the top level logical and functional object.[Update]Not master, model.

Web development #4: PHP in the back

16 Mar 2015 by Sander Rossel

The (long awaited) fourth in a series on web development.

MEAN web development #2: Node.js in the back

27 May 2015 by Sander Rossel

The second in a series on MEAN web development.

Lotus Notes to Team Foundation Server

3 Aug 2015 by ambilykk

Emails to Work Items

why we use multiple single quotes in dynamic sql query

23 Oct 2015 by OriginalGriff

Simple: single quote is the string start-and-end indicator, so if you want to include a single quote in the string, you have to use two of them together.So if you are trying to generate a string that contains a single quote it's simple:'AB''CD'But you are trying to generate a string that...

Create Azure Database and use it via C#

1 Mar 2016 by Emiliano Musso

In this short article we will see how to create a SQL database using the services provided by Microsoft Azure cloud platform, and then connect to it via C # code, to perform the normal data insertion and retrieval operations

XML Server Suite

23 Mar 2016 by DonSn

The XmlServer is a multi-threaded server application that listens for client requests, invokes "Operators", and responds to client requests.

.NET

Dev

More elegant way of doing this

26 Apr 2017 by Kornfeld Eliyahu Peter

I would say a dynamic SQL can help you here... DECLARE @PERIOD INT = 1 DECLARE @SQL AS NVARCHAR(MAX) DECLARE @RETVAL VARCHAR(16) SET @SQL = 'SELECT @RV = PERIOD_DESCR_' + CAST(@PERIOD AS NVARCHAR) + ' FROM SYSPAR_NML11' EXECUTE sp_executesql @SQL, N'@RV VARCHAR(16) OUT', @RV = @RETVAL OUT ...

More elegant way of doing this

29 Apr 2017 by CHill60

An alternative to Solution 1 but one you may not be able to implement. I have also been in a position where I inherited a "standing" data table where columns had been used like this. I was luckily in a position to change the table as it was only used in one place. If you are also that lucky,...

How to Install Let's Encrypt and Automate Renewal in Nginx

23 Jan 2018 by James Johnes

Do you want to secure your nginx server? Do you want to prevent Google Chrome from name shaming your non-SSL domain? Well, here a perfect yet easy to follow guide to help you.

NVARCHAR to datetime

18 Mar 2019 by OriginalGriff

Simple: change your database design. Never store dates (or anything other than "pure" string data like names and addresses) in NVARCHAR or VARCHAR columns always store data in appropriate datatypes. For integer values, that is INT, for floating point it's FLOAT or DECIMAL. For dates, that is...

Robust C++: Operational Aspects

15 Mar 2022 by Greg Utas

The well-tempered server

Blazor WebAssembly vs Angular: Client Side Clash

9 Aug 2020 by Lee P Richardson

Which SPA technology should you use: Blazor WebAssembly or something more mature like Angular, and why?

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])...

Which Type of Images .gif, .jpeg, .bmp, .png are best for asp.net site

18 Mar 2010 by AspDotNetDev

Really depends on what you use them for. For example, JPEG is good for storing lossy photographs of real life objects (e.g., trees and scenery and cars and so on). PNG is the best option for losslessy compressing computer-generated images (e.g., screenshots). GIF is good for animations and for...

Windows

Hide the body of stored procedure

20 Mar 2010 by Rod Kemp

If you don't want anyone to be able to look at the stored procedure then encrypt it;CREATE PROCEDURE AllCsDetails_Bilal@FrmDate DATETIME,@ToDate DATETIME,@CsID VARCHAR(50),@ExporterID VARCHAR(50)WITH ENCRYPTIONASMSDN CREATE PROCEDURE[^]

Best language for client - server

18 Aug 2010 by Niklas L

I think you should focus on the design/technique used instead. Then the choice of language will follow; which language/IDE supplies a sufficient framework, how are you planning on debugging your application, what are you comfortable with, etc. I would not recommend writing your own protocol for...

Delphi

C++

Getting my client server application to work over the internet?

23 Nov 2010 by Rod Kemp

There is nothing you can do to your code to do this it is all about network routing.The server binds to the local IP address of the computer it is running on, you then need to put port forwarding rules into any modem/routers/firewalls between that computer and the internet (public IP or ISP...

How call a SQL Server stored procedure with parameter(s)?

16 Jan 2011 by Manfred Rudolf Bihy

Yes you can and you should pass parameters via SqlParameter. You can look at a C# tutorial/example here: http://www.java2s.com/Tutorial/CSharp/0560__ADO.Net/CallstoredprocedurewithparametersusingSqlCommand.htm[^].Hope that helps!Best Regards,Manfred

Server Program behind a router

9 Apr 2011 by krishkr

There are a lot of things I'm trying to understand here. I don't want to read through entire book volumes or articles, just the possible solution to the condition mentioned below. Also, I couldn't find the answer in the forums I have seen. Please direct to me a concise answer if available. The...

TCP/IP

Operating System details

11 May 2011 by OriginalGriff

Give the reasons why I should do your homework for you.

Linux

Windows

Select nth row of a table in sql server

2 Jul 2011 by OriginalGriff

Try: WITH myTableWithRows AS ( SELECT (ROW_NUMBER() OVER (ORDER BY myTable.SomeField)) as row,* FROM myTable) SELECT * FROM myTableWithRows WHERE row = 3

Server - Client Application?

2 Sep 2011 by Abhinav S

StepsStep 1) You need to host the database in central server / location and allow client programs to access it.Step 2) You will need to make sure all clients have network access to this location.Step 3) To do this, you will need to setup a database connection, say an ODBC setup, on every...

Server Configuration details?

12 Sep 2011 by Toniyo Jackson

Hi friends,We are planning to establish new server for two application. One application will have 10K users. There is a possibility of 10K users can access the application at the same time. And another will have 500 users. We need fast accessing. So, can you please tell me the server...

need distinct record based on a column

19 Oct 2011 by Simon Bang Terkildsen

Doesn't make much sense to me. Why is 1001 mobile the expected output and not 1001 table. What I try to say is the second column is useless in the output you desire, as no-one know if the customer has 0 or more other products only that, that the customer has that particular product.that said...

Web server and browser bi-directional communication thru tcp socket

28 Oct 2011 by Sergey Alexandrovich Kryukov

Yes, I guess you have to search for a specific key word. The question is not quite clear, but I guess the key words should be "Push technology" and "Server push".You will find pretty good overview of the topic and available technologies here:...

Sorting column that contains string with numeric value

18 Nov 2011 by Md. Marufuzzaman

Sorting column that contains string with numeric value

how to read excel and store the data in database

18 Dec 2011 by Amir Mahfoozi

For importing data from an excel fine the OPENROWSET command will help you :http://support.microsoft.com/kb/321686[^]http://jasonhaley.com/blog/post/2004/03/06/OPENROWSET-T-SQL-function.aspx[^]www.sqlservercentral.com/Forums/Topic496226-148-1.aspx[^]Of course datagrids don't have...

Download SQL Server Sample Databases including SQL Server 2012

7 Jan 2012 by Dhananjay Kumar Upadhyay

Download SQL Server Sample Databases including SQL Server 2012

how to do automatic email sending in asp.net using c# with steps

12 Feb 2012 by Mycroft Holmes

Ah it is the automated issue that is the problem.I would use a SQL server job that runs periodically to check for expired data events and generate the email and send it via SQL mail and SMTP.Either that or use a timer in your c# app to do the same thing.You could also write a service...

Columnstore Index

23 Feb 2012 by Santosh P Umarani

Columnstore Index

Check For Updates - RemoteVersionChecker

22 Mar 2012 by Fabrizio Stellato

This code provides your application a - check for updates - feature

.NET

application

How to Create an new database like existing database

18 Apr 2012 by Deepak_Sharma_

Hi,Here is your solution :http://weblogs.asp.net/mschwarz/archive/2004/08/26/220735.aspx[^]

Querying in between to dates

21 May 2012 by Prasad_Kulkarni

Try this:SELECT * FROM tbl_Trans_LeaveRequestApproval WHERE FromDate >= '21-05-2012' AND ToDate

How can create a random function which will randomly pic a row from table

17 Jun 2012 by OriginalGriff

To select a random record, combine TOP with NEWID:SELECT TOP 1 * from MyTable ORDER BY NEWID()In your case, you will probably need to replace MyTable with your procedure output.

Read a Xml file using Javascript.

18 Jun 2012 by Prasad_Kulkarni

Please refer:XML and JavaScript[^]Parsing XML Documents in JavaScript [^]

XML

Javascript

sql count function to get the result

26 Jun 2012 by Prasad_Kulkarni

Try this:SELECT DISTINCT grade, COUNT(grade) from stduent GROUP BY grade.Understand how count works, this is really very simple as Abhinav answered. Refer:http://msdn.microsoft.com/en-us/library/ms175997.aspx[^]

storing password value int sql server with secure way

24 Jul 2012 by Sergey Alexandrovich Kryukov

No, you never need to store a password. There is no a "secure way". Storing a password anywhere is never needed for authentication purposes. Think about it: does anyone (except the user who owns the password) needs to know the password, ever? All authentication needs is to make sure, that the...

How to copy files from network shared path

15 Aug 2012 by Sergey Alexandrovich Kryukov

Please see my comment to the question, where I explain why it is not valid. If your files are already served up by some HTTP server, you need to access to the file using some client side. Generally, you can only download files. Uploading is only possible if the server supports it; usually it...

file

Access to the path '~\Upload\NewsImage' is denied.

5 Sep 2012 by Andrei Straut

The solution comes from your own error message:To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired...

ASP.NET4

IIS

sql server Print function

4 Oct 2012 by Teenustar

If you are trying to return a variable from your Stored Procedure, then you must declare an output variable. A sample Procedure is shown below. You can then get the variable in your aspx page accordingly. Dont forget to handle null.CREATE PROCEDURE [dbo].[sample] @input varchar, ...

Delete duplicate records keeping one record

18 Nov 2012 by __TR__

Here is a sample approachCREATE TABLE #SampleTable( ID INT, [Name] VARCHAR(100))INSERT INTO #SampleTable SELECT 1, 'Yahoo' UNION ALLSELECT 1, 'Yahoo' UNION ALLSELECT 2, 'Google' UNION ALLSELECT 2, 'Google' UNION ALLSELECT 2, 'Google'--Before Deleting the duplicate...

What is the problem in my query

14 Feb 2013 by CPallini

Quote:case @in_supplier_type_id when 2 THEN @bt_activeYou missed the ending END ( :-) ) here.

SQL Query passing null and value in where clause

5 Mar 2013 by D.Nikolov

select * from Testwhere Type = @type and (coalesce(@inst, 1) = 1 or Institute = @inst)coalesce returns first of its argument which is not null, so when @inst is null your condition will be like Type = @type and (1=1 or Institute = null). The case when @inst has value will be Type...

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnRegistrationNoExp", or the name is ambiguous.

19 May 2013 by CHill60

The problem is happening because you are trying to call dbo.fnRegistrationNoExp but your function has been defined as [dbo].[fnRegitrationNoExp] ... you have misspelled the function name when creating it (missing 's')

sum of the count(*) values in sql

8 Aug 2013 by Maciej Los

I'm not sure what you want to achieve, but have a look at below example:SELECT F1, COUNT(F1) AS CountOfF1, SUM(F2) SumOfF2FROM ( SELECT 1 AS F1, 2 AS F2 UNION ALL SELECT 1, 5 UNION ALL SELECT 1, 3 UNION ALL SELECT 1, 4 UNION ALL SELECT 2, 12 UNION ALL SELECT 2, 5 UNION ALL...

Caching in ASP.net

11 Oct 2013 by ASP.NET Community

CachingAuthor: Prakash Singh MehraIntroduction: It is a way to store the frequently used data into the server memory which can be retrieved very

Arbitrary parameters in SSIS for OLE DB

1 Jul 2014 by Ryszard Dżegan

How to get around restrictions for parameters in OLE DB connection type while working with SSIS and BIDS.

How to count instances of character in SQL Column

7 May 2014 by Maciej Los

Try this:DECLARE @MyString VARCHAR(30) = 'SPX,DOX,SPX,SPX,DOX';WITH CTE AS ( SELECT LEFT(@MyString, CHARINDEX(',', @MyString)-1) AS Word, RIGHT(@MyString, LEN(@MyString)-CHARINDEX(',', @MyString)) AS Remainder WHERE CHARINDEX(',', @MyString)>0 UNION ALL ...

Microsoft Project Server 2013: how to programmatically change resource assignment for specific time period

20 Jun 2014 by Pavel Sinkevich

Combine several API for MS Project Server to achieve complicated goals

interop

What is the use of With(NoLock ) in sql server

6 Aug 2014 by Dilan Shaminda

Google and found this nice explanation about NOLOCK table hintUnderstanding the SQL Server NOLOCK hintUnder NOLOCK explanation in MSDN it saysFor UPDATE or DELETE statements: This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new...

diff bet. select * and select column name in sql query

4 Sep 2014 by Gihan Liyanage

Say google first.. When you have an issue or doubt Your solution is here.Select * Vs Select Column Name[^]

How to find the max salary of employee of each department ?

7 Nov 2014 by DamithSL

read :SQL GROUP BY Statement[^]SQL MAX() Function[^]SQL INNER JOIN [^]sample sql query (I assume you have salary in emp table) SELECT MAX(E.SALARY), D.DEPNAME FROM EMP EJOIN DEPT D ON E.EMPID = D.EMPIDGROUP BY D.DEPNAME

insert list record in multi tabel safely like ( using trans and rollback) using linq lambda expreestion

21 Nov 2014 by BillWoodruff

I believe what you really want is a comprehensive understanding of Linq To SQL, and there is one outstanding resource I'd like to direct you to: a series of articles written by Scott Guthrie on his blog. At Microsoft, Scott is formerly the .NET product manager, and is now executive vice...

LINQ

How to encrypt data in .net apps and decrypt it in sql server using AES

5 Dec 2014 by Zoltán Zörgő

Just one quesrtion: why on Earth? What's this good for? Why doing two roundrips for nothing? There is absolutely no use enctrypting values with symmetric encryption in a web application. Use https and encrypt the traffic, or forget it. Why? Because you neet to send the key also. And at that...

C#5.0

Multiple insert statement in Stored Procedure

23 Jun 2015 by F-ES Sitecore

Yes it will because the INSERT statements take immediate effect. If this isn't what you want then you need to put your commands in a TRANSACTION so that you can commit or cancel them (rollback) as a single unit.EDIT AL: here is a good article on SQL Server Transactions and Error Handling[^]

How to find average in SQL Server?

12 Oct 2015 by Tomas Takac

If you have SQL server 2012 or higher you can use windowing functions:select [date], [customers], AVG([customers]) OVER(ORDER BY [date]) as [average] from t

ExecuteNonQuery: Connection property has not been initialized.

17 Dec 2015 by OriginalGriff

Three things:1) Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.2) It's a damn good idea to store connections strings in a configuration file,...

How to change the long date format into short date format in SQL stored procedures

14 Sep 2016 by Maciej Los

Date is date and nothing else! Due to the type of field[^] and several settings[^] date format may differ.To display date using custom format, please check this:Date and Time Formats[^]CAST and CONVERT (Transact-SQL)[^]FORMAT (Transact-SQL)[^]

I want to insert null value in database if that variable is blank, but in command string it insert blank instead of null. So give error.

20 Sep 2016 by Karthik_Mahalingam

Dont concatenate the sql statements, it will lead to sql injection[^] attacksalways use Parameterized queries to prevent SQL Injection Attacks in SQL Server[^]by doing so, it will be simplify your sql statement and dont need to bother on the datatype formatstry like this cmd = new...

Sql server 2008R2 SSIS weirdness when creating folder

23 Sep 2018 by CHill60

Summary of the comments which led to a solution: I first suggested checking the Precedence Constraints. My bad as the question clearly states SQL2008R2 and these didn't come along until later (2014?). However I also suggested using Sequence Containers.. which seemed to do the trick. I'll try...

SSIS

Learn about ASP.NET HtmlGenericControl

13 Dec 2020 by Jin Vincent Necesario

HtmlGenericControl of ASP.NET Webforms

Incorrect syntax near 'as' incorrect syntax near ')'

12 Jan 2022 by Luc Pattyn

Your SQL statement is incomplete, you still have to do something with those hotels. Example: with hotels as ( select * FROM dbo.hotel_2018 union select * FROM dbo.hotel_2019 union select * FROM dbo.hotel_2020 ) select * FROM hotels doesn't give...

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

post latest updates of my company on my web page

4 Mar 2010 by Sandeep Mewara

I don't find it a problem. It's a project as you said in the first line. Get all the details what you need to show, design screens to enter data, view data, update or delete data. Decide where to store those data. Plan on best architecture to handle various operations. Start on these to go...

SQL Server Functions And Store Procedures

7 Apr 2010 by Not Active

Its a bit of an apples to oranges comparison.Writing to a table could have performance drawback because of IO issues or table locks, or a number of other reasons.The function would almost certainly be more performant because it is all in memory. However, it also depends on how the...

SQL Server Functions And Store Procedures

7 Apr 2010 by Abhinav S

A link here.

Send UDP packet in C#

15 Apr 2010 by DaveAuld

Use the UDPClient class, here is the example straight from MSDN;// This constructor arbitrarily assigns the local port number.UdpClient udpClient = new UdpClient(11000); try{ udpClient.Connect("www.contoso.com", 11000); // Sends a message to the host to which you...

UDP

sockets

SQL Server

3 Jun 2010 by Andrew Rissing

Google[^]

Starting an SQL Project and need some help

28 Dec 2010 by Aman4.net

Dear cyberm0t0,I would like to tell that while you are using database in your project you need to write ConnectionString in your code to establish connection. No other settings are required.Best place to write ConnectionString is Web.config (in Web Project) and App.config (in window...

how to save data from Data set into Database

3 Jan 2011 by Hiren solanki

See the various version of DataAdapter update methods HERE[^].