You can send the xml directly to stored procedure and let the stored procedure deserialize it into the appropriate table(s).Regarding using xml in sql, google is your friend.

SQL

server

get data from current month and previous month

1 May 2010 by #realJSOP

You could pass the two dates in question as parameters to a stored procedure, and then write an unencumbered stored proc.

SQL

server

Execute permission denied for stored procedure

5 May 2010 by #realJSOP

Did you grant permission for the account on the other database? You have to do it for each database you want to run the stored proc on...

SQL

server

popup messages in c#

24 May 2010 by #realJSOP

Send an email. I personally hate popup messages because you usually have to dismiss them before doing anything else.

Create WCF for QT framework client on Linux.

15 Jul 2010 by #realJSOP

It's really not that hard to use google ("wcf web service linux client"). Here's one of the 210,000 hits returned:http://coab.wordpress.com/2009/10/15/calling-wcf-services-from-a-linux-c-client-using-gsoap/[^]

what is Difference betwwen sql server 2005 and sql server 2008

26 Aug 2010 by #realJSOP

You can get a much more complete answer by using google to find the answer. If you google this phrase:"difference between sql server 2005 and sql server 2008"The first two results returned will probably give you all the answers you require.

SQL

server

How to connect RADIUS ?

24 Dec 2010 by #realJSOP

You can use SSH to communicate witha RADIUS server. Here's a SSH lib.SharpSSH

Windows

server

Windows Server

25 Dec 2010 by #realJSOP

Yes, and it would probably have to be in the form of a Windows service. However, what kind of attacks are you talking about? How are you going to detect the attacks, and what kind of attacks are you looking for? If I were you, I'd look for some software that's already written and tested. ...

Windows

server

ASP.NET Passing Data To VB.NET Client

13 Jan 2011 by #realJSOP

The client app can get it via either a HttpWebrequest, or an XMLHttpRequest. The data would come back as xml, and could then be parsed by the client. On the other hand, you could write a webservice that could handle both the web app AND the client app.Google is your friend.

ASP.NET

server

database

Task scheduler and IIS6 (windows server 2003

5 Apr 2011 by #realJSOP

I looked at that article, and someone else posted this:You must write a flag after the setaccountinformation :_Task.Flags = TaskFlags.RunOnlyIfLoggedOn;

Creat winforms and count number of pressed buttons in sql server

19 Jun 2011 by #realJSOP

We don't do poeple's homework for hem. It's not because we feel elite, but because you won't learn anything if we do your homework for you.

SQL

server

sql server stored procedure

8 Dec 2011 by #realJSOP

Of course a stored proc can be made to time-out. Assuming you have a proerly designed and constructed database, along with a stored proc that actually works, it shouldn't time-out. Try running the stored proc inside sql manager express and see how long it should take to run.

SQL

server

can I use a laptop as a server to run production job everyday?

16 Dec 2011 by #realJSOP

If you're talking about backing up to the laptop, that's a REALLY bad idea.

Architect

service

server

Problem implementing C# Client-Server to keep game data in sync

22 Dec 2011 by #realJSOP

If it were me, I would let the clients push their own updates and pull other client updates on a regular basis. That makes the server nothing more than a glorified data clearinghouse. All it does is listen for client connections, and then the clients drive the comm session - not the server.

server

networking

game

Problem with SQL server connection string in MVC

18 Mar 2016 by #realJSOP

This is a weird one. So I'm cruising along developing a MVC5 web site, and everything is going pretty well, including using stored procs from the database.Then I added a new call to the database. This call fails with the exception Keyword not supported 'initial catalog' when I try to...

SQL

server

Problem with SQL server connection string in MVC

18 Mar 2016 by #realJSOP

Weirdness. Without ANY changes to my code, it started working. I can only shrug my shoulders...

SQL

server

Encrypt existing SQL server data

4 Nov 2016 by #realJSOP

Encrypt a Column of Data[^]

SQL

.NET

server

Sql injection prevention

4 Nov 2016 by #realJSOP

Why are you going through that song and dance? Just write better sql code.0) Constrain and sanitize input data. Check for known good data by validating for type, length, format, and range.1) Use type-safe SQL parameters for data access. You can use these parameters with stored...

SQL

server

How to fix ' the wait operation is timed out ' ?

21 Nov 2016 by #realJSOP

Increase the SqlCommand.Timeout value. I typically just double mine when I run into this issue (however the default value is 30 seconds, and that is typically enough). You could also set it to 0 which indicates no timeout, but that can be dangerous, and lead to an app that hangs.Secondarily,...

