Since there is no Sqlserver array parameter, what’s the best way to proceed?
I need to create multiple records in sqlserver, each with the same value in column A, but with a unique value in column B. I have the values for column B in an array.
stored-procedures
How to correct this ASP.NET error
MY ERROR
image are not insert how to change in my code pls send me code
How to rectify.
Data is Null. This method or property cannot be called on Null values
I’m working on an application where one can get information on movies from a database as well as add, update and delete the movies. In the database I have three tables (Movie, Genre and MovieGenre <- stores the movies and their genre/s). Everything works fine besides one thing, and that’s when a movie hasn’t got any genres (which should be possible).
Retrieving SQL Server output variables in c#
I have a stored procedure:
How do I store multiple results from a stored procedure into a dataset?
How do I combine to result sets from a StoredProcedure into one dataset in ASP.NET?
How to separate (split) string with comma in SQL Server stored procedure
I have a checkboxlist. The selected (checked) items are stored in List<string> selected.
The EXECUTE permission is denied on the user-defined table types?
I have a question about User-Defined Table Types in SQL Server 2008.
Passing an object collection as a parameter into SQL Server stored procedure
I have a general question on whether something can be done – and whether it will be the most efficient way of doing it !
Ordering SQL Server results by IN clause
I have a stored procedure which uses the IN clause. In my ASP.NET application, I have a multiline textbox that supplies values to the stored procedure. I want to be able to order by the values as they were entered in the textbox. I found out how to do this easily in mySQL (using FIELD function), but not a SQL Server equivalent.
C# ASP.Net Parameters.AddWithValue rejecting null value for parameter
I am populating tables using a stored procedure. The table allows a ‘null’ for the middle initial of the name, but I’m getting the following error message: