Viewing 15 posts - 4,441 through 4,455 (of 13,469 total)
Markus (11/8/2012)
November 8, 2012 at 5:45 am
you know your data better than use;
this query seems to be what you were trying to insert.
does the sELECT return teh expected values? if the PatientId = Key, and it...
November 7, 2012 at 2:25 pm
Edit!!
Snippy Snippy Double Dippy!
i double psoted somehow sorry.
November 7, 2012 at 2:24 pm
you can use a standard integer identity, and then simply format the number with preceeding zeros whenever you are displaying it. there's no need to store preceeding zeros...that's just a...
November 7, 2012 at 6:28 am
there sure is...
on the same page you posted, there's a drop down menu for Otehr versions...R2 was the sole selection, which redirects you to here:
http://msdn.microsoft.com/en-us/library/bb677408(v=sql.105).aspx
November 6, 2012 at 9:29 am
scogeb (11/6/2012)
Could you disable all logins except one, and use that login for this maintenance?
maybe a create a logon trigger that prevents anyone from connecting unless from local connection?
then do...
November 6, 2012 at 8:26 am
ok I've got this implementation in my snippets that does what you are asking.
see if this works for you.
you need a table and a procedure, shown below:
CREATE TABLE [dbo].[InvoiceKeys] (...
November 6, 2012 at 7:20 am
you can search fro more infor by searching "SQL SERVER CHANGE DATABASE OWNER;
the BOL Links are here for the explanation and the code:
ALTER AUTHORIZATION (Transact-SQL)
and a basic...
November 5, 2012 at 11:55 am
it's just a syntax issue;
CASE for SQL has two forms :
CASE ValuetoTest
WHEN SomeValue
THEN SomeOtherValue
ELSE DefaultValue
END
--OR
CASE
WHEN {SomeExpression} (ie SomeColumn = SomeValue)
THEN SomeOtherValue
ELSE DefaultValue
END
you werejust...
November 5, 2012 at 11:35 am
azinyama (11/5/2012)
Another question though...What would I then do about preventing people from using Windows Authentication to log in???
just because you have a windows login, does not auto-magically mean the login...
November 5, 2012 at 10:38 am
azinyama (11/5/2012)
I am developing an application that is going to be setup on a server that is in a public area, that anyone will have access to.
If you are trying...
November 5, 2012 at 7:51 am
you would want to save the filename as well, don't forget....
deepkt (11/5/2012)
CREATE TABLE Img(Id INT, Filename varchar(255), Obj VARBINARY(MAX))
INSERT INTO Img (Id ,FileName,Obj)
VALUES (1,'Blue Lace 16.bmp',(SELECT * FROM OPENROWSET(BULK...
November 5, 2012 at 6:52 am
CREATE LOGIN [appp]
WITH PASSWORD=N'NotTheRealPassword'
MUST_CHANGE,
DEFAULT_DATABASE=[master],
...
November 5, 2012 at 6:24 am
i see that error in other posts a lot because people place the mdf in their MyDocuments folder or on their desktop, which all have restricted access, and the service...
November 5, 2012 at 5:23 am
SET PARSEONLY ON/OFF works as well.
i'm having some fun trying to get a CLR to work as a proof of concept; i'll post it as soon as it returns results...
November 2, 2012 at 9:56 am
Viewing 15 posts - 4,441 through 4,455 (of 13,469 total)