How I create a resume parser in c#.net

13 Jan 2017 by #realJSOP

Parsing resumes is next to impossible due to the free-form nature of the documents. Add to that the fact that many people aren't detail-oriented enough to make sure they spell everything correctly, or that a given acronym could mean several different things, and that makes it even harder to do...

SQL

server

Sql server 2008R2 - SSIS importing excel file

22 Mar 2017 by #realJSOP

I'm starting with a file that:0) Contains one or more sheets1) The names of the sheets are not guaranteed to be the same, but the columns in them are always the same2) The header row is row #5 (and there is data above this row that I don't want to import).Essentially, I need to...

Is there anybody who can help me fix the ransomware affected files

21 Mar 2018 by #realJSOP

Restore the file from a backup. You have a backup, right?

SQL

virus

server

How to import/export database from mylittleadmin to my pc

1 Apr 2018 by #realJSOP

There's a forum for mylittleadmin. Why don't you ask your question there?

SQL

ASP.NET

server

Conversion failed when converting date and/or time from character string. Severity 16

2 Apr 2018 by #realJSOP

There's no such thing as hour 24. You should use 00. Time is measured from 00:00 (midnight) to 23:59 (11:59pm)

SQL

server

How I can reset my table records to default

17 Apr 2018 by #realJSOP

0) Using a float for an ID column is not the best idea. If you think your ids are going to be numerous, use a bigint. 1) After adding data, changing the type of a column will result in the loss of all data in the table. 2) If it were me, I would create a whole new table with the same schema,...

SQL

server

How to read HTML code into SQL server

16 May 2018 by #realJSOP

I would look into storing a rendered HTML page in a binary column. This means you have to convert the page into a byte array and pass that byte array to your stored procedure, and the stored procedure would store the byte array into the appropriate column of your table. ======================= ...

HTML

SQL

server

Sql agent running SSIS packages (SQL server 2016)

28 Jun 2018 by #realJSOP

Is it possible to specify default command line parameters that are always included for packages that run from the file system? When you have multiple db instances, and a given package is running from the package store, can the package determine the db instance that's running it? What I have...

SQL

SSIS

server

Sql server 2008R2 SSIS weirdness when creating folder

23 Sep 2018 by #realJSOP

I have a package with the following tasks: File System task - Create a folder if it doesn't already exist. File System task - Delete file if it exists in the folder FTP task - copies new file and places it in the folder. I'm using variables to determine the path name form parameters passed...

SQL

SSIS

server

C# or SQL function required for amount to words in thai

5 Oct 2018 by #realJSOP

While it's entirely possible to make SQL server do this, it's not an appropriate platform for the work. Retrieve the data into a C# application, and translate it there. FWIW, calling a function from a query is the best way I know of to significantly reduce the speed of the query. C# is MUCH...

SQL

server

Is it possible to read from one SQL server then read data from an entirely different SQL server using C#?

9 Oct 2018 by #realJSOP

There are a number of ways you can handle this issue. 0) you can create an ado class that is initialized with a different connection string (inheriting from a base class that provides query functionality) 1) You can create a static class that has a method that allows you to specify the server...

SQL

server

Context.database.sqlquery to upload an excel file

10 Oct 2018 by #realJSOP

I wrote an article regarding importing excel/csv file into a datatable object. From there, it is a fairly simple matter to actually get the imported data into a table in sql server. CSV/Excel File Parser - A Revisit[^] The result presented by the code in that article is a datatable with...

SQL

server

Couldn't save uploaded file in server C#, MVC

6 Feb 2019 by #realJSOP

I posted a tip about this a number of years ago: Resolving Paths in a Multi-Folder WebSite[^]

How to return from SQL stored procedure

24 Nov 2016 by $*Developer - Vaibhav*$

Create SP and add below scriptINSERT INTO #tab EXEC Procedureand Select * from #tab

SQL

server

Import ExcelSheet Data and Images to sql server data base in c#

13 Feb 2015 by .net333

