Export a store procedure to XML file?
I created a store procedure, getOrder, to select data.
How to export "getOrder" to a xml file in d:\order?
--
Message posted via http://www.sqlmonster.com
| | 0 | 0 | 1 min. 57 sec. ago |
sp_send_dbmail
HI,
I'm running SQL2008. I have an internal website that log's onto the SQL
server using SQL login. I have tried sending an email using Sp_send_dbmail
with no attachment ant i | | 0 | 0 | 1 min. 58 sec. ago |
Online Pharmacy, Discount Drugs Online, No Prescription Drug .
Pharmacy Online provides Brand and Generic medications such as viagra,
cialis, levitra, clomid, evista, fosamax, propecia, allegra, kamagra,
zyban. Buy generic medications. Worldwide Shippin | | 0 | 0 | 1 hours ago |
Script to grant Permission
Hi,
How can I grant a read/write permission to a User for only two tables (a,b)
in a database ?
Thanks in advance
Suresh
--
Message posted via http://w | | 0 | 0 | 4 hours ago |
Backing up data between SQL Express 2005 and SQL Server 2008 Standard Edit ion
Hi,
I am developing an application which needs to backup data between SQL
Express 2005 and SQL Server 2008. My client runs with an installation
of SQL express 2005 and needs to pe | | 0 | 0 | 4 hours ago |
SQL Server Views - Missing Column Names ???
Hi there,
I have a local SQL Server (2008) on which I created a Linked Server
(to another SQL Server 2008 box).
The problem I'm having is that whenever I create a View again | | 0 | 1 | 7 hours ago |
14 byte date/time in file name
Hello everyone,
Anyone know how I can be guaranteed a 14 byte string from this sql code:
SET @outputfile = ltrim(DATEPART(year, GETDATE()))
+ ltrim(DATEPART(month, GET | | 0 | 0 | 7 hours ago |
Making content more readable -- please help!!
Hi,
I want to write an sproc that I can run on a particular column of a
particular table that takes the contents of the row and uppercases
every first letter and lower case | | 0 | 0 | 7 hours ago |
Partition Range Script
I am partitioning by a date column in SS 2005 SP3. So I ran my script and
create partitions and all is well. However, I can't find the nifty query
that I ran across that the max/min date | | 0 | 0 | 7 hours ago |
milliseconds in datetime variable.
Hi,
I am wondering how to compare 2 datetime values so that milliseconds are
taken into account.
as an example I have the following script.
it appears that | | 0 | 0 | 7 hours ago |
creating table on secondery filegroup
hello there
i have database with two filegroups and for each filegroup there is diffrent
file name
How can I use Select .. into and create new table on secondery filegroup? | | 0 | 0 | 7 hours ago |
Sql Server on VMWare
Hi,
Can anybody give me some right direction or usefull link
1. About VMware environment
2. How to Install and configure Sql Server 2005 on VMware.
3. Is there any performanc | | 0 | 0 | 7 hours ago |
Free Tools for SQL Server - SQLsoft.co.uk
Hi All,
We've written a number of (I think!) handy tools over the past few
months which are available from here: http://www.sqlsoft.co.uk/
Newly released is SQLscripta, whic | | 0 | 0 | 7 hours ago |
Transaction load
Hi there,
I have an app that needs to upload a lot of files into my DB, where each
file will typically be perhaps 400K but can max out at 16MB (though that
would be very rare). | | 0 | 0 | 7 hours ago |
Modify statement to run sp_executesql
To learn sp_executesql, I create a small code. It works fine as below.
CREATE TABLE [dbo].[#A](
[authno] [nchar](10) NULL,
[Authname] [nvarchar](50) NULL
) ON [PRIMARY]
| | 0 | 0 | 7 hours ago |
SQL 2008 - FILESTREAM OpenSQLFilestream invalid handle
SQL 2008 Express running in Virtual PC on Windows XP Pro, accessed from a
"real" machine with Windows XP Pro via TCP/IP and sql authentication (the
server has enabled mixed mode) | | 0 | 0 | 7 hours ago |
Database Table Design
I have a [user] who belongs to a [group] and writes an [article] using a
certain [computer].
The user can move to a different group and a computer can be assigned to a
different perso | | 0 | 0 | 7 hours ago |
SSIS hitting FK violation - need to ignore the error rows - have package s ucceed
I'm using SSIS and i'm getting a FK violation in my OLE DB Destination
task. I'm getting a FK violation and would like to ignore any rows
(throw them away) where the error is encountered. | | 0 | 0 | 7 hours ago |
Output only 255 characters
I have a stored procedure that builds insert statements for the table I
pass.
This procedure works perfect at my office. But at my client site, it doesn't
seem to work correctly | | 0 | 0 | 7 hours ago |
Date Range
Newbie. I can not seem to figur out the DATEDIFF. I have a simple Select
Select * from Table Where Date = > (1st day of LAST year) and Date <= (Last
Day of LAST year).
< | | 0 | 0 | 7 hours ago |
Call for speakers for LinkedData Planet (June 17-18, 2008 in New York City)
| | -1 | 60 | 2/15/2008 3:11:03 AM |
Strange control-of-flow problem in T-SQL
I cannot figure this out. If you run the following code to create a test db
and add a table, such as:
CREATE DATABASE dbtemp;
USE dbtemp;
CREATE TABLE [application] (
c1 INT | | 7 | 67 | 2/6/2008 8:12:03 PM |
Book on schema design
Can anyone recommend some good books on schema design? I have read through
a buch of threads in this forum and see a pattern of bad design issues which
seem to crop up. I am looking for a | | 1 | 79 | 2/6/2008 8:08:32 PM |
Need help with a query
This is a multi-part message in MIME format.
------=_NextPart_000_000A_01C868C9.C22C56A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printabl | | 3 | 70 | 2/6/2008 8:03:35 PM |
Finding similar company names in table
I have a table of client companies (Create Table Query given below), mainly
law firms, actually. The same
firm may occur several times because of various locations, etc. The
complicating | | 0 | 74 | 2/6/2008 8:03:21 PM |
Help with basic Group By mis understanding please
I am using a book which doesn't give the clearest of explanations and
wonder if someone could clear this up for me.
Select SalesPersonID, TerritoryID, Count(*) from
Sales.SalesOrderHe | | 4 | 62 | 2/6/2008 7:39:11 PM |
DateTime, Date and Time?
Is there a reason sqlserver doesn't have a Date and a Time datatype? I can
kind of see why there is no Date data type but why not time? Are they trying
to future proof sqlserver by not locki | | 17 | 78 | 2/6/2008 7:11:54 PM |
search between strings...
Hello.
I have to some data i'm pooling from a table that has special chars like (<,
% ,>) I need help help extracting the data and eliminating the chars.
e.g. this is a | | 5 | 73 | 2/6/2008 7:11:04 PM |
table naming convention confusion
am learning sql server 2005 using sql server 2005 express and the
book beginning c sharp 2008 databases from novice to professional.
I'm using the advertureworks database, and notice tha | | 3 | 73 | 2/6/2008 6:59:07 PM |
Dynamic SQL execute as calling user?
I have a sproc that I want to use dynamic sql for (i have my reasons) and
this is in SQL Server 2005 with the latest service pack... I noticed you can
do
EXEC(@sqlstatementhere) AS | | 3 | 69 | 2/6/2008 6:34:08 PM |
SQL data type question
I'm looking at a conversion table between sql data types and .net data
types. I don't understand what a few of the sql datatypes are and where/how
they would be used in sql server.
| | 1 | 71 | 2/6/2008 6:31:40 PM |
Is Celko really Chuck Norris of the SQL World?
After many years on this forum I never get tired of Joe Celkos comments, they
are usually arrogant in the extreme but kinda funny too.
So to parody the Chuck Norris jokes...
Cel | | 3 | 69 | 2/6/2008 6:22:54 PM |
row level security
I need to restrict access to reporting tables based on row level criteria.
Depending on the geographical location, a user should be allowed to query
data against tables for their own geograph | | 2 | 64 | 2/6/2008 6:19:01 PM |
One to One relationship
Hi, I have a table called provider, which contains the following column:
CompanyName; CompanyID; C; D; E; F; G. Column CompanyName and Column
CompanyID should be one to one relationship, me | | 5 | 72 | 2/6/2008 5:57:49 PM |
ANSI_PADDING deprecated?
Hi,
A question to the SQL Server architects @ Microsoft:
I came across in the section on SET ANSI_PADDING in the Books Online
that this feature will be removed in latter version | | 2 | 56 | 2/6/2008 5:53:39 PM |
Boolean/Bitwise Expressions
I can't seem to figure out why I get an error "Incorrect syntax near '='"
when I try to compare a bitwise expression with a regular number and return
0 or 1. It seems I should be able to get | | 4 | 70 | 2/6/2008 5:22:22 PM |
Set a global filter on a table
I work a huge kind of ugly project where we have lots and lots of
tables in the database, the calls to the database is spread out across
multiple projects,sp's, SSIS and so on.
We hav | | 8 | 69 | 2/6/2008 5:05:57 PM |
FullText Index Search
I have a simple music catalog:
CREATE TABLE [dbo].[Catalog](
[CatalogId] [int] IDENTITY(1,1) NOT NULL,
[Artist] [nvarchar](256) NULL,
[Title] [nvarchar](256) NULL,
[Remix] | | 0 | 69 | 2/6/2008 4:22:12 PM |
Audit:Login
Hi
SQL Server 2005 SP1
In Profiler I see a great number of Logins /Logout.
This is a web enviroment and the site is active but the number of Logins
seems too large | | 6 | 83 | 2/6/2008 4:14:52 PM |
lot allocation query
Hi, I'm working on a small project that manages sales orders and inventory.
The sales orders have many details, saying how much of which product should
be sold. The inventory table has l | | 0 | 60 | 2/6/2008 4:01:31 PM |
collasion
Hi,
SQL Server 2005 sp1
I need to store chars in russian, arabic and english in the same column.
I created the column unicode data type and therefore no conversions should < | | 2 | 74 | 2/6/2008 3:52:04 PM |
SQL Server 2008 models question.
Does anyone here know (an MVP perhaps), whether SQL Server 2008 will be
released in "Desktop Engine" format and if so, what the limits on that might
be? We had 2Gb limit with 2000, 4Gb limi | | 3 | 57 | 2/6/2008 3:11:37 PM |
How to programmatically force distributor operation?
I have a process that writes to the database and needs to know when the
transaction has been transactionally replicated to the second database. I
commit the transaction and then kick off Sy | | 0 | 70 | 2/6/2008 2:12:01 PM |
=?Utf-8?Q?is_it_possible_to_build_a_trigge?=
Hi I have a database that receives its data from web forms, occasionally on
either an insert or update i get the following (?) (?) entered before the ?
sign.
I cant isolate what is | | 11 | 62 | 2/6/2008 12:05:01 PM |
How to get the status of SQL instance?
Hi,
I want to get the status of the SQL instance which are all visible in my
network. I am using "ListAvailableSQLServers" to get the list of instances.
In SQL 2000 it returns the instan | | 1 | 68 | 2/6/2008 10:14:00 AM |
Where is T-SQL help in MS SQL 2005 Management Studio?
In SQL 2000 I could easily find T-SQL help in the Query Analyzer manu. Where
is T-SQL help in 2005?
| | 3 | 55 | 2/6/2008 10:02:47 AM |
whether a table is a table on a subscription data base
Hello,
as I can determine (by means of SQL) whether a table is a table on a
subscription data base, made a replication?
Frank
| | 1 | 76 | 2/6/2008 6:55:30 AM |
delete or update
Short performance question:
Is it faster to delete a record physical or to update a flag that indicates
the deleted state for further select operations?
delete from table where id = | | 5 | 68 | 2/6/2008 4:58:47 AM |
BulkCopy problem
Hi everyone,
The data I'm saving to the database is dynamic, i.e. the columns in a table
are only known at runtime. I validate the loaded data before I save it to
the database using | | 11 | 92 | 2/6/2008 3:30:18 AM |
update insert delete trigger - how to determine which action caused
In an update, insert, delete trigger how do I deterimine which action
caused the trigger. Is the best way to do it by checking the row count
in the deleted and inserted tables, as shown below? | | 8 | 86 | 2/6/2008 3:02:34 AM |