sql-server-2012 Questions
6
Solved
I am trying to deploy an SSIS 2012 project to an SSIS Catalog on a newly built SQL Server machine. It throws an error with the following message whilst creating the folder.
Failed to create appdom...
Clinandrium asked 16/2, 2013 at 16:51
14
After installing SQL Server 2008, I cannot find the SQL Server Configuration Manager in Start / SQL Server 2008 / Configuration Tools menu.
What should I do to install this tool?
Embayment asked 23/3, 2012 at 18:40
7
Solved
I am trying to concatenate multiple columns in a query in SQL Server 11.00.3393.
I tried the new function CONCAT() but it's not working when I use more than two columns.
So I wonder if that's the...
Enculturation asked 23/6, 2014 at 16:40
2
Solved
When I create a Buyin object the response from the ASP.NET MVC controller, (return Json(response, JsonRequestBehavior.AllowGet);, looks like this:
"Buyin": {
"Id": 95,
"PlayerSessionId": 88,
"P...
Maurer asked 23/10, 2016 at 17:38
16
Solved
I am trying to access my hosting server’s database through SQL Server Management Studio, everything till login is fine but when I use the command use myDatabase it gives me this error:
The server ...
Vespid asked 25/9, 2013 at 15:47
8
I am normally using SQL Server 2012 Management Studio to restore a SQL Server database from a "bak" file. I do this by overwriting an existing database. In the "Options" page, there is a check-box ...
Suffer asked 26/9, 2013 at 13:33
5
Solved
I recently deployed a update to one of my SSIS projects, and ever since the project has failed it's scheduled runs.
The SSIS package appears to be stuck at the "Created Execution" status. There ar...
Bivalve asked 17/6, 2015 at 18:4
1
I am getting the following error in django model.objects.get_or_create.
SQLServer [FreeTDS][SQL Server]The data types nvarchar(max) and ntext
are incompatible in the equal to operator.
The column ...
Definitive asked 20/8, 2016 at 15:43
2
Solved
I have table contains three columns. If I select NVARCHAR(MAX) column in my select statement, I see poor performance. Is it possible to create index on a NVARCHAR(MAX) column?.
CREATE TABLE TEST
(...
Taryntaryne asked 13/12, 2018 at 16:58
4
Solved
Who can explain list of xp_Delete_file parameters in sql server. I don't find msdn document for this stored procedure.
I got script of xp_Delete_file from maintenance plan but didn't understand fi...
Riyadh asked 5/7, 2014 at 4:32
9
Solved
I am trying to port a query from MySQL to SQL SERVER 2012.
How do i write an equivalent for MySQL's substring_index()?
MySQL SUBSTRING_INDEX() returns the substring from the given string before a...
Fetal asked 25/5, 2014 at 11:18
6
I created SSIS packages and used the Integration Services Deployment Wizard to deploy it out to the server. I'm manually going to the Integration Services Catalog access through SQL Server 2012 and...
Foch asked 11/2, 2016 at 18:51
13
Solved
I have a 123MB sql file which I need to execute in my local PC. But I am getting
Cannot execute script: Insufficient memory to continue the execution of the program
How to solve this issue?
Coseismal asked 29/7, 2013 at 7:58
5
I am creating scripts of a SQL Server 2012 database because I cannot backup the database to a local drive. I understand how to create the script but at the end of the process the application seems ...
Ackack asked 13/11, 2015 at 18:46
12
Solved
I have a query in SQL, I have to get a date in a format of dd/mm/yy
Example: 25/jun/2013.
How can I convert it for SQL server?
Raphaelraphaela asked 20/6, 2013 at 4:44
3
Solved
I have a table in SQL Server with two numeric columns. At least one of these numeric fields must be filled. How do I write a check constraint to verify this?
Rudie asked 29/9, 2014 at 14:38
2
Solved
I know that it is easy to calculate simple moving average using SQL Server 2012 window functions and OVER() clause. But how can I calculate exponential moving average using this approach? Thanks!
Thereinto asked 14/4, 2013 at 2:19
18
Solved
How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed?
Pergrim asked 22/2, 2013 at 23:16
2
We have a C# multi threaded (100 threads) program which reads the records from the DB and each thread picks up one record (one Entity Framework connection per thread) and update the a single DB tab...
Rasmussen asked 13/2, 2015 at 13:47
16
Solved
I want to get all dates by declaring month and year in SQL server.
Can anyone please share easy lines of SQL code to get it.
For example:
DECLARE @month AS INT = 5
DECLARE @Year AS INT = 2016
SE...
Killoran asked 4/5, 2016 at 12:21
6
I have created a table in SQL Server 2012 with primary key as auto increment. But how can I remove that auto increment property from the table using a SQL query?
Beseech asked 7/5, 2014 at 7:22
4
Solved
The ORDER BY clause is invalid in views, inline functions, derived
tables, subqueries, and common table expressions, unless TOP, OFFSET
or FOR XML is also specified.
I am getting the above sa...
Proptosis asked 3/8, 2013 at 9:37
4
I have a table-valued parameter in SQL Server 2012 defined as:
CREATE TYPE [dbo].[TVP] AS TABLE (
[Id] [int] NOT NULL,
[FieldName] [nvarchar](100) NOT NULL,
[Value] [sql_variant] NOT NULL
)
I...
Arianna asked 3/1, 2013 at 22:30
7
Solved
say I have 3 values, Bill, Steve, Jack. and I want to randomly update a table with those values, e.g.
Update contacts
set firstname = ('Bill','Steve','Jack')
where city = 'NY'
how do I randomize...
Significance asked 12/5, 2015 at 19:45
5
Solved
Getting this error with the following query in SQL Server 2012.
An expression of non-boolean type specified in a context where a condition is expected, near 'RETURN'.
CREATE FUNCTION [dbo].[GetPM...
Athirst asked 29/5, 2014 at 8:6
© 2022 - 2025 — McMap. All rights reserved.