Hi Friends, i want to browse and import excel sheet data to sql server database..Data importing completed and working fine..but images are not uploading..here is my codeprotected void btnupload_Click(object sender, ImageClickEventArgs e) { ...

Desktop app (SAAS) safe connection with AWS SQL server database?

21 Jan 2018 by .NetDev_1012

Hello, Would like some feedback as per the method I would like to connect to AWS (Amazon Web Services) with a possible commercial software developed as a desktop software. The idea is to encrypt the data source connection in the App.config file in the .Net application to AWS SQL Server...

How to insert multiple records in sql server database single table.

3 Dec 2011 by .NetDeveloper09

I am trying to install multiple records on the remote server using this statementInsert into XYZ(a,b)Values('x','y'),('x','y'),('x','y'),('x','y')but its not inserting however if i insert single value then its working, where i am wrong? please help.

SQL

server

What does it mean if one gets the folliwing database error message?

11 Sep 2014 by /\jmot

did you set the provider to the conectionString?? if not then try like this.."Provider=SQLOLEDB;Data Source=.\\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=SSPI;Persist Security Info=False"

SQL

WinCE

server

Conversion failed when converting the varchar value '08SANJAY3001' to data type int

17 Sep 2014 by /\jmot

Try..TRY_CONVERT(int,'08SANJAY3001')

SQL

server

C# Insert into sql server error...

11 Oct 2014 by /\jmot

private void cmdAdd_Click(object sender, EventArgs e){ String connStr= "Data Source=ACER-LAPTOP\a2006; Database=AED_MOBILE_0; Initial Catalog=db_stuRegisterPay; Integrated Security=SSPI"; SqlConnection myConnection = new SqlConnection(connStr); myConnection.Open(); ...

SQL

server

How to ensure that the max primary value is never exhausted

22 Oct 2014 by /\jmot

here you may not get the solution, but definately you'll get some thoughts..#Here[^]

SQL

Microsoft

server

How Can I Use Like Trans Commit In Linkq As We Use In Sql Server

13 Nov 2014 by /\jmot

See these links..http://stackoverflow.com/questions/17448689/transactions-commit-and-rollback-with-entity-framework-mysql-and-linq-to-sql-in[^]http://stackoverflow.com/questions/867643/how-to-use-transactions-with-a-datacontext[^]

SQL

LINQ

server

how to create dynamic tables in sql server using C#

15 Nov 2014 by /\jmot

Try these links..it'll help...

SQL

server

How do I store Work Time?

17 Nov 2014 by /\jmot

Try it.Create Table Work_Assign_Employee([Id] [bigint] IDENTITY(1,1) NOT NULL,[Employee_id] [varchar](50) NOT NULL,[Work_id] [varchar](50) NOT NULL,[Date] [Date] NULL Default(getdate()),[Time] [Time](7) NULL..add more column if you want)ALTER TABLE...

SQL

server

How to read temporary table data into cursor

17 Nov 2014 by /\jmot

i think..you want the columns with nulll value and you want to set the value to the corresponding field.am i right???so, just run a simple Sql Query to fetch the corresponding column which one you want to set with it's desired value and update the column.thats it.like...

SQL

cursor

server

How to do the Replication in sql server between local and cloud?

27 Nov 2014 by /\jmot

See this link...http://stackoverflow.com/questions/12179778/local-and-cloud-db-2-ways-replication[^]

SQL

server

how to write a join query between two tables

1 Dec 2014 by /\jmot

see this..select(case when a.name=b.name then isnull(b.sno,a.sno) else isnull(a.sno,b.sno) end) as sno ,isnull(a.name,b.name) from [dbo].[Table_1] afull join[dbo].[Table_2] b on a.sno=b.snoHere...

SQL

server

error when installing sq; server 2008

4 Dec 2014 by /\jmot

Try these..How to Install SQL server 2008 on Windows...

SQL

server

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

5 Dec 2014 by /\jmot

Search here..https://www.google.co.in/search?q=encryption+in+asp.net+c%23+using+aes&oq=encryption+in+asp.net+c%23+using+aes&gs_l=serp.3...264136.271321.0.277209.15.14.0.0.0.1.210.1527.0j8j2.10.0.msedr...0...1c.1.58.serp..8.7.1055.MbQ1xtgujJU[^]See...

C#5.0

SQL

server

convert some column values into csv in MS SQL procedure

9 Dec 2014 by /\jmot

Fill the result in a Datatable and Export it to a CSV file..See ..Writing a DataTable to a CSV file[^]

SQL

server

DBCC CHECKDB Explain...

26 Dec 2014 by /\jmot

Database Console Command(DBCC).Check database(CHECKDB)(a particular database) for Errors.DBCC CHECKDB to check errors in SQL Server database.-- Check the current database.DBCC CHECKDB;GO-- Check the AdventureWorks2012 database without nonclustered indexes.DBCC CHECKDB...

SQL

server

How to store special characters in C# SQL Server 2008

4 Feb 2015 by /\jmot

You can use Var-char/text datatype to store this type of characters in sqlDB.i think you are decoding the output when fetching from database using HtmlDecode() method.e.g: Want to insert data like: a>bcmd.Parameters.Add("@Message", SqlDbType.VarChar, 50).Value =...

SQL

ASP.NET

server

split row data and insert a symbol

16 Feb 2015 by /\jmot

update abctable set columnName=substring(columnName,1,5)+'-'+substring(columnName,7,len(columnName)-5)ref.https://msdn.microsoft.com/en-us/library/ms187748.aspx[^]

SQL

server

How I Update From One Table To Another Table

22 Jul 2014 by 10923679

i need to update one table(main table) from a another temp_table table1(main table)billno. name address date fun A1001 [null] [null] [null] ABCB1002 [null] [null] [null] BCAA1004 [null] [null] [null] BACtable2(temp...

SQL

ASP.NET

server

How Do I Split A String Into Multiple Columns

10 Sep 2014 by 10923679

Table1-------- MainData 102-12-3445 234-42-4666output ........ ob bc dc 102 12 3445 234 42 4666how to split values with(-) into different columns i am using ASP.net and SQL SERVER so...

SQL

ASP.NET

server

How Do I Split A String Into Multiple Columns

10 Sep 2014 by 10923679

Select Parsename(replace(MainData,'-','.'),3) as ob,Parsename(replace(MainData,'-','.'),2) as bc,Parsename(replace(MainData,'-','.'),1) as dc from table1i have got my result..

SQL

ASP.NET

server

I got Error Mssage How to resolve thismessage

30 Nov 2011 by 2011999

Dear All,I Got Error In dr.BeginEdit(); "Object reference not set to an instance of an object."}protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridView _gridView = (GridView)sender; if (e.RowIndex > -1) { ...

SQL

ASP.NET

server

Is it use two databases in one application?

7 May 2012 by 2011999

Dear All,Is it use two databases in one application? if we are use two databases in future face any problem for that.

SQL

server

Is it possible existing dabase table content overide?

8 May 2012 by 2011999

DataBase1 Table A (in this table have some data)DataBase2 Table B ( in this table have some data)Table A in Have diffrent data and Tabel B have Different Datawe need B table data overided with A tabe data is it possible

SQL

server

How to sent mail to all users registered using SQL SERVER MVC ?

10 Feb 2021 by 20212a

This is not a task a newbie can handle. There are lots of pieces to it and you'll need to learn all the different parts. For example, what kind of app will you be writing? A windows forms app? Console app? A web app? Or will this just be a...

SQL

MVC

server

Deploying SSRS Reports on client's location

22 Jun 2011 by 2irfanshaikh

I think the links given below will help you.http://reportviewer.codeplex.com/[^]http://social.msdn.microsoft.com/forums/en-US/vsreportcontrols/thread/5aa7eee7-d4a7-427a-ab8d-7a3d4d4f0bf3/[^]

Lock a Sql Server Table While Read

3 Jan 2012 by 2irfanshaikh

I think this link will help you Click Me[^]

SQL

server

how set alert for email getting for reciving messages on mobile

6 Feb 2012 by 2irfanshaikh

Search for Email to SMS service

SQL

ASP.NET

server

Import Multiple excel workbook sheets into Multiple respective database tables

29 Dec 2015 by 2irfanshaikh

This Link[^] will help you to get all the sheets from the excel and convert to DataSet.this Link[^]. will help you in inserting values in database.Please google before asking question.

SQL

ASP.NET4

server

Difference between clustered and non clustered indexes?

5 Feb 2010 by 4277480

if the number of records is small then there is no need for indexes, the real challenge begins when 1. you have a huge data base and 2. the relation between application and database. Both methods are trade off between performance and performance. The best solution is the solution coming from...

SQL

server

Can we have one single query to delete data from one table and insert it into other table

5 Feb 2010 by 4277480

yes you can use a delete trigger and on that trigger insert the data to the table.

SQL

MySQL

server

Auto complete and search data base

5 Feb 2010 by 4277480

Lucene[^]W...

SQL

.NET

server

Environment.UserName as filter parameter

5 May 2010 by 4277480

Are you sure you dont get the error "Server tags cannot contain constructs."

SQL

ASP.NET

server

Matrix transformation in SQL server 2014

4 Jun 2017 by 855

i have a table like this: 3 columns * 4 rows col1 col2 col3 a b c d e f g h i i j k i want transfer it by sql to a 4 columns * 3 rows table. col1 col2 col3 col4 a d g i b e h j c f i k is there an elegant way to do this ? many thanks~!!! What I have tried: i tried pivot and unpivot,...

SQL

server

How do I get a message from client1 to client2 through a server using named pipes C#?

10 Dec 2017 by ________________

One solution (simplest) - clients should have timer, and try to read from server messages every 1 second (or less, or more - according business demands). Second - each client should be also server for main, and when main will have message from one client, it should broadcast this message to...

A customer purchases 1 kg of sweets at rs. 60 .find the quantity of sweets rs. 51?

12 Dec 2017 by ________________

double Quantity1 = 1.00; double Price1 = 60.0; double Price2 = 51.0; double Quantity2 = (Quantity1 / Price1) * Price2;

SQL

server

What is Cursor in sql server

16 Aug 2012 by __TR__

http://www.sqlteam.com/article/cursors-an-overview[^]http://blog.sqlauthority.com/2008/03/05/sql-server-simple-example-of-cursor-sample-cursor-part-2/[^]

SQL

server

Mail Structure Syntax For Sending Mail in SQL Server

18 Nov 2012 by __TR__

You might find the below links helpfulSQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database[^]sp_send_dbmail (Transact-SQL)[^]

SQL

server

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

SQL

server

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

server

Watermark add to image and save database c# (winform)

12 Dec 2012 by __TR__

Check these CP articlesCreating a Watermarked Photograph with GDI+ for .NET[^]How to Create watermarked images in C# ASP.NET ?[^]

How to setup Branch Timings in asp.net . If u have any templates please send me.

18 Dec 2012 by __TR__

Check these related threads on dropdownlist with checkboxmultiselect checkbox inside DropDownList in asp.net[^]how to add checkboxes in dropdownlist in asp.net[^]Or this CP articlesMultiselect Dropdown for Web Applications[^]You can also check outDrop Down CheckBoxList control [^]

SQL

ASP.NET

server

Foreign Key Referential Integrity

22 Dec 2012 by __TR__

Not sure if i understood your question correctly, but if you are looking for the syntax on how to create a foreign key you can check the below linkCreating Primary Key, Foreign Key and Default Constraint[^]

SQL

server

how to use two primary keys in table

17 Jan 2013 by __TR__

Take a look at the below links that show how to create composite Primary keysCreating composite primary key in SQL Server[^]How to create composite primary key in SQL Server 2008[^]SQL Server Add Primary Key[^]Composite Primary Keys[^]

SQL

server

How to convert datetime value to UTC format

11 Sep 2012 by _Amy

Hi,Try this code to convert the DateTime to UTC DateTime.DECLARE @LocalDate DATETIMESET @LocalDate = GETDATE()-- convert local date to utc dateDECLARE @UTCDate DATETIMESET @UTCDate = DATEADD(Hour, DATEDIFF(Hour, GETUTCDATE(), GETDATE()), @LocalDate)SELECT @LocalDate,...

SQL

server

How to set Password for Database in Sql Server Managment studio?

8 Sep 2014 by _Amy

To enable the specific login, follow the steps:Expand the SQL ServerExpand Security nodeSelect the Particular Login (User)Press right button and select properties of the loginGo to Status table Enable the UserThen try to login.Refer Login failed for user 'username'. Reason: The...

SQL

server

update command for multiple columns on a single table using joins, taking more time to run

21 Jul 2013 by _Asif_

I think the fastest and safest way to do this can be elaborated in below steps* Identify all rows (primary key) that will get affected and store it in excel sheet be executing below querySELECT A.UID, B.GrossAmount, B.Units, B.GrossAmountfrom TUnit A join TUnit B on A.UID...

SQL

server

pROBLEM IN EXECUTING STORE PROCEDURE IN VB.NET2003

31 Jul 2013 by _Asif_

The problem is in your computed column. The computation is failing with divide by zero error or overthrow. Check this linkhttp://msdn.microsoft.com/en-us/library/ms190306.aspx[^]

SQL

server

SQL Server Import and Export Wizard

26 Feb 2014 by _Asif_

Check this URLTrigger not working on SQL import export wizard[^]

SQL

MS-Excel

server

syntax error in sql server store prodedure

28 Apr 2014 by _Asif_

It seems that @DistrictID is empty. Check this variable. You can also debug your sql by simply printing the @vQuery variable and check the generated sql.

SQL

server

How to run a query on group of databases ?

4 May 2014 by _Asif_

Try this assuming all databases are on the same instance.DECLARE @DATABASE TABLE( ID INT IDENTITY(1, 1), NAME VARCHAR(100))INSERT INTO @DATABASE (NAME)SELECT 'Adventure' UNION ALLSELECT 'TESTDB'DECLARE @INDEX INT, @TOTAL INT, @DBNAME VARCHAR(100)SELECT @INDEX =...

SQL

server

how to use 2 temp table in sql server

14 May 2014 by _Asif_

Try changing these linesinsert into #tblagereoprt insert into #tblagereoprt1 exec(@vQuery1) exec(@vQuery)to insert into #tblagereoprt Exec(@vQuery) insert into #tblagereoprt1 exec(@vQuery1)

SQL

server

To find count from sql table.. Please Help..

28 May 2014 by _Asif_

Try this SQLSELECT *from TABLE T Inner Join ( SELECT Candid from TableName group by Candid having count(*) = 1 ) tmp ON T.Candid = tmp.Candid

SQL

server

ASP.Net SQL Server Session management

24 Jun 2014 by _Asif_

Assuming that you are using Default implementation of Session stored on SQL Server. Please check that the entries in the ASPStateTempSessions table are removed after the related sessions have exceeded their expiration. If it is not removed that check that SQL Server Agent is running or not. This...

how to execute soreprocedure and check it in sql server who's retrun a value

14 Jan 2015 by _Asif_

Do something like thisDECLARE @return_status int;EXEC @return_status = [ChildDetails] 1, 'Text', 1, 1, '1'SELECT @return_status;

SQL

server

What is the way to install Sql server enterprise edition..when I attempt to install I am getting following error.

11 Jun 2015 by _Asif_

Check this[^] have similar issue and fixed by uninstalling appropriately and reinstalling.

SQL

server

How to find difference between two fields of two tables

7 Mar 2018 by _Asif_

Try this DECLARE @A TABLE ( ARTICLE_ID VARCHAR(10), COST NUMERIC(10, 2), qty_should_be INT ) DECLARE @B TABLE ( ARTICLE_ID VARCHAR(10), COST NUMERIC(10, 2), qty_present INT ) INSERT INTO @A(ARTICLE_ID, COST, qty_should_be) SELECT 'ART0000024', 180, 100 UNION ALL SELECT 'ART0000024',...

SQL

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

How to make trigger for date changed

22 Feb 2010 by _Damian S_

If your users are logging into the system, I assume you only want to show each user the "thought of the day" once each day...In that case, simply have your aspx page make a call to the database passing the userid and today's date... if the user has previously received the thought of the day,...

SQL

ASP.NET

server

Connection problem in SQL Server 2008

31 Mar 2010 by _Damian S_

If you have been connecting previously, and now it suddenly isn't connecting, *something* must now be different.If you haven't changed the code, then that *something* must be network related.Some areas for you to check would be:1. Has the database user got the appropriate...

SQL

server

Need solution for this query

5 Apr 2010 by _Damian S_

You have selected 4/19/2010 twice, once as workpropertyvalue38 and once as workpropertyvalue41. You then refer to 4/19/2010 twice in your in list... This will likely confuse your pivot.

SQL

server

error in making stored procedure . error Msg 128, Level 15, State 1

17 Jun 2013 by _Damian S_

You have a syntax error. Insert statements must follow this format:insert into TABLENAME (FIELD1, FIELD2, ... , FIELDN) values (VALUE1, VALUE2, ... , VALUEN)

SQL

server

Retrieve single row by comparing with other rows for the same record

27 Jan 2014 by _Damian S_

If it's always the earliest (alphabetically) record that you want, you could do it like this:select ID, min(Status) as Status from TABLENAMEgroup by IDorder by ID

SQL

server

Code Merging Tools...

29 Aug 2013 by _Flaviu

Is really good this[^] one !

MVC

mergesort

server

How to read temporary table data into cursor

17 Nov 2014 by _Kapil

try this?create Procedure InsertStudentrecord As Begin declare @col varchar(255), @cmd varchar(max) DECLARE getinfo cursor FAST_FORWARD for SELECT c.name FROM sys.tables t JOIN sys.columns c ON t.Object_ID = c.Object_ID WHERE t.Name = 'table_student' OPEN...

SQL

cursor

server

Problem with Sql query

27 Feb 2012 by _Maxxx_

Select ItemName, Sum(Qty) as QtyFrom yourTableGroup By ItemNameorder by Sum(qty) Desc

SQL

server