| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | The stored procedure below gives me the user id from a table called
user_table. When I EXEC it using
EXEC dbo.spGetAppID @UserID = '586221'
it...
luisdev
|
Today 04:00 AM
luisdev  | 0 | 1 |
| | | I want to install sqlserver 2008.
Presently I'll only use it locally along with vs2010 for web development.
Some day I may look for a host to put...
eternal-september
|
Yesterday 08:04 AM
Joe Sulla | 9 | 10 |
| | | Dear SQLers:
Is there a way to get keyboard input while executing a script?
I have done a bit of looking and can not find it. I do not know
what...
Gene Wirchenko
|
05-25-2012 04:24 PM
Erland Sommarskog | 1 | 5 |
| | | Hello
if any one have an idea that can help me I would be grateful
So i should create a web service wich will communicate with my android
application...
Olfa Dhaouadi
|
05-24-2012 04:32 PM
Erland Sommarskog | 1 | 7 |
 | | Dear SQLers:
If a constraint of some sort is violated, how can I find out
which one?
Yes, I can parse the error message hoping to find it, but,...
Gene Wirchenko
|
05-23-2012 04:32 PM
Erland Sommarskog | 7 | 13 |
| | | Learn how to protect your sensitive information using Real-Time Dynamic Data Masking
When? Wednesday, May 23, 2012
(9:00 am PDT; 12:00 pm EST; 16:00...
Sam B.
|
05-20-2012 02:04 PM
Sam B. | 0 | 9 |
| | | Hello,
I would like to know if it's possible to compose a TSQL statement that
will convert columns of information into rows of information. ...
Sydney
|
05-18-2012 11:22 AM
rpresser | 12 | 97 |
| | | Hello,
I'm a little bit confused about the following message I get
Table 'aTBLTest1'. Scan count 1, logical reads 52, physical reads 0,
read-ahead...
xperre van wilrijk
|
05-16-2012 01:15 PM
Jeroen Mostert | 5 | 16 |
| | | Hello;
I am using SSIS on SQL Server 2008. I am trying to use a reg
expression to extract only the numeric characters out of a varchar
field. It...
TonyE
|
05-15-2012 08:17 AM
Erland Sommarskog | 4 | 17 |
| | | Is there any way to do this.
I checked and all my datetimes are > 1/1/1900 so that is not the
problem.
I do not know how to do this. Just for a test...
sparks
|
05-15-2012 06:44 AM
sparks | 4 | 15 |
| | | Dom wrote:
Err ... because.
What other answer did you expect? We're not Microsoft, we're just users of
the product.
In all my years working with...
Bob Barrows
|
05-15-2012 02:23 AM
Erland Sommarskog | 1 | 9 |
| | | Dear SQLers:
Another shot at validation, this time for real, I hope.
Suppose I have a stored procedure to handle insertions and
updates to a...
Gene Wirchenko
|
05-10-2012 05:05 PM
Gene Wirchenko | 2 | 22 |
| | | Dear SQLers:
I have two systems: an XP system which is my main system and a
Windows 7 system which is for development. The latter is a
sacrificial...
Gene Wirchenko
|
05-09-2012 10:42 PM
Tony Toews | 7 | 17 |
| | | Dear SQLers:
Here is something that I have not seen addressed in anything I
have read. How does one handle changing versions?
It turns out that my...
Gene Wirchenko
|
05-09-2012 03:00 AM
Erland Sommarskog | 1 | 21 |
| | | I have to create a file that is expected to have only char(10) as a row
terminator. How can I bcp out of a table and use char(10) as a...
Richard
|
05-08-2012 08:00 AM
Erik Grahn | 9 | 30 |
| | | Dear SQLers:
I decided to install a second instance of SSE2008 on my Win7 box.
The installation went fine.
I started up SSMS, and the new instance...
Gene Wirchenko
|
05-04-2012 03:01 AM
Erland Sommarskog | 1 | 33 |
| | | I could use some help with this.
I have a measure called Production that I can use with another
dimension called Firm such as:
select
. on...
Scott C
|
05-03-2012 10:41 AM
Scott C | 0 | 13 |
| | | Serving those who need it most! Anytime Restoration is a family
operated company built on strong principles that makes recovering from
a disaster the...
samye roy
|
05-03-2012 04:40 AM
samye roy | 0 | 11 |
| | | Dear SQLers:
What is the proper way for moving a database from location to
location?
I put together a simple database, backed it up, and sent it...
Gene Wirchenko
|
05-03-2012 02:21 AM
Erland Sommarskog | 6 | 15 |
| | | This is a bit of a weird one.
We have tables along the lines of the following design (note - not our
design, please don't tell me to change it):...
Michael Cole
|
05-02-2012 07:26 PM
Michael Cole | 4 | 21 |
| | | SQL Server BI Pros and DBA's are in desprate need all over the
country.
Organizations are now catching up on projects that have been put off
for...
SqlServerJobs.com
|
05-02-2012 11:55 AM
SqlServerJobs.com | 0 | 9 |
| | | Has anyone experienced problems with SSMS interfering with VS 2010? I am occassionally seeing my VS 2010 keyboard settings being reset to default...
nevyn@home.com
|
05-02-2012 03:12 AM
nevyn@home.com | 0 | 9 |
| | | Hello.
I'm writing a s proc to authenticate users.
So I want to see if there is 1 record "....where UserID='somevalue'
and...
Bob
|
05-01-2012 01:41 PM
Bob | 2 | 15 |
| | | I tried to modify a field from non-key field to a primary key in the
table, but SQL Server 2000 does not let me to do it.
I thought that I can...
iccsi
|
04-27-2012 05:54 PM
iccsi | 5 | 26 |
| | | Hi,
I'm not a storage expert. I just maintain a set of virtualized sql
servers using Netapp luns (iscsi/snapdrive/snapmanager;...).
I noticed that...
xperre van wilrijk
|
04-23-2012 02:01 PM
George Neuner | 3 | 36 |
| | | Dear SQL and Windows 7 People:
I have a system running Windows 7. It is not my main system, and
I have not installed much on it.
I installed SQL...
Gene Wirchenko
|
04-19-2012 03:46 PM
Erland Sommarskog | 4 | 29 |
| | | SQL jobs waiting for candidates
ITJobPro.com is the premier IT Job Board for information technology
professionals.
Upload your Resume (totally...
IT JobPro
|
04-19-2012 01:46 PM
IT JobPro | 0 | 16 |
| | | Good Morning. I'm doing a bulk insert in a stored procedure. The
source file is a tab delimited file which was created from an excel
spreadsheet. ...
eighthman11
|
04-18-2012 04:38 PM
Erland Sommarskog | 5 | 20 |
| | | The following are tutorials on creating barcodes in Microsoft
Reporting Services
Using .Net Barcode...
BarcodeResource
|
04-18-2012 05:28 AM
Bob Barrows | 1 | 24 |
| | | Dear SQLers:
I have a script that sets up a simple database. I have various
messages in it to indicate what should be happening.
On inserts that...
Gene Wirchenko
|
04-18-2012 02:31 AM
Erland Sommarskog | 1 | 13 |
| | | I finished all the merging and inserting of the database I have been
working on and made a copy of the final and a backup
anyway I was trying...
sparks
|
04-16-2012 10:43 AM
sparks | 8 | 32 |
| | | I use SSMS template to create stored procedure for SQL Server 2000.
SSMS has following code to drop stored procedure exists,
-- Drop stored...
iccsi
|
04-15-2012 10:10 PM
Gene Wirchenko | 10 | 35 |
| | | iccsi (inungh (AT) gmail (DOT) com) writes:
So the error in the first case was that you specified a backup file that
did not exist. (Operating...
iccsi
|
04-13-2012 08:42 AM
jsfromynr | 10 | 42 |
| | | SSMS has edit top 200 records from user interface.
I just wonder any way to use user interface to edit data more than 200
records?
Is it the only way...
iccsi
|
04-13-2012 01:50 AM
Erland Sommarskog | 1 | 19 |
| | | I would like to delete database backup file.
I do not have rights to access the file using Windows Explorer.
I just winder any system stored...
iccsi
|
04-06-2012 01:03 AM
Jeroen Mostert | 1 | 34 |
| | | I got "The log file for database tempdb is full, backup transaction
log to free up some space for log space"
error message.
Please help any store...
iccsi
|
04-05-2012 04:46 PM
Erland Sommarskog | 1 | 18 |
| | | I am trying to insert data into another database
problem is one column in a table is float .375, .09, .064
destination is decimal(5,1)
should I...
sparks
|
04-05-2012 11:20 AM
sparks | 5 | 26 |
| | | http://www.cheat-test.com/Microsoft-certification-exams.html Cheat-
test.com is the leader in supplying certification candidates with
current and...
Michael
|
04-05-2012 01:22 AM
Michael | 0 | 17 |
| | | Hello, I would like to auto-run a program after inserting a new
dataset.
The new dataset is in my case a new DotNetNuke user (table: users).
The...
olivogt
|
04-04-2012 04:41 PM
Erland Sommarskog | 3 | 26 |
| | | We have a TimeCard table like so: (stripped down example)
CREATE TABLE .(
IDENTITY(1,1) NOT NULL,
NOT NULL,
NOT NULL,
NULL,
NOT NULL,
)
James
|
04-04-2012 09:39 AM
James | 2 | 23 |
| | | Ok I have all the data imported.
I have all the code and want to duplicate this in a new copy of the
destination.
To preserve all schema since the...
sparks
|
04-03-2012 07:33 AM
Erland Sommarskog | 1 | 28 |
| | | I have about 100 columns in a table that I am inserting into another
table.
Most of them require reformatting of the destination.
something...
sparks
|
04-02-2012 07:54 AM
Bob Barrows | 5 | 19 |
| | | I tried to move my view from SQL 2000 to SQL 2008 R2.
Once I run the scripts, I realized that my SQL 2000 views becomes SQL
2008 R2 tables.
I am...
iccsi
|
03-31-2012 06:18 PM
smithjhon | 5 | 28 |
| | | I just saw something I don't understand
This happened to some (NOT ALL) of my FK
example I had 2 tables
client and clientprivateinfo
in client...
sparks
|
03-30-2012 05:03 PM
Erland Sommarskog | 4 | 30 |
| | | My boss says ok here are 2 sql backups.
We think they have the same tables and columns.
merge them.
this is sqlserver 2008 r2
oh wait here is...
sparks
|
03-29-2012 01:13 PM
sparks | 10 | 48 |
| | | I want to compare date part of 2 datetime type field.
I think the best way is to cast to date part data only, since if I
compare whole data which...
iccsi
|
03-26-2012 03:29 PM
Erland Sommarskog | 4 | 38 |
| | | I would like to install second instance on the same computer for SQL
Express version.
I just wanted to know that can I install second instance from...
iccsi
|
03-23-2012 04:45 PM
Erland Sommarskog | 1 | 35 |
| | | I have scenario where I have head office and many branches of company.
In this arrangement, data often needs to be centralized and amalgamated for...
simon
|
03-19-2012 04:23 AM
simon | 0 | 25 |
| | | Hi All,
I've got a column in the database that has IP addresses, though the
column data might have multiple IPs, comma separated that take the
form...
Donatello Cruz
|
03-16-2012 07:44 PM
Donatello Cruz | 3 | 38 |
| | | Hello,
I am trying to find a way to join a table but I need to "join it twice". Let me explain. I have a table (TrackLocation) that is tracking...
GWTNewbie
|
03-07-2012 01:47 PM
Bob Barrows | 1 | 45 |
