Questions tagged [sql-server-2012-express]

Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

The Microsoft® SQL Server® Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications. Designed for easy deployment and rapid prototyping, this download includes support for Sysprep, Microsoft's System Preparation Utility for Microsoft Windows operating system deployment.

Source: Microsoft (SQL Server 2012 Express)

401 questions
-1
votes
2 answers

Add Serial# from initial item listing table to counted item table w/out Serial# in SQL

I am working on a small inventory project and I have two tables that I want to merge a specific way. Here are my two tables: Table 1 (Initial Item Listing): Scan# ItemNUmber Serial# ----------- ----------- --------------- 374 …
-1
votes
1 answer

How to Determine consecutive date count/days in SQL Server "finding islands" (consecutive rows)

I have a student table and I would like to know How long their session/training has lasted. I would like to exclude weekends, but I want to count continuous days excluding weekends. A class has Start Date and End Date, for example, student ID S1 a…
SQLfun
  • 53
  • 3
  • 15
-1
votes
1 answer

Sql Query To Return Notification from store table

I have a store table which have productName, productNumber, storedInBranch, blockNumber, quantity, notifyIn. If the quantity is less than notifyIn it will notify me and I tried the query below: select * from store where (quantity < notifyIn) AND…
Deadpool
  • 3
  • 5
-1
votes
1 answer

Warning: odbc_fetch_array() [Microsoft][ODBC Cursor Library] the instruction SELECT has a clause GROUP BY

I'm trying to do a query with a sub-query that joins the results of many lines in one, in SQL Server. When I run it on the Microsoft SQL Server Management Studio it works great! Query running on the Microsoft SQL Server Management Studio But doing…
-1
votes
1 answer

Any Best tutorial Exercise for AdventureWorks2012 available

I have installed AdventureWorks2012 database on my Microsoft SQL Server 2012 Express. Currently I need and want to do some tutorial exercise. Is there any Tutorial available on web. I have been doing a lot of searching nothing looking good to me
Toots
  • 47
  • 3
  • 12
-1
votes
2 answers

how to resolve this error while inserting image in sql server 2012

I am using SQL server 2012. This is the query I have: I am getting the following error: {{Cannot bulk load because the file "C:\Users\chitra\Desktop\j.jpg" could not be opened. Operating system error code 5(Access is denied.).}. What can I do to…
-1
votes
1 answer

SQL Exception: Error converting data type nvarchar to int

Looks like a casting issue, however when casting is applied (to what i believe is the correct format) i still get the SQLException raised in Visual Studio Web Developer 2010 Express (VB.NET) Start with a Stored Procedure that has 1 input parameter…
bob56
  • 29
  • 7
-1
votes
2 answers

Difference between SQL Server Management Studio and Express

I try to understand the difference between SQL Server Management Studio and SQL Server Management Studio Express
-1
votes
1 answer

Connect ssms 2012 using Windows authentication

How to connect ssms using Windows authentication. Do we need to create new servername using connection string? I saw different pages which haven't help me..
user4444053
-1
votes
2 answers

Copy single row from the table in SQL

I have to copy single row from the table on certain conditions. Suppose this is my table: ProductName ProductCount Isactive latest AA 1 1 1 Bb 5 1 1 Now, suppose I want to edit the first…
Hardik Parmar
  • 1,053
  • 3
  • 15
  • 39
-1
votes
2 answers

Error when creating sql database

I deleted manually sql database file(myDB.mdf and myDB_log.ldf) When I want to create database with same name (myDB) I get the following error message. System.Data.SqlClient.SqlException (0x80131904):Database 'myDB' already exists. Choose a…
koorosh
  • 1
  • 1
-1
votes
1 answer

Program works on local machine, but not on others [SQL Server localdb]

I've been creating a local off-line program in c#, following tutorials and learning as I go. I learned to create SQL Server databases and connect to them through the model first tutorial on MSDN. My application is working at the moment but only on…
-1
votes
1 answer

How to display the row value in a column into a single row

I have a few rows in a column as below: Country ---------- USA UK Singapore Now, I want to have result as below exactly: First_Country | Second_Country | Third_Country --------------+-----------------+-------------- USA | UK …
-1
votes
1 answer

Can't open SqlConnection to database

I'm new to asp.net and I was trying to make a simple login page that will search the username and password entered in a database. I created the App_Data folder and I have database in it called Database1.mdf. Inside that database there is a table…
ril2
  • 55
  • 2
  • 6
-1
votes
1 answer

Latest row for each combination of item and location

I have a table named IJ with a datetime column IJDATE, and varchar columns IJLOC and IJITEM. I need the most recent row for each combination of those two columns (and include the other columns, like IJLCGT, an integer, for the most recent row). So…
tsqln00b
  • 355
  • 1
  • 4
  • 20
1 2 3
26
27