sql-server-2014 Questions
5
Solved
I'm trying to convert my Date which is (eg. 2012-04-20 05:54:59) format in into mm-yyyy. I came across some solutions that says you would need to convert into varchar . Is there any way using the C...
Immaterialism asked 3/3, 2015 at 22:6
4
Solved
I have use in model .
$data = DB::select('select * from users');
return $data;
But in controller I have got like this.
Array
(
[0] => stdClass Object
(
[Id] => 10
[Name] => Sachin
...
Memling asked 27/7, 2017 at 5:51
7
I have one table(Sql server 2014) with 60 million data. while fetching the data i am getting
"An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryExc...
Trillion asked 25/10, 2017 at 11:56
2
I started using Managed Backups on my SQL server. It has been working well for over a year. It seems to backup the dbs once a week, and take incrementals every 2 hours.
A month ago, we changed our...
Constrict asked 24/2, 2017 at 12:32
2
Is it possible to change the user account of the localdb instance in SQL Server? We changed our domain and it is using my old domain account so I can no longer login anymore. Also, I don't believe ...
Scales asked 28/11, 2016 at 19:23
2
I open my SSMS and right click on DB and then Tasks -> IMport Data to import data from a source but as soon as I click I get this error:
Failed to find or load the registered .Net Framework Dat...
Mordancy asked 8/6, 2017 at 14:40
8
Solved
I am using MVC 4 and entity framework 5.0, i have a database and this database contains 6 tables named as following.
tblUser_family
tblUser_location
tblUser_info
tblUser_photo
tblUser_settings
tbl...
Plainspoken asked 25/5, 2015 at 5:1
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
5
Solved
In our SSDT project we have a script that is huge and contains a lot of INSERT statements for importing data from an old system. Using sqlcmd variables, I'd like to be able to conditionally include...
Wilbertwilborn asked 10/5, 2016 at 16:1
2
Can anyone share the way how to find the column dependencies on linked servers?
For example: I have a stored proc with the definition
select column1, column2 from linkedserver.db.schema.table
s...
Smelser asked 17/10, 2018 at 15:28
2
Solved
In run Microsoft SQL Server 2014. Upon altering a table, I get a warning about the row size.
ALTER TABLE myTable
ALTER COLUMN aRandomColumn NVARCHAR(10);
Warning: The table "myTable" has been cr...
Gleet asked 3/12, 2018 at 13:32
1
Starting with SQL Server 2014 the default datasource in the Import and Export wizard is .Net Framework Data Provider for Odbc. Any idea how to change this?
Maggard asked 19/3, 2015 at 22:4
10
We migrated our servers from 2005 to 2014, User is able to delete it in the 2005 server
But in 2014 we are getting the error as do not have permission or does not exits
We have given to same permis...
Cleistogamy asked 7/4, 2016 at 16:43
5
Solved
Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?
In SSMS 2012, if I go to tools, it showed up in the list. In SSMS 2014, it doesn't.
I tried t...
Mixedup asked 25/4, 2014 at 21:5
5
Solved
I need to calculate how many orderlines there are based on the orderlineNo being distinct. Each OrderNo is different BUT the OrderLineNo is the same for each order.
i.e. 9 lines on a order then ord...
Pairoar asked 17/7, 2015 at 14:28
7
I have Windows 10 build 1511, where I have installed SQL Server 2014.
After installation everything is OK.
I've made several times shutdown on Windows 10, and after if I turn on my PC everything ...
Intelligence asked 14/1, 2016 at 18:41
4
Solved
I tried the following query to select the number of groups resulting from a GROUP BY query:
SELECT count(*)
FROM (
SELECT count(*)
FROM MyTable
WHERE Col2 = 'x'
GROUP BY Col1
)
Unfortunatel...
Kent asked 26/11, 2015 at 8:48
3
I have an application connected to a SQL Server 2014 database that combines several rows into one. There are no other connections to this database while the application is running.
First, select a...
Thrasher asked 14/11, 2016 at 9:25
6
When I right click on the indexes folder in the table the "New Index" menu item is grayed out. I don't understand why. I've deleted all data in the table just in case, and refreshed and restarted S...
Overflight asked 18/11, 2012 at 18:44
10
I have a problem with this trigger. I would like it to update the requested information
only to the row in question (the one I just updated) and not the entire table.
CREATE TRIGGER [dbo].[after_...
National asked 29/8, 2014 at 12:41
6
Solved
I'm trying to write the following in order to get a running total of distinct NumUsers, like so:
NumUsers = COUNT(DISTINCT [UserAccountKey]) OVER (PARTITION BY [Mth])
Management studio doesn't s...
Joshuajoshuah asked 26/6, 2012 at 7:48
5
Solved
I am using SQL Server 2014 and want to know how to check my active transactions?
Toile asked 12/8, 2015 at 7:14
2
Solved
From this SO answer a view should provide the same performance as using the same query directly.
Is querying over a view slower than executing SQL directly?
I have a view where this is not true.
...
Nat asked 1/7, 2018 at 19:9
4
Solved
When publishing a dacpac with sqlpackage.exe, it runs Schema Compare first, followed by pre-deployment scripts. This causes a problem when, for instance, you need to drop a table or rename a column...
Rajah asked 1/9, 2015 at 11:41
4
I have the following string:
1119/2/483/11021
I would like to reverse the order of the elements in that string. Desired output:
11021/483/2/1119
T-SQL Version 2014
Wonted asked 12/10, 2021 at 12:51
1 Next >
© 2022 - 2024 — McMap. All rights reserved.