i am trying to generate a dynamic where clause in my store proc.=== @population nvarchar(max)declare @chvSelect varchar(max), @chvFrom varchar(max), @chvWhere varchar(max), @chvOrderby varchar(max), @chvSQL...

SQL

SQL-Server-2008

SQL-Server

Incorrect Syntax near WHERE

8 Jan 2010 by #realJSOP

The first thing I would do is evaluate the string in the debugger BEFORE it's sent to your stored procedure. At that point, you can paste it into SQL Manager Express and try the query there to see WHERE your problem is.

ANY ONE TELL ME HOW TO DISPLAY DATA BETWEEN TWO DATE RANGES USING C#.NET

28 Jan 2010 by #realJSOP

This is a pretty non-specific question, so you're going to get a non-specific answer. Assumtions:0) You know either the starting date or ending date of the range1) You know how long the range is2) You're not worried about the time componentDateTime start = new...

SQL

Can I change only day in datetime in SQL Server 2005?

30 Jan 2010 by #realJSOP

You know, your coding would go A LOT faster if you used google:http://msdn.microsoft.com/en-us/library/ms186724.aspx[^]

How to store data from XML

4 Feb 2010 by #realJSOP

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

how to insert image in sql 2008

25 Apr 2010 by #realJSOP

You have to convert the image into an array of bytes and pass it to your database that way. When you retrieve the image, it will come over as an array of bytes that you then have to convert back to an image.There are plenty of examples if you google it.

SQL

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.

C# insert into two tables using a procedure

24 May 2010 by #realJSOP

Yes, you can call a stored procedure from any .Net app that has the correct references added to it.Specifically, you need to look up the SqlConnection, SqlCommand, and SqlParameter classes. Google is your friend.

SQL

ID Exist Or Not in DB

1 Jun 2010 by #realJSOP

Heres the query:string query = string.Format("SELECT id from table where id = {0}", myID);

SQL

ASP.NET

Creating a expire dll

9 Jun 2010 by #realJSOP

Three days after what? Installation? First use?I wouldn't use a DLL, I'd just add code to the application that uses a setting in the app.config file. The first time the app is run, store the date there. Each time the application is run, check the data and compare it to today's date. If the...

SQL

help with IDENTITY columns..

25 Jul 2010 by #realJSOP

The unique ID merely identifies the record. Your assumption that one song can only be attributed to a single artist is flawed because many artists might cover the same song. For instance, I know of at least a dozen versions of the title Ghost Riders In The Sky, and some of those versions are...

SQL

SQL-Server-2008

SQL-Server

Array List

3 Aug 2010 by #realJSOP

Instead of dealing with complex types, I have a single method in my web services that accepts a stored proc name and a xmlstring of parameters. The web service method translates the xml parameters into sql parameters, and calls the stored proc, which then returns its datasat as xml.One type...

SQL

webservice

Saving query results locally in C#

23 Aug 2010 by #realJSOP

Well, once you retrieve the data, it resides in a DataTable, correct? So just use LINQ to query the DataTable object.

SQL

DataTable

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

8000 Limit of varchar.

9 Sep 2010 by #realJSOP

Put the query into a stored proc, and pass the necessary parameters into that stored proc.

SQL

SQL-Server

database

Populating two tools with one eventclick.

20 Sep 2010 by #realJSOP

I don't see where your problem is. Just get the value and set the checkbox. It really is that easy. If you have to preform another query, then perform the query.

SQL

Sending Emails under certain conditions

21 Oct 2010 by #realJSOP

Use google, there are THOUSANDS of available examples of sending email with C#.

SQL

ASP.NET

Auto increment column after delete and insert

31 Oct 2010 by #realJSOP

It's not broken and you shouldn't try to "fix" it. SQL Server maintains the index of the last inserted item. It's supposed to be a unique value, and the only way that can be guaranteed is if you allow SQL Server to maintain that index. You *can* reset the value, but you'd have to reset it again...

SQL

ADO.NET

ASP.NET

Improving time when get/bind a dataset from Microsoft SQL server

7 Dec 2010 by #realJSOP

Three seconds for SQL Server to return a dataset is a LONG time. The more records you have, the longer everything is going to take, and that means binding as well.

SQL

Gridview

design issues of temporal data warehouses

3 Jan 2011 by #realJSOP

