| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  |
Mark Rain
|
06-12-2012 11:39 AM
bunny143sai@gmail.com  | 1 | 171 |
 | | Dear SQLers:
I am somewhat confused about when to use GO. I would like to
avoid it where possible, that is, I would prefer to make my batches...
Gene Wirchenko
|
06-08-2012 11:57 AM
Gene Wirchenko | 4 | 129 |
| | | Hi folks. I previously posted this question but I made an error in my
example.
I need to update a column of a table based on the pri. key.
I tried...
Bob
|
06-08-2012 08:30 AM
rpresser | 5 | 90 |
| | | Can I put a sql command in the "Then" part of a Case ?
Something like this:
Case @MIY
When 0 Then Update dbo.EMI Set fieldA=@insertString Where...
Bob
|
06-06-2012 08:23 AM
Bob Barrows | 2 | 98 |
| | | Thought this white paper may interest people working in the db security side of things.
http://bit.ly/KaL5YA
Securosis reports on Database Security...
Sam B.
|
06-04-2012 03:24 PM
Sam B. | 0 | 102 |
| | | The spUser procedure below will be used to insert records into the
tblAppUsers table.
SCOPE_IDENTITY() then gives me the ID of the record that was...
luisdev
|
05-30-2012 10:22 AM
rpresser | 2 | 95 |
| | | Dear SQLers:
I have written a longish script. I am up to just over 800 lines,
and there is way more to come yet. In it, I define a number of...
Gene Wirchenko
|
05-30-2012 02:20 AM
Erland Sommarskog | 1 | 96 |
| | | 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
|
05-29-2012 09:45 AM
Bob Barrows | 1 | 101 |
| | | 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
|
05-28-2012 08:04 AM
Joe Sulla | 9 | 122 |
| | | 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 | 101 |
| | | 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 | 81 |
| | | 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 | 98 |
| | | 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 | 104 |
| | | 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 | 296 |
| | | 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 | 98 |
| | | 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 | 77 |
| | | 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 | 63 |
| | | 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 | 60 |
| | | 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 | 76 |
| | | 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 | 72 |
| | | 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 | 89 |
| | | 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 | 88 |
| | | 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 | 67 |
| | | 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 | 59 |
| | | 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 | 69 |
| | | 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 | 56 |
| | | 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 | 59 |
| | | 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 | 45 |
| | | 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 | 56 |
| | | 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 | 71 |
| | | 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 | 75 |
| | | 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 | 73 |
| | | 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 | 54 |
| | | 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 | 60 |
| | | The following are tutorials on creating barcodes in Microsoft
Reporting Services
Using .Net Barcode...
BarcodeResource
|
04-18-2012 05:28 AM
Bob Barrows | 1 | 66 |
| | | 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 | 55 |
| | | 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 | 81 |
| | | 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 | 87 |
| | | 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 | 102 |
| | | 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 | 48 |
| | | 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 | 72 |
| | | 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 | 51 |
| | | 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 | 57 |
| | | 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 | 50 |
| | | 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 | 58 |
| | | 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 | 58 |
| | | 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 | 57 |
| | | 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 | 52 |
| | | 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 | 64 |
| | | 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 | 68 |
