sql

USing theses Statements no Table SELECT SELECT FROM WHERE AND, OR, NOT, IN, LIKE GROUP BY HAVING (which also implies a join and a group by) MC/TF portion all multiple choice and True False 1. Show ship countries and a count of orders by Ship Country. Include orders placed in 1997 and...

I work on SQL server 2012 .really I don't understand what statement below do updatedand when when NullFlag updated and when conflict flag updated can you explain to me according to sample below <code> result of query data details rows without grouping : Masked_ID DocumentID PartID NULLCount...

Hi, I have a database and a dataset in C# application. The dataset has the list of my friends with phone number, address and a id. This is for learning purposes. I need to find the count of certain elements , say for example the total count of all the friends with ID > 3. How can I do that?

Hi, I have a sql server database with ID, First Name, Last Name, Phone Number and Address. I have created a wpf application that has a dataset of the database and uses a datagrid view to view the table. I did this as a learning procedure. Now I am learning how to update the database using wpf...

How to add column column unit dynamically when Flag Allow is 1 on table #nonparametric table ? I work on SQL server 2012 I can't add column unit dynamically when Flag Allow=1 as example below I have two rows have Flag Allow=1 family 90AM will be family 90 and family unit AM on two column...

Hello All, I have one query which I wrote in SQL but now i want to convert it to EF and I am finding difficulty on understanding how do I incorporate multiple select statements in EF SQL Query: SELECT TOP {count} * FROM ( SELECT co.orderid,co.orderStatusId...

Hello folks, I have prepared one query, but I feel this can be even more optimised! But I'm not sure what can be done Query SELECT TOP 10 * FROM ( SELECT co.orderid, co.orderStatusId, co.paymenttransactionstatusid, ( SELECT...

I have framework which runs 12 threads parallel - each will have different test but may have to get result from sql connection Doing so - I'm receiving below error - Is there a way where I can do any workaround in my code to make it work without loosing parallel threads <add...

Hello. I wan to select \ write \ read \ delete \ change colums, rows in table, will be a big size data for web and win application. Which of best way can you recommend with using c# language 1) Sql server or sqllite or mongoDB or some other 2) how to use data information cut big data for...

Problem I work on SQL server 2012 windows 7 when implement clr function i get error Msg 6522, Level 16, State 1, Line 1 A .NET Framework error occurred during execution of user-defined routine or aggregate "spExecuteParallel": System.NullReferenceException: Object reference not set to an...

PERMANENT Full-time position Below is an outline job description. If you are interested or have any questions, please email to Angela.Nguyen@virtusllc.com directly. Developer - London, United Kingdom Tracking Code 710-171 Job Description Senior Developer required for a unique, highly...

PERMANENT Full-time position Below is an outline job description. If you are interested or have any questions, please email to Angela.Nguyen@virtusllc.com directly. Senior Developer - Houston, Texas Tracking Code 401-171 Job Description IT professional experienced in .NET programming...

PERMANENT Full-time position Below is an outline job description. If you are interested or have any questions, please email to Angela.Nguyen@virtusllc.com directly. Senior Developer - Dublin, Ireland Tracking Code 611-171 Job Description IT professional experienced in .NET programming...

PERMANENT Full-time position Below is an outline job description. If you are interested or have any questions, please email to Angela.Nguyen@virtusllc.com directly Senior Developer - London, United Kingdom Tracking Code 699-171 Job Description IT professional with experience in C# .NET, and...

Hello, I am really a beginner on C# development. But, sometimes i like to play around with C# and try to develop stuff. I have sql express 2014. Visual C# 2017 Community Version. I created a database through SQL Management Studio in my local computer. The name of the DB is ReleasesLogin and has...

Hello, i have a method private void FillLevyRoll(), i put the method in a button on click event to fill a datagridview dgvLevyRoll my problem is when i run i am not getting an error and the dgv is remaining empty.Im lost confused tried but to no avail.The query works in SQL management studio...

Hi all, I hope you can help me. This is an issue I have been battling with for days now, and I am struggling to resolve it. My setup: I am using VS2015 Community Edition I am using LINQ to SQL .Net 4.5 I have read up quite a bit on this specific error, and it seems there are a couple ways to...

I have a winforms application & depending on the user selection regarding SQL authentication there are 2 possible connection strings :- - using (var con = new SqlConnection(String.Format("Data Source={0}; database={1}; Integrated Security=True", Sql_ServerName, Sql_DataBaseName))) - using (var...

Hi guys. I am new to SQL and I have a few silly questions I'm wondering about. I am a C# developer and have thus far only worked with access, .mdb files. Let's say you develop some software for a client. It;s to be loaded on a few workstations and they need to connect to a central database...

Hi, i am trying to learn C# programing language, so far i am an absolute beginner. I find visual studio and C# to be a fantastic tool. I am trying to make a very simple windows form application that would connect to SQL server over internet with which a user could add or change data in the...