This question cannot possibly be answered here (in Questions & Answers) because the topic its too broad, and a variety of opinions can be expressed. Repost it in the appropriate forum so you can have a threaded discussion about it, or limber up your google muscle and research this thing yourself.

how to avoid decimal being rounded off in sql

12 Jan 2011 by #realJSOP

Maybe you didn't correct configure the column. You have to specify the number of places to the right of the decimal, like this:decimal(10,2) - ten digits, with two to the right of the decimal point.EDIT ============I'm curious. If this was "the" answer (which it looks like it was),...

SQL

ASP.NET

How to execute high volume inserts and query the table simultaneously

16 Jan 2011 by #realJSOP

Well, your insert code should probably be in a thread. You can save time by putting the thread into a class, and creating the SQL connection and command just one time. The body of the thread should be concerned with repeatedly stuffing the data into the database. It would go something like...

SQL

How to check if value exists in database,

17 Jan 2011 by #realJSOP

Retrieve the text, send it to a stored proc, and let the stored proc search the applicable column for the text.

SQL

When to use ORM tools...?

18 Jan 2011 by #realJSOP

The best time to use an ORM is: 0) When you don't care how badly a program performs1) You're willing to give up a certain amount of flexibility2) You know for sure and certain that there's no way on this earth that you're going to need to modify the generated code.

SQL

ASP.NET

Silverlight - Interacting with the server

19 Jan 2011 by #realJSOP

You MUST use a web service to interact with a database from Silverlight. This link should get your started:http://msdn.microsoft.com/en-us/library/cc197940(v=vs.95).aspx[^]

Ideas for MSc(computer science ) final project

20 Jan 2011 by #realJSOP

You seriously can't think of anything yourself? How about a simple "Hello world" project?

SQL

C#3.0

ASP.NET

URL Routing Session Problem

20 Jan 2011 by #realJSOP

I believe you have to clear the session cache on the site. Otherwise, sessions remain active until you actually shut down the browser instance that started that particular session (or maybe even all existing browser instances).

SQL

Ajax

ASP.NET

WCF services and silverlight application

4 Mar 2011 by #realJSOP

Put the code into a try/catch block, and use the freakin' debugger.

SQL

Silverlight4

WCF

how to select distinct values ?

17 Mar 2011 by #realJSOP

Try casting column1 to a varcharselect distinct cast(column1 as varchar(max)), column2...

SQL

In Sql Select Query how to select max three value in one query

18 Mar 2011 by #realJSOP

select top 3 id, name, percent from mytable order by percent desc

SQL

Dynamic Data Master Page Filtering

29 Mar 2011 by #realJSOP

Try this:ControlType control = (ControlType)Master.FindControl("controlID");And then you should be able to get the selected index.

generating complete sql dynamically

31 Mar 2011 by #realJSOP

Yes, it's possible to build all of your sql dynamically. Whether or not you do it correctly is another question, and one I cannot answer.I would personally do it in a stored procedure, but that's just me.

SQL

ASP.NET

How to detect orphaned connections?

14 Apr 2011 by #realJSOP

Do you mean from the sql side of things or the application side? You gotta be a lot more specific. And what do you mean by "orphaned" connections? As far as a .Net application goes, you should ALWAYS close a connection after using it. There are few reasons to keep a database connection open...

Create a SQL Procedure from C#

25 Apr 2011 by #realJSOP

I believe you can set quoted_identifiers and ansi_nulls inside the stored proc, so move those in there. You don't techniqally need the USE statement, so comment it out. Then, try your code again.

SQL

How do you query a text file as a ole db source (syntax for a WHERE clause)?

2 May 2011 by #realJSOP

The way I'd do it is *without* any of that sql stuff...0) Create an object that holds the data:public class SampleItem{ public DateTime SampleDate { get; set; } public decimal DepthFeet { get; set; } public decimal WaterTemp { get; set; } public SampleItem() ...

SQL

text

Insert multiple rows to a DB using DAAB without multiple round trips

4 May 2011 by #realJSOP

Would it be possible to simply transfer the table as a binary file using FTP or TCP/IP, and then let the remote machine do all the database work itself?If you want to ensure some kind of recovery system (in the event the transfer is interrupted), you could send smaller files and alt least...

order by in update statement

5 May 2011 by #realJSOP

You don't use "order by" in insert or update statements. It doesn't matter how the data goes into the table.

