Use this tag for questions specific to scaled down, free edition of SQL Server 2008 R2.
Questions tagged [sql-server-2008r2-express]
223 questions
0
votes
1 answer
SQL Server 2008 R2 Express - no option to create new DB - what I am I doing wrong?
I would like to create a new database in SQL Server 2008 R2 Express using the Management Studio, but there is no option for New Database... I searched online and all the tutorials show this option that I don't have. What step am I missing? The…
user1553309
- 281
- 1
- 3
- 8
0
votes
3 answers
# splitting the string dynamically in sql server 2008
I have a string like this:
","","","41","20120627063343-0210600-41"
I wrote my query like this to split the above string
declare @s varchar(max)
set @s = '","","","41","20120627063343-0210600-41"'
select right(replace(@s,',',''),26) as…
user1444281
- 39
- 2
- 6
0
votes
3 answers
What SQL syntax is this?
Can anyone tell me what SQL syntax this is please where 123 is the argument passed to the SP?
EXECUTE sp_MyStoredProcedure = '123'
When executing this command the error message from MSSMS is
102, Level 15, State 1, Line 6
syntax near '='.
We…
SkeetJon
- 1,491
- 1
- 19
- 40
0
votes
1 answer
connecting to remote sql express server
I have a program running with an EF model in c#. when running the app from my local computer everything runs great but when installing it on a different computer in my network it immediately stop responding. i noticed that after adding the specific…
Yoav
- 3,326
- 3
- 32
- 73
0
votes
1 answer
SQL Server speed up query with not in
I have a table called sales with the following few columns:
salesno (PK, char(25))
advanceno (char(15), not null)
Now I want to select all the rows where salesno is not in advanceno:
SELECT salesno
FROM sales
WHERE salesno NOT IN (SELECT…
kelvinfix
- 2,915
- 8
- 37
- 49
0
votes
1 answer
sql server 2008 r2 wmi connection error [0x80041010]
I am using sql server 2008 r2 and it was working fine but after restarting my computer it's not working , I tried to open configuration manager but it give me this error:
Cannot connect to WMI provider. You do not have permmission or the server is…
Ahmed Kato
- 1,697
- 4
- 29
- 53
-1
votes
2 answers
SQL exceptions for specific error conditions
I want to know SQL exception (state) for the
"Duplicate Error Record"
"Null Value"
What are the sql exception (state) for above ?
Any suggestion
enum FilterMode
{
System_AllData = -1,
System_Error = -2,
…
Jones
- 3
- 2
-1
votes
3 answers
How to run distinct and Sum in one query in sql server 2008 R2
I have a table #1 as shown in image attached. First i want to sum all quantity of all distinct id. Then want to show number of id that have same quantity.
Jani Mani
- 27
- 6
-1
votes
1 answer
SQL Server 2008 R2 Express ODBC - Not showing database
Created a new database called Test, when I try to connect to the SQL Server database via Excel I can't see the Test database which was created, I can only see master, msdb, tempdb.
I'm running SQL Server 2008 R2 Express.
I am new to Server…
-2
votes
2 answers
How to drop a constraint
Using SQL Server 2008
Table1 has a constraint with the name idx_u_customerinfo.
I deleted table1 directly (right click delete), I wrote a script for creating the table1 with same constraint name idx_u_customerinfo.
I'm getting an error
There is…
Gopal
- 11,712
- 52
- 154
- 229
-3
votes
3 answers
how to fix this below error?
connected successfully..
Notice: Undefined index: blog_id in C:\xampp\htdocs\lendkarma\dashboard\editpost.php on line 3
Notice: Undefined index: empid in C:\xampp\htdocs\lendkarma\dashboard\editpost.php on line 5
Notice: Undefined index:…
Binny Yogesh Sg
- 7
- 1
- 9
-4
votes
1 answer
How to concatenate items having same Id using STUFF
I have three tables as follows:
OrderProductVariant
Id | ProductVariantId
----------------------------------------
1 | 22
2 | 23
3 | 24
4 | 25
ProductVariant
Id | ProductId
----------------------------------------
22 | …
Mubashir Siddique
- 11
- 1
- 1
-4
votes
2 answers
Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query
alter table Garantor alter column [Birth Date] int
Burak KÜKRER
- 69
- 2
- 6