Viewing 15 posts - 121 through 135 (of 193 total)
when the rows will be added to tempdb(update statement, select statement) and when it is cleared ?
March 19, 2013 at 11:39 pm
when the rows will be added to tempdb(update statement, select statement) and when it is cleared ?
March 19, 2013 at 10:44 pm
can we estimate required space for tempdb ? and also whether database update speed is reduced ?
March 18, 2013 at 12:02 am
What if i use ENCRYPTBYPASSPHRASE to encrypt selected colums? How anyone with admin permission can decrypt it without knowing passphrase?
March 14, 2013 at 8:47 am
If a user who has access to the database with admin permission then he can take backup and restore database anywhere. So can i protect the database from being stolen?...
March 14, 2013 at 8:11 am
I just had look at this [/url] nice article.
Here symmetric key encrypted using certificate. There is also option to encrypt it by using password. So which one is better?
March 12, 2013 at 7:47 am
demonfox (3/8/2013)
or you can have a Currency Code...
March 11, 2013 at 11:38 pm
jformosa (3/11/2013)
I had similar questions to these:
"then what is the use of inserting currency symbol?? And your link has list of symbols. How can i type symbols other than...
March 11, 2013 at 11:30 pm
demonfox (3/7/2013)
You can't .. that's how SQL Server stores it .. check it out on this link
http://msdn.microsoft.com/en-us/library/ms179882.aspx
..
I found this in your link
It is important to remember that while you...
March 8, 2013 at 12:30 am
Lynn Pettis (3/6/2013)
Does this get you started?
with TopDates as (
select top (100)
MyDates
from
dbo.MyTable
order by
MyDates desc
)
select min(MyDates) from TopDates;
That will...
March 7, 2013 at 11:14 pm
ChrisM@Work (3/7/2013)
winmansoft (3/7/2013)
ChrisM@Work (3/7/2013)
DECLARE @Parameter VARCHAR(8000)
SET @Parameter = 'seh,jyo,mhf'
SELECT *
INTO #Elements
FROM dbo.DelimitedSplit8K (@Parameter,',')
SELECT...
March 7, 2013 at 5:46 am
ChrisM@Work (3/7/2013)
DECLARE @Parameter VARCHAR(8000)
SET @Parameter = 'seh,jyo,mhf'
SELECT *
INTO #Elements
FROM dbo.DelimitedSplit8K (@Parameter,',')
SELECT m.*
FROM reminder.dbo.Reminder...
March 7, 2013 at 5:12 am
Thank you
I found that i can do this
DECLARE @Parameter VARCHAR(8000)
SET @Parameter = 'seh,jyo,mhf'
DECLARE @Elements TABLE
(
...
March 6, 2013 at 11:04 pm
Sorry for my misunderstanding..solutions suggested will work for those condition.. I have to get minimum date from top 100 max dates. Any query work for this?
March 6, 2013 at 9:50 pm
Viewing 15 posts - 121 through 135 (of 193 total)