SQL

Examples for Invoice and Voucher in WPF?

9 May 2011 by #realJSOP

This is entirely unanswerable.

SQL

Why are brackets needed to around ON [PRIMARY] in a CREATE TABLE statement?

9 May 2011 by #realJSOP

Because it's required to make it work. That's the best I know to tell you.

SQL

SQL-Server

database

Style & Multiple connections from 1 connString

10 May 2011 by #realJSOP

I'm sorry, but that code resembles nothing I've seen that would compile, and has nothing to to with SQL, so that makes your tags wrong, too.

SQL

style

How do I save a screen scaped website to an SQL database

12 May 2011 by #realJSOP

You probably want to use a blob field - some web pages can be huge.

SQL

web

database

How do I read screen scraped data from an sql database onto a web browser control?

19 May 2011 by #realJSOP

If it's saved as an image, you could do this to get it on the screen (using the appropriate ImageFormat enum of course):// Set the content type and return the imageResponse.ContentType = "image/GIF";bytes.Save(Response.OutputStream, ImageFormat.Gif);

SQL

web

database

Online art gallery in asp.net,c#,sql...

6 Jun 2011 by #realJSOP

Do you able to use google?

SQL

ASP.NET

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 back end conflict witf froent end

6 Jul 2011 by #realJSOP

Looks to me like you're not using comm2 after it's instantiated.

SQL

split string and store into database in SQL ,c# lang

11 Jul 2011 by #realJSOP

"plz help me its argent"I don't care what shade of silver it is, that's not going to make us want to help you.As to your question, you could send the parsed string as XML data to a stored procedure and let sql server handle it.

SQL

Ignore Date part and get time part from datetime column in sql?

12 Jul 2011 by #realJSOP

