Learn more about SQL Server tools

   
   


















































SQL Server Question and Answers

Ask a SQL Server Question

Search All Questions:
SQL Server Questions And Answers
<< Previous Page        Next Page >>

Building a link from SQL Server 2008 to Access

asked 11/20/2014 5:56:56 PM
by Donald
0 answers

SQL Query to calculate OnPeak & Off Peak total for a month and find the highest max onPeak & Off Peak hourly value for that month
Could someone help me with a SQL query to calculate the total on-peak and off-values for a month as well as the Max/highest on-peak/offPeak hourly value for that month.   On a daily basis i store the hourly values of the meter in a SQL table. &nbs

asked 11/20/2014 8:45:07 AM
by Shiva
0 answers

how to convert 3 column table into 2 column table
I have a TableA with 3 columns, Column1, column2, column3; and I want to convert it into 2-column TableB. If Column2 & Column3 in Row N of Table A is not Null, I want TableB like this: Row N,       Column1, Column2 ;

asked 11/19/2014 9:24:47 PM
by vivian
0 answers

SQL 2012/2014 time zone query
Hello,   Wee have an application that uses an time zone table that hold different part of the world info: Time_id TimeZoneName--(GMT) Casablanca, Monrovia gmt_offset--60 daylightSaving_offset--60 TimeZone_code---W. Europe Standard Time I need

asked 11/19/2014 7:36:48 PM
by Rick
1 answers

regarding delete
hi , can you suggest a query to view only the deleted row or column from the table.  

asked 11/19/2014 2:50:30 AM
by sarath
0 answers

Database Security
    In sql server 2005 database i have stored proc which creates a table, create a view for that table and grant select on the view created to a role.   Can someone please explain what privilege should the us

asked 11/18/2014 8:44:14 PM
by CreditingAtom
0 answers

t-sql 2012
  im a begginer in t-sql.. so please let me know indetail about reporting services and how to transfer the database from one location to another locatio by using datafiles

asked 11/18/2014 11:08:49 AM
by lakshmi
1 answers

How Do I Alpha-Numerically Sort Solution Items in the Solution Explorer
I've been able to find various workarounds but I'd like to know if there's anything more current than setting the sort value to false. Failing that, is there a way to achieve my goal through T-SQL?

asked 11/12/2014 12:04:32 PM
by Jason
0 answers

Application pointing to Mirrored Database Automatically.
Hi all,We just upgraded our client with .net 4.5 I believe or .4.0 and the main database it makes a call is part of mirroring and for some reason the application is freezing up or timing out and when I requested App developers to provide me with the app l

asked 11/11/2014 11:33:39 AM
by Khaja
0 answers

SQL 2005 installation on Windows 7 64bit
I am in process of installing SQL Server on Windows 2007 64 bit, But not able to do that, Request your assistance step by step will be highly appreciated Thank you

asked 11/11/2014 8:02:26 AM
by Ali
1 answers

oracle to sql server 2008 migration
insert into tbl select        Id, Level from   viw where  Active = 'Y' connect by prior viw.Id = viw.sId start with viw.sId = @p_Id

asked 11/11/2014 7:09:13 AM
by taj
0 answers

Equivalent to Compiler Options in T-SQL
I have a database running for some customers under SQL 2012 and for other under SQL 2014 for 2014 I wan't to use in memory tables and - where possible - native compiled procedures to access them is there a way to write the CREATE / ALTER Procedure fun

asked 11/11/2014 4:15:02 AM
by Thomas Franz
1 answers

Want to create a trigger to insert numeber by incrementing by one
  HI,    I want to create a trigger which will create my number by if it finds the duplicate number. In my system I am inserting data through multiple user .when 2 or more user tries to save at the same time then the number felid gets

asked 11/11/2014 1:42:22 AM
by DEVENDRA
3 answers

Can we configure a cluster enviroment between these two servers Server -A(DATACENTRE1) Server-B(Datacentre2)
hi  I faced this question in an interview   Can we configure a cluster enviroment between these two servers Server -A(DATACENTRE1) Server-B(Datacentre2) Server -A has A,B,C Drives Server -B has D,E,F Drives     if yes need so

asked 11/10/2014 10:54:04 PM
by Sandeep
1 answers

Is it possible to replicate a linked server object
I have a SQL Server 2008 R2 Enterprise linked server object that points to our legacy database.  Currently we execute a stored procedure each night that physically deletes and recreates the tables from the linked server tables each night to a separat

asked 11/10/2014 4:47:17 PM
by Sue
1 answers

I have a SQL Server 2008 R2 Enterprise linked server object that points to our legacy database. Currently we execute a stored procedure each night that physically deletes and recreates the tables from the linked server tables each night to a separate sql server database (I know, I didn't set this up, don't shoot the messenger :) ). Now our users are looking to have their data more up to date than as of 2am each night (of course). Not only that but none of the current tables that are deleted

asked 11/10/2014 4:10:44 PM
by Sue
0 answers

A connection was successfully established with the server, but then an error occurred during the pre-login sandshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error:233
Dear all,  I can.t login Sql server 2005 enterprise sp3 showing "A connection was successfully established with the server, but then an error occurred during the pre-login sandshake. (provider: Shared Memory Provider, error: 0 - No process is on the

asked 11/10/2014 2:02:21 AM
by Subhamay Chatterjee
0 answers

How do I display result in Sql server
I am using Sql server 2008 and want to display result in Asp.net Front End. I am a fresher.Please help.Thanks in advance.   CREATE TABLE dbo.TestInsertState (   Id INT,   AppliedFor INT,   EntryDateTime DATETIME,   bUpdate

asked 11/9/2014 11:16:40 AM
by bubai
0 answers

sql server connection problem in visual studio 2012
when i'm trying to add a .mdf database file visual studio 2012 (ultimate) shows this error message.please help me to solve it out.i have already tried all the possible ways but all in vain.

asked 11/7/2014 4:06:00 PM
by Shovon Habib
0 answers

While doing the Job monitoring part in MS SQL, if the job success also, it is triggering mails. Could anyone please suggest how to respolve this. The query is given below. Thanks in advance
Hi,  I am doing a monitoring project for MS SQL. While doing the Job monitoring part, if the job success also, it is triggering mails . The query that i am using is given  below. Could anyone please verify it. Thanks in Advance------------------

asked 11/7/2014 1:49:24 AM
by kalesh SR
0 answers


 
Sponsor Information