Best answeres tagged with sql-server

0

answers

SQL Server Agent 2012 starts and stops

I'm having this problem that I can not start SQL server agent 2012, I leave the details of my version of SQL: Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Enterprise Edition (64-...

asked by 01.08.2018 / 04:40

1

answer

Restore DataBase, SQL server 2008 R2 from Query

I want to do this by consulting according to the steps I was wondering, what would the Scrip query be for this SQL Server 2008 R2? eye without having previously the Mdf or the ldf on the hard disk before the restoration I mean I want the .bak to...

asked by 01.08.2018 / 01:44

0

answers

How can you fix this error?

I was installing the SQL SERVER 2014 on a computer from a university partner and to have everything ready I installed the LocalDB but gave me this error

asked by 29.07.2018 / 03:03

0

answers

SQL Server Transaction insert object list?

I would like to be guided, I have a stored procedure in a transaction that does the following: The Sales table has a trigger that triggers when the "ProductId" column is changed, this to record the changes made in the "Sales" table in a blog...

asked by 04.08.2018 / 02:01

0

answers

Why the error in syntax (SQL server 2008 R2)

the following query: DECLARE @ntp int, @jugador varchar (max)= 'Hola', @Player varchar (max) SET @Jugador = @Player EXEC @ntp = [PS_GameDefs].[dbo].[Command] @serviceName = N'ps_game', @cmmd = N'/ntplayer '+@Player+' '+...

asked by 07.08.2018 / 05:02

1

answer

How to detect an error in SQL Server 2008 R2

It's a question without a script because my doubt is direct. I need to update a Column whose data is X I want to convert it to Y but when I update it gives me the following error: Error converting Varchar to real. so this error occurs i...

asked by 29.07.2018 / 22:57

1

answer

How to paint table dynamically php sql server?

Good I would like you to help me I'm making them show my query of a column but it is dynamic is to say that some months appear and some do not, according to the range they chose in the form. Since I do not know which columns are going to be s...

asked by 26.07.2018 / 17:48

0

answers

Echo does not show a date when using echo

Hello inside my table I try to show in a table the value "high date" of a base in SQL server and its structure is this: when capturing the value as with any other of the same table and try to imrimir it is deconfigured all my table what do...

asked by 25.07.2018 / 00:00

0

answers

Does not recognize the as name with SQL Server and Laravel

I'm doing select of branch_id , month . What I try to do is count the date records. The problem arises when I do the DB::raw('MONTH(tic_date_in) month') , I do not recognize the as month in groupBy('month')...

asked by 24.07.2018 / 18:50

1

answer

Event TextChange only executes instructions inside else: c # and asp.net

I have 4 textBox, I make a query to my BD and depending on what is selected in a DropDownList I must execute a multiplication either Txt1 * Txt3 or Txt2 * Txt3 and show me the result in Txt4 . The method is the same for al...

asked by 24.07.2018 / 16:50

Questions tagged as 'sql-server'