EASILY found on google. You could put this code into a Sql function if you want to:CONVERT(char(10), MyDateTime, 101) AS [Date], CONVERT(varchar(2), CASE WHEN DATEPART([hour], MyDateTime) > 12 THEN CONVERT(varchar(2), (DATEPART([hour], MyDateTime) - 12)) ...

SQL

ASP.NET

SQL Stored Procedure

18 Jul 2011 by #realJSOP

I think googling would have produced sufficient into to answer your question. I found this link when I googled "stored procedure faster than c# code?".http://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html[^]

SQL

The Evil That is "Select *"

10 Aug 2011 by #realJSOP

Just say no to SELECT * in your SQL

SQL

Clear a DataRow Item (as opposed to deleting it)

26 Jul 2011 by #realJSOP

One way to effectively zero the columns any DataRow object.

SQL

how to resolve error 26 in sql server 2005

1 Aug 2011 by #realJSOP

Is the server itself working? Can you ping the box?

SQL

SQL-Server

SQL-Server-2005

How to check Database on createID form buttonclick

9 Aug 2011 by #realJSOP

Let the database do it. If you set the loginID to be a unique column, trying to add an id that already exists will generate an error in the stored procedure which will be reflected to the client app as an exception (or maybe the return value from the stored proc will indicate a problem).

SQL

Software to create dashboard reports

16 Aug 2011 by #realJSOP

Are you working with the guy that asked this question, or are you perhaps the same person using a 2nd account?how to do dashbaord reports using asp.net?[^]It's really coincidental that two people ask the same question on the same day.

SQL

searching in SQL using storedprog

25 Aug 2011 by #realJSOP

Something like this:select *from table1where column1 like '%project management books%'

SQL

create dynamic controls through sqlserver in C# windows environment.

26 Aug 2011 by #realJSOP

Your question doesn't exactly spell out what you want to do. Are you saying you want to create controls as specified from a SQL query? If so, you would have to do something like this:// assuming you've already retrieved your sql data into a DataTable object:bool haveCtrl = true;DataRow...

SQL

Incorrect syntax near 'ProjectOverview'.

31 Aug 2011 by #realJSOP

I'm almost positive that you can't use MAX on a string. Try it this way:ISNULL(MAX(ProjectOverview.[Target Event Date - Date]), 'INACTIVE') AS [Target Bid Date]

SQL

how to take sum from two tables

1 Sep 2011 by #realJSOP

Try this:select id, name, address, sum(amount) from table2 group by id, name, address

SQL

ASP.NET

Is Their any querybuilder tool

9 Sep 2011 by #realJSOP

Well, did you google it to see before asking us to do it for you?

SQL

program for the blind

14 Sep 2011 by #realJSOP

Windows comes with software that essentially reads the screen for the user. Look under Start | Accessories | Ease of Access.

SQL

SQL Stored Procedures Lessons

15 Sep 2011 by #realJSOP

Take a class - it's better than a web-based tutorial.

SQL

SQL-Server

Pass tablename as parameter

19 Sep 2011 by #realJSOP

You pass it as a string, but then in your stored proc, you have to use "dynamic sql":CREATE PROCEDURE [dbo].[spn_executeSQLExample] ( @tableName VARCHAR(100))ASBEGIN DECLARE @sqlStatement AS NVARCHAR(500) SET @sqlStatement = 'SELECT COUNT(*) FROM ' + @tableName ...

SQL

ADO.NET

Execute query only if it is select statement. How?

6 Dec 2011 by #realJSOP

if (yourquery.Trim().ToUpper().StartsWith("SELECT")){ // execute the query}

SQL

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

Silverlight 4 - C# Sql Database Updating

12 Dec 2011 by #realJSOP

You can only communicate with a database via a web service. So that means you have to write one.Google is your friend.

SQL

Silverlight4

What are ways to perform scheduling?

14 Dec 2011 by #realJSOP

Write a Windows service that can get job info from the database, and then run the jobs on the specified schedules. Of course, you didn't describe the nature of the "jobs", so it's impossible to be more specific with suggestions.

SQL

.NET

Just a quick question

19 Dec 2011 by #realJSOP

A simple google search would have revealed this CodeProject article:Save Image in MySQL DB using ASP.NET C #[^]

SQL

MySQL

Control Not Found in Namespace but App Compiles Fine

17 Nov 2014 by #realJSOP

How to fix this ANNOYING problem

Documenting SQL Stored Procs in C# Code

5 Oct 2015 by #realJSOP

Yes, you CAN document your stored procs in C# code.

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

How do I optimize my VB.NET csv import

3 Oct 2016 by #realJSOP

Look at my recent article. It should be quite simple to convert to VB.Net.CSV File Parser[^]You could also just put it into a DLL assembly and call it from your VB app.As far as bulk inserts go, I would write a stored procedure and submit the records one at a time. That would be faster.

SQL

How to get seconds into hh:mm:ss in windows form

7 Oct 2016 by #realJSOP

In the following example, str will be "00:20:34"TimeSpan test = TimeSpan.FromSeconds(1234);string str = test.ToString();

SQL

How to use list for multiple records save in database at a time

17 Oct 2016 by #realJSOP

Google "SQL BlockCopy". I'm assuming you simply want to stuff data into the database without regard for duplicates or otherwise existing data in the table in question.If you're using stored procs and/or perform an update and/or an insert depending on whether or not the data already exists in...

SQL

.NET

How to scroll down automatically a datagridview box with C#?

18 Oct 2016 by #realJSOP

private static void EnsureVisibleRow(DataGridView view, int rowToShow){ if (rowToShow >= 0 && rowToShow

Need to convert nvarchar in correct datetime format SQL

21 Oct 2016 by #realJSOP

0) What kind of idiot designs a SQL database to store a datetime as a nvarchar?1) Which "1" is the one you want to strip? At the beginning, or at the end? Do you even know what the actual purpose of the extra "1" is (why it's there)?2) The way your nvarchar string is shown, there's no...

SQL

SqlDataSource

DateTime

If exists... Query cannot work

25 Oct 2016 by #realJSOP

You don't need IF EXISTS - it's redundant. Simple remove the record and insert the new one.However, I would actually do it this way:-- try to update the recordUPDATE [mydatabase]SET ItemName = @itemName, Price = @price,WHERE ID = @ID;-- if no record was updated, insert it IF...

SQL

ADO.NET

Encrypt existing SQL server data

4 Nov 2016 by #realJSOP

Encrypt a Column of Data[^]

SQL

.NET

server

How to do bulk insert within another bulk insert in SQL 2008

4 Nov 2016 by #realJSOP

IMHO, I would break it into smaller chunks.0) Insert a new testrun item, and get the resulting id from the database for the recently inserted item.1) Do a bulk insert on detail items with that returned testrun id.That would be easier to debug.Since "code" is part of your user ID,...

SQL

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

Publish C# application with SQL no need for SQL express

22 Nov 2016 by #realJSOP

If your app uses SqlServer, there's no way around requiring the user to install some form of Sql Server, so...Add SqlServer Express to your installer's dependencies...- OR -Consider using SqlLite instead. Be aware that "lite" means exactly what you would expect - limitations on...

SQL

Why does my web application not retrieve data from SQL server 7 database

24 Nov 2016 by #realJSOP

This is a network or hardware issue - not a sql server (the software) issue, and certainly not applicable to c#.

SQL

ASP

legacy

C# migrate from SQL to access database

25 Nov 2016 by #realJSOP

DO NOT migrate backwards. Access has more issues than the Hillary Clinton does with the FBI.All you have to do is make SqlServer (in one for or another) a requirement of using your software. Your installer can install it for them.Check this link that compares the different sql server...

SQL

MS-Access

Downloaded gridview data in excel file does n't contain cell border in file

28 Nov 2016 by #realJSOP

My guess is that you're setting the border style AFTER you've set the border itself.foreach (TableCell cell in row.Cells){ cell.BorderStyle = grdMaterials.BorderStyle; //

SQL

ASP.NET

Sql compact error after build

29 Nov 2016 by #realJSOP

Change the setting (turn off "prefer 32-bit") and see what happens.FWIW, installing the 64-bit version is required, but you should not have to change your code to use the 32-bit version if that's what's installed on the user's machine. You shouldn't have to much around with "prefer 32-bit"...

SQL

How to get SQL runtime errors ?

10 Dec 2016 by #realJSOP

Why don't you have the query that threw the error log it instead of making the app do it?

How to pass .NET collection of objects (parent-child) hierarchy to a SQL server stored procedure

24 Dec 2016 by #realJSOP

I've never had performance issues with sql server that were not caused by something I've done. I don't use table valued parameters.You can either iterate the list and save the onbjects one at a time, or do like the first answer suggested, and serialize all the data into xml and pass the XML...

Transfer points from texrtfile to SQL database (point field)

6 Jan 2017 by #realJSOP

You have to store the points in the database as integers (or floats, depending on which UI framework you're using). You're going to need fields for X, Y, Width, and Height, as well as a way to identify a given button.

SQL

chart

How can I access SQL server database over internet? When both pcs are not on same network?

9 Jan 2017 by #realJSOP

The server has to be configured to allow it. You have to contact the DBA that owns the server, and after it's properly configured, he can provide the appropriate connection string. However, any DBA worth his salt won't do as you ask, because it's more secure and auditable to have an outward...

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

Add khmer unicode to SQL server management 2012 show ?

25 Jan 2017 by #realJSOP

Make sure your parameter and field types match (and they should be NVARCHAR).

SQL

Unicode

How can I convert ' character to " character in C#?

26 Jan 2017 by #realJSOP

str = str.Replace("'", "\"");

SQL

convert

string

US Federal Holidays (SQL)

31 Jan 2017 by #realJSOP

A scalar function to determine if a given DateTime is one of the ten US federal holidays, using SQL Server.

Build a Calendar Without Pre-Existing Tables

31 Jan 2017 by #realJSOP

Using common table expressions to build data from thin air.

Go to the next row depending on a value from a column in C#

6 Feb 2017 by #realJSOP

If I understand your question, you want to skip rows that have an "M" in a certain column.Change your if statement from this:if ((Myrow.Cells[8].Value.ToString()) == "M"){ //What should I do here?}else{...to this:if (Myrow.Cells[8].Value.ToString()) !=...

SQL

T-SQL

DataGridView

C# pass from listview to textbox on other form

13 Feb 2017 by #realJSOP

I've found that it's a good idea to do this when you're changing the field contents:select [desc] + ' ' + [compo] AS Description from vidros

SQL

How to store/save the store procedure from rich text box to SQL server

20 Feb 2017 by #realJSOP

I gotta say this doesn't seem like a very good idea. If your app gets hacked, someone could write a stored proc to your database that a) wipes all the data, and/or b) steals all the data, and/or uses the sql server as a spam bot, and/or any other number of evil deeds.

SQL

Select item from listbox and pass it as query to other form

22 Feb 2017 by #realJSOP

If it were me, I'd pass the selected items (as a List) to the new form via the constructor, and let THAT form perform the SQL query.

SQL