SQL

Viewed
313
Top SQL tips for beginners (a must read)
Article give details about SQL, tips, and tricks for beginners
Type
Article
sql performance tips
Viewed
273
How to back up SQL Server database?
Article explains various ways to backup SQL Server using C#, Powershell, by generating scripts or writing a script
Type
Article
C# SQL Back-up Database
Answer
2
How to retrieve an int from Stored Procedure and not an objectResult using EF ???

Hi,

 

im trying to set dat...

Type
Question
sql web service
Answer
2
Could not find stored procedure

I am getting SQL Exception when calling stored procedure in my asp.net MVC the exception is : "Could not find stored procedure"

 

...
Type
Question
asp.net exception sql exception stored-procedure
Answer
2
How to save Product Order details with User Id?

I have a user table & I want whenever a user orders a product, its order should be saved in order table with user primary key, so what relationship I have to add in user and order table. please let me know

Suppose, this is my ActionMethod

public ActionResult Create( Student student)
{

if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return RedirectToAction("Index");
}

return View(student);
}

 Database Relationship image

 ...

Type
Question
C# MVC sql-server entity-framework
Answer
1
how to manage shopping cart sessions without login

In MVC - In E commerce...

Type
Question
asp.net mvc sql javascript json
Answer
1
how to take back up of all sql server databases?

I am using SQL server 2012 right, and I would l...

Type
Question
SQL Back-up all-databases SQL-Server
Answer
1
Cannot execute script: Insufficient memory Error in SQL server

When I am trying to run a script of 300mb on SQL Server 2012 I am getting this issue

Cannot execute script: Insufficient memory to continue the execution of the program (mscorlib)

here is the image

...

Type
Question
SQL sql-server insufficient-memory cannot-execute-script

Page 1 of 1