Most voted "sql-server-2014" questions
58 questions
Sort by count of
-
0
votes1
answer1249
viewsCreate a Relationship Table (N:N) that relates to a Normal-Table and another Relationship-Table (N:N) in SQL Server 2014 Management Studio
I am trying to create this SQL Server Data Flock Script, but when I run the following error message: Msg 1776, Level 16, State 0, Line 161 There are no primary keys or candidates in the reference…
-
0
votes0
answers67
viewsWHERE failure when associating a query column in a view
I am passing some parameters to a view where I need to receive the return of this query. When setting the filters in the Where of my query, the return of the query informs the following error:…
-
0
votes0
answers28
viewsDeleting records from a very large table
We have a table on Sqlserver with over 154 million records and we need delete all records whose DTANO is less than 2017. But the bank is accessed via WEB and, of course, can not get stuck. Trying to…
-
0
votes1
answer49
viewsString Concat with Join Sqlserver
Good afternoon, I’m having a problem with creating a command line in SQL SERVER 2014 where it joins information from two tables in one row. I tried to use it that way SELECT DISTINCT SUBSTRING (…
-
-1
votes1
answer473
viewsDreamspark License - Can I use on more than one machine?
I have a license from SQL Server 2014 Enterprise and one from Visual Studio 2012 Ultimate, both obtained through Dreamspark. As I did not know that in the future I would need them on two machines, I…
-
-1
votes2
answers22
viewsNew procedure is not displayed in SQLSERVER
Follow the steps in doc in microsoft: https://docs.microsoft.com/pt-br/sql/relational-databases/stored-procedures/create-a-stored-procedure?view=sql-server-2017#SSMSProcedure I changed the…
-
-1
votes1
answer251
viewsHow to import a . sql extension file into SQL Server 2014?
I received a file that it has the . sql extension, so every time I import something into sql server is from .bak. Is it possible to do this? If yes, how?
-
-1
votes1
answer528
viewsPHP, XAMPP, Sql Server
Good night, you guys, I’m trying to connect php with sql server already have a couple of days, someone can help me ? It just shows this : Fatal error: Uncaught Error: Call to Undefined Function…