Hi
How to get the column header for the export file using BCP
I tried with the follwoing :
CREATE VIEW VW_INV_CO_APAC_EXTRACTION
AS
SELECT 'i_invenory_id' as i_invenory_id,
...
How to find Size of Each Table in Database?
Something like TAble1 = 345Kb
Table2 = 3MB
Something like that.
I have a SQL table, and I am using T-SQL. I have one table with some null values in one of the columns. I want to replace the null values with zeros. I am using this query:
Use Energy_Db
U...
Hi,
Using SQL Server 2005 w/ SP2 I have a simple select query with a parameterized WHERE clause that in Management Studio runs nearly instantly, everytime. Using the same login, when I run th...
Hi Exports,
I am newly install MS SQL SERVER 2005 SP2 Enterprise Evalution Edition Sucessfully.
Now My proublem is Creating Maintaince plz right click the Maintaince New Maintaince it w...
using front end access 97 and back end sql 7.0, i'm trying to convert access sql to t-sql stored proc.
below is one field of the SELECT clause, problem is that instr is not a recognised fn no...
Hi, I need help in calcullating a percentage in sql using sql server 2000.
For example, I have a column:
column
red
red
red
blue
orange
green
and have an output
column column...
Hi All,
I have a table called [b]Table1[/b].
I have a (nvarchar) field called [b]ProductID[/b]. The records in this field is numeric. The length of each record in this field is different. ...
As you know the daylight saving time will be changed on March 11, 2007.
I read the following "Preparing for daylight saving time changes in 2007" article from microsoft website:
http://www.m...
Greetings,
I am looking for how to get the following 6 date ranges:
1) This week (first day(su), last day(sa))
2) Last week (first day(su), last day(sa))
3) This month (first day, last...
Hallo experts.
I want your help to fix my problem.
When i try to insert in a db table (t_artikel) i have the following error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC D...
Hello all,
I am writing a VB application, and am storing dates. VB has default to the date format DD/MM/YYYY, which I prefer and I suspect has something to do with my localisation settings...
I have a database with a many to many relationship between Funds and Fund Managers, for a specific report I need to get all the funds in the database and their fund managers, but only 1 row fo...
Will running a defragging tool on a SQL Server adversly affect the data on it?/What is the proper way of defragging a sql Server?
I'm trying to write my first ever stored procedure and I get an invalid obect name 'dbo.spRPT.rptSLR_Imprt_LC' when I try to run it. I have pasted my stored procedure below. What am I missin...
I'm moving to Reporting Services after working in Access for a few years. I need to concatenate an Address field on a report, stored in the database as separate fields (Number, Predirectional,...
Hi experts
I got the following error when I tested emailing to the operator in Sql Server Agent.
"Error 22022 : SQLServerAgent Error. The SQLServerAgent mail session is
not running; che...
Hi,
We have a server with sql 2000 installed on it. The server is installed in mixed mode. The only thing we have forgotten to document is the sa - password. Is there anyway to retrieve th...
hi,
how do i go about in including an if condition in my select statement?
i would like something like the one below:
select iif(install_date = 'Jan 1 1990',"",install_date) from devi...
Good morning Expert,
I am trying to create a dev/prod web site pair. The web site hits a
database called Nextrac_2. It works well in prod. I xcopied the
web site into the dev web site. Ge...
Hi,
I'm trying to fill a variable with the current date + 2 hours.
the problem is that I want the minutes and the seconds to be 0.
What I succeeded to do is increasing the date with 2 hou...
I have two Columns that I need to take the Max value of and limit on the higher of the two.
I was trying to do this:
SELECT MAX (COLUMN1, COLUMN2) AS EXPR1
FROM TABLE
WHERE EXPR1 > 100
...
I'm using VB.NET with SQL Server 7.0 as the backend. I'm trying to execute a Stored procedure from .NET using command object like this. the stored proc runs perfectly well in the backend but ...
I have a table that gets created and currently the table is not keyed because there are duplicate records. How do I delete just the duplicates?
Here's the code to find the duplicates and I...
SQL Server Agent will not start on SBS2003 Premium. Error 1069: The service does not start successfully because of a log on failure. I did the research and found MS KB28254 http://support.mic...
