sql-server-2014 Questions
3
Solved
I've been successfully publishing DACPACs to SQL Server 2008-2012 instances using SqlPackage.exe, as installed by SQL Server Data Tools (and typically found in C:\Program Files (x86)\Microsoft SQL ...
Quenelle asked 29/4, 2014 at 21:36
7
i have table having four columns like this below
Table - subscription having data like this
part_id subscription policylicense enterpriselic
part1 sub1 null null
part2 sub1 pl1 null
part3 sub...
Banket asked 3/11, 2017 at 11:24
3
Solved
For a few days, I've been struggling with improving the performance of my database and there are some issues that I'm still kind a confused about regarding indexing in a SQL Server database.
I'll ...
Quaff asked 16/10, 2017 at 9:16
4
Solved
Lets say you have the next code:
DECLARE @A INT = 1,
@B INT = NULL;
IF (@B != @A)
SELECT 1;
ELSE IF (@B = @A)
SELECT 2;
ELSE
SELECT 3;
As you can see variable @A equals '1' for sure and var...
Turbot asked 12/8, 2015 at 11:9
3
Solved
I am trying date control by month with this script
DECLARE @Date DATETIME = '2015-07-31';
DECLARE @MonthCount INT = 3;
DECLARE @controlDate DATETIME = '2015-04-28';
SELECT
MONTH(@controlDate),
...
Warhead asked 27/7, 2015 at 9:33
2
I have following queries:
DECLARE @application_number CHAR(8)= '37832904';
SELECT
la.LEASE_NUMBER AS lease_number,
la.[LEASE_APPLICATION] AS application_number,
tnu.[FOLLOWUP_CODE] AS note_type...
Beldam asked 6/9, 2017 at 7:29
2
Solved
I have a stored procedure where there are no header comments. I want to add them, but whenever I try, it is not included.
In SQL Server Management Studio I :
1.Right-click my stored procedure and...
Eyeshade asked 21/8, 2015 at 13:8
3
Solved
I have this problem in my SQL code:
I will only show my WHERE clause, because it is a bit long,
this is it:
where
((@account_status = 1027 AND a.AccountStatus = 1027 AND a.FolioNo =
@folio_no...
Fugal asked 4/9, 2017 at 6:21
2
I try to implement a search-mechanism with "CONTAINS()" on a SQL Server 2014.
I've read here https://technet.microsoft.com/en-us/library/ms142538%28v=sql.105%29.aspx and in the book "Pro Full-Text...
Adapter asked 25/2, 2015 at 8:57
3
I am experiencing some strange behavior in SQL Server when working with decimal and numeric data types. I have a formula that calculates a specific value (4.250), and I'm using the same rounding an...
Musset asked 17/8, 2017 at 7:48
3
Solved
I'm tapping into a SQL Server 2014 database using SSRS 2014. I've used SSRS from its initial release but have never experienced this problem so I don't know if its a bug in SSRS 2014. I have a stor...
Drew asked 8/4, 2015 at 13:24
5
Solved
How would I use a WHERE and WHERE NOT in the same SELECT SQL query?
For example, I could have a table called fruits.
ID | Name | Colour
-------------------------
1 | Strawberry | Red
2 | Apple |...
Ligule asked 3/8, 2017 at 14:17
3
Solved
Forgive me if this question was already asked before.
I just installed Microsoft SQL Server Management Studio 2014. I want to create a database so I can start building some tables from scratch. Al...
Bookstand asked 29/5, 2015 at 12:59
2
Solved
I'm trying to install SQL Server 2014 but it stays in the same spot (Install_VCRuntime_Cpu32_Action) for hours. It's already the third time I'm trying to install so I don't know what else to do.
S...
Tableland asked 1/11, 2016 at 0:38
1
What is the difference between these scripts?
ALTER TABLE Post_Send WITH NOCHECK CHECK CONSTRAINT [My_FOREIGN_KEY];
GO
ALTER TABLE Post_Send CHECK CONSTRAINT [My_FOREIGN_KEY];
GO
Hillier asked 17/7, 2017 at 9:15
1
Solved
I have a persisted computed column which calls a Scalar Valued Function. As you know, this function needs to be deterministic in order to persist the value. Even if REPLACE function behaves in a de...
Merkle asked 21/6, 2017 at 11:22
1
I have a problem in Arabic Full Text Search in SQL-Server, this link says that we can use Arabic in full text search.
To describe more, I've enabled full text search on one of my columns which con...
Masthead asked 20/6, 2017 at 4:35
5
Solved
I have a problem with SQL. I have the following table:
declare @t table (START_DATE datetime,
END_DATE datetime,
GROSS_SALES_PRICE decimal(10,2)
);
insert into @t
values ('2014-08-06 00:00:0...
Helot asked 6/6, 2017 at 14:40
3
Solved
Q: How can I rank records based on 1 column's changing value?
I have the following data (https://pastebin.com/vdTb1JRT):
EmployeeID Date Onleave
ABH12345 2016-01-01 0
ABH12345 2016-01-02 0
ABH1...
Tweed asked 3/6, 2017 at 13:58
3
Solved
I'm trying to get an incrementing counter within a set of results.
For example, assume I have a messages table:
messages
--------
- id (int)
- user_id (int)
- sent_at (date)
- body (text)
I'd l...
Pleo asked 2/6, 2017 at 20:57
5
Solved
I have installed SQL Server Management Studio 2014. In "connect to server" window, I selected server type as "Database engine", server name as "(local)" but when I try to connect, n error is shown-...
Edwardoedwards asked 31/12, 2013 at 4:39
3
Solved
I have a puzzle with regards to the behavior of the SQL Server Management Studio.
I am connected to a SQL Server database - version:
Microsoft SQL Server 2014 (SP1-CU3) (KB3094221) - 12.0.4427.24...
Magog asked 16/12, 2016 at 15:45
1
Solved
We are using SQL Server 2014. We have one database with the size of 12 GB.
I used the following query and can see the file sizes as:
SELECT ((size * 8)/1024), *
FROM sys.sysfiles
This shows the...
Pierette asked 26/4, 2017 at 13:20
1
Solved
Is it even possible to import .csv flat file data into a SQL Server 2014 table using only the SSMS or SSIS Import/Export Wizards, if the table contains a varbinary(max) column?
I have searched hou...
Mutz asked 23/4, 2017 at 16:28
3
Solved
I would like to do a silent install with /qs command to install sql server 2014 express. I did many installations with 2008 express and it did not have this kind of issue.
When I try to install, b...
Tiptoe asked 18/2, 2015 at 21:20
© 2022 - 2024 — McMap. All rights reserved.