sql

  1. jag250

    Resolved SQL Help using specific statements listed in forum

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

    Resolved when null flag updated and conflict flag updated on SQL query statement?

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

    Find count of certain elements in the dataset

    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?
  4. G

    Question Update using Table Adapter

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

    Question How to add column column unitmeasure dynamically based on Flag Allow is 1?

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

    How do I convert my SQL query to Entity Framework DBContext

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

    How do I optimise the query

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

    In MS Test - running parallel tests - sql timeout comes

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

    use big data with SQL, what is better?

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

    Question when implement sqlclr function i get error on sql server 2012?

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

    London-UK: Developer C# - Permanent

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

    Houston, TX: Senior Developer C#, Xamarin - Permanent

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

    Dublin, Ireland: Senior Developer C#, Xamarin - Permanent

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

    London-UK: Senior Developer C# - Permanent

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

    How set db and read it?

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

    Question Datagridview Not populating

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

    ERROR: An entity can only be attached as modified...

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

    Multiple connection strings

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

    Question Questions regarding deploying a SQL database with app.

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

    Question connection string over internet

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