Questions tagged as 'sql-server'

Tagged questions
3
answers

BD Results Count for Paging

I have a problem, I want to know how much data there is in the database, but with this code is returning -1 already used this code for other jobs (only with mysql), in this case is with SQL Server $pag = (isset($_GET['pag'])) ? strip_tags((i...
asked by 26.05.2015 / 15:50
1
answer

Remote procedure call failed. [0x800706be]

After you install SQL Server 2008 R2, access the SQL Server Management Studio but the server name does not appear and the SQL Server Configuration Manager services are not active.     
asked by 26.05.2015 / 14:48
1
answer

Optimize printing of large SQL Server results through ASP

Today I have a classic ASP page with an unconventional chain-select (read "armengado") that returns a populated select with some data from a sql-server (2005) database. I select the building and return the number of skill floors for delivery...
asked by 06.05.2015 / 13:35
2
answers

How to mount a select that brings information of which column is PK, which is not, and what is FK

I need a TSQL that brings me some table information data like which column is IS_NULLABLE , COLUMN_NAME , and so on, but I came across a problem, I can not bring a column in a CASE WHEN which says that such a column is PK, w...
asked by 17.06.2015 / 03:12
2
answers

The requested .Net Framework Data Provider could not be found. Sql Server + Entity

I'm having trouble connecting to my local bank. This is my View , where I try to connect the bank using Razor: @{ ViewBag.Title = "Index"; Layout = "~/Views/Shared/_LayoutOuvinte.cshtml"; var db = Database.Open("Entities"); v...
asked by 16.03.2015 / 22:38
1
answer

Querying using between with sql server 2005

I am making a query using the Between operator to select a date range in the SQL Server 2005 database. Below are the data from the Servico table: linha1: 2015-02-04 14:51:01.577 linha2: 2015-02-04 14:51:02.137 linha3: 2015-02-04...
asked by 04.02.2015 / 18:17
1
answer

How to get bank reports through web application?

Where I work there are some procedures in the database (SQL Server 2008) that take hours to execute and return large amounts of information that are always copied to a worksheet and sent to the end user. There are even some desktop applicatio...
asked by 23.01.2015 / 15:23
2
answers

Multiplications contained in texts

How to make the multiplications contained in a varchar field? (to get the area in case) +------------------------------------------------------+ | DESCRIÇÃO | +---------------------------------...
asked by 20.02.2015 / 18:24
1
answer

How to check if a view exists before having it created?

Take the following view as an example: CREATE VIEW vw_types AS SELECT codigo AS code, nome AS description, abreviacao AS abbreviation, statusRegistro AS status FROM tipos How can I have it created only if it does not ex...
asked by 24.02.2015 / 14:14
1
answer

How to put a SQL command in a variable

I have a following command in SQL and I need to put it inside a variable in SQL. That's the code. WITH DB_CPU_Stats AS (SELECT SUM(total_worker_time) AS [CPU_Time_Ms] FROM sys.dm_exec_query_stats CROSS APPLY (...
asked by 17.12.2014 / 17:49