Learn more about SQL Server tools

solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips

   Got a SQL tip?
            We want to know!

SQL Server Question and Answers

Ask a SQL Server Question

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

import word content into sql server
hi professor for example :i have a word file and its content is formula,text,image i wanna creat DB with them for instance i had 2colmns .one for image and one for formula and can search  thanks professor 

asked 10/20/2014 10:24:19 AM
by ehsan
0 answers

Export the table content into excel file
Dear All,   Kindly suggest to me. How I can export the table content into excel file or text file or csv file. Please suggest your answer.

asked 10/18/2014 1:32:25 AM
by Rakesh Kumar Jena
0 answers

Computed Column
Hi,   I have a View with 4 columns ID, DATE, SIGNAL, VALUE. This table is updated everyday for all signal Values. What I want is a Computed colums whose value is COMPVAL= SIG1VAL+SIG2VAL-SIG3VAL. The other SIGNAL types fro 4 to 10 say should reta

asked 10/17/2014 5:43:03 AM
by Ram KV
1 answers

Can not connecting database after installing Microsoft SQL Server 2008 Management Studio Express
Greetings  !! I have Windows XP SP3 operating system (having 32-bit operating system). After downloading "SQLManagementStudio_x86_ENU" from the link ( Normal 0 false false false EN-US X-NONE

asked 10/16/2014 1:59:02 AM
by Mahi
0 answers

Excel Graph from SQL Query
  On the recent webinar "10 Ways to Improve SQL Server Automation" there was an example of moving the results of a job timing query to an excel spreadsheet with graph.  How was this done?  Would be very useful.   Thanks,   Jo

asked 10/15/2014 12:08:14 PM
by John
1 answers

Hi, for the last week i see in the sql server monitoring tool (precies) that the "BRKR TASK" consuming larg amoumt of cpu resorces and cause an Internal waits. the actual text is "Text (N/A) Handle (0x0000000000000000000000000000000000000000) Command (B

asked 10/14/2014 10:47:10 AM
by itzik paz
0 answers

Need to recover access database with superior solution to fix access database errors
I have a task regarding access database. I and my organization is using access database  to maintain my access files in well mannered way. But due to varied reasons access file showing error message   Error 3112: Your access database got corru

asked 10/13/2014 3:02:41 PM
by MarshallBurns
1 answers

sql server
sir i created db already .nd it is in use ..........now the db is full nd my client says me to extend db without loosing previous data............is it possible.............. 2nd thing i created db nd a lot of table in db .......its again in use wid an ap

asked 10/13/2014 11:04:46 AM
by Amardeep Agrawal
2 answers

Teansfer stocks between warehouse in sql server database
Hi, I am developing an inventory menagemet system. I am using Visual Studio 2012 and MS SQL Server 2012. How can i Teansfer stocks between warehouses in sql server database. Thanks

asked 10/11/2014 3:39:37 AM
by Mahmut BİLİR
0 answers

Periodcity Options in Reports
  Hi ,     I have developed small accounting system for a Trader. Now i have created all the form to enter data like Purchase , Sale , Payment , Receipt etc. And after entering the data i have also built up customized report.

asked 10/9/2014 1:02:42 PM
by Sumit Kumar Malani
0 answers

Primary Key And Unique Key Requirement
1. If we are already having Primary Key why we need Unique Key? 2. Why we allow NULL to Unique Key? 3. Why Primary Key don't allow NULL?

asked 10/9/2014 12:15:14 PM
by Lokesh Shukla
3 answers

I need to truncate a first name in my SSRS 2008R report
The data in the software has first name and I want to truncate it to first initial only.  How would I go about doing that in SSRS 2008R?

asked 10/9/2014 10:01:58 AM
by Sheila Lindergren
0 answers

SQL server - Hot and Standby
Hi, We have a requirement of hosting a web application, backend SQl Server, in two physically separate server for redundancy and high availability requirment. We have installed the application and SQL server on two separate server (two licenses).  

asked 10/8/2014 8:52:54 AM
by Rasheed Abdul
2 answers

sql server
from "not exists" ,"left join" and "except" clause which is better and faster.... tell me with an example  

asked 10/8/2014 2:14:30 AM
by taj
0 answers

mssql server 2008 r2 creating a full backup from one server to another
I need to create a full backup weekly and a differential backup hourly from our production server to our failover server.  I have researched and can not find a detailed document on how to achieve this. I know how to create a full and differential bac

asked 10/7/2014 1:50:09 PM
by katty davis
2 answers

Full Text Catalog taking up all the disk space
We have created full text catalog and index for a pretty large table. The column on which the index is being created has a datatype of varchar(max). The problem started as soon as we started populating the catalog. It almost grew to 835GB and Population s

asked 10/7/2014 5:50:02 AM
by Saikat
1 answers

excel formula
Please I would like this excel formula to be translated into english so that I can be able to write similar in TSQl Language =BK3=IF(AND(OR(AND(AB4="Yes",AA4<>""),AB4="No"),OR(AND(AD4="Yes",AC4<>""),AD4="No"),OR(AND(AF4="Yes",AE4<>""),A

asked 10/6/2014 5:17:57 AM
by Chinedu
0 answers

Error "Invisible Datasource" : End Users are unable to connect to SSAS Cube from Excel on their PC
  I am connecting to analysis Services 2008R2 as a local host. I am the only one having analysis services install.   End Users are able to open Pivot Table on Excel 2013 from a cube I created on my PC, but when those End Users , I included

asked 10/5/2014 6:08:01 PM
by Ann
0 answers

Create Procedure to Keep Track of Last Changed Data
I have two tables: Member with Username,Password and LogMember with Username,Password,dateEdited. So can you help me create procedure with insert Member and when is updated to store the old data in LogMember and the new updated in Member.

asked 10/5/2014 11:46:20 AM
by John
0 answers

Having Trouble with use of CHAR(13) in select
I have this script and it will script all ddl server triggers to its own file. The problem is that in the script generated, I need to put some line breaks. I use CHAR(13), but it does not work. Can someone help please? Thanks in advance: declare @filena

asked 10/3/2014 1:20:56 PM
by Burhan
2 answers

Sponsor Information

Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | today's tip | first timer?
Some names and products listed are the registered trademarks of their respective owners.