Viewing 15 posts - 121 through 135 (of 1,109 total)
satish.thota2002 (8/4/2008)
I had no Primary Key and Identity Column ON TABLE
empid ename
101 ...
August 4, 2008 at 8:13 am
sahoong (8/4/2008)
What is the mechanism in SQL server that disables a login if it has not been used for a number of days? Many thanks.Sahoong.
It is called Password Expiration, and...
August 4, 2008 at 7:46 am
karthikeyan (8/4/2008)
Thanks a lot for your prompt reply ! So when we think performance we need to use your method, when we think maintanance we can use my method. Am...
August 4, 2008 at 7:31 am
karthikeyan (8/4/2008)
Andras,Can you post both the query plan method ?
This is what I used. After executing the create table and the inserts, just select the last two select statements, and...
August 4, 2008 at 6:44 am
mathewspsimon (8/4/2008)
Andras,how should the query be modified if 3&4 cust is also to be included as column in the output.
SELECT [Prod_ID]
, [Item]
...
August 4, 2008 at 6:38 am
You can use PIVOT on SQL Server 2005. With the above example it would look like:
SELECT [Prod_ID]
, [Item]
...
August 4, 2008 at 6:28 am
Just to merge the answers, this post is a duplicate of http://www.sqlservercentral.com/Forums/Topic546020-149-1.aspx
Regards,
Andras
August 4, 2008 at 6:14 am
nageswar (8/4/2008)
I am facing bib problem, one of my friend deleted LDF file for Live database, because it is almost 100Gb space, so how to recovery data from that...
August 4, 2008 at 6:00 am
karthikeyan (8/4/2008)
Andras,How about my method ?
-----------------------------------
Declare @Str varchar(50),@Cnt int
select @Str = '1,C,C'
select @Cnt = count(*) from
(
select ascii(substring(@Str,1,1))
union
select ascii(substring(@Str,3,1))
union
select ascii(substring(@Str,5,1))
) a
...
---------------------------------------
I did a small test on a larger table and...
August 4, 2008 at 5:47 am
Ahmad Osama (8/4/2008)
I want to alter the length of columns.In doing so am getting error that which says that the column depends on defaults.Is there a way to only...
August 4, 2008 at 5:19 am
karthikeyan (8/4/2008)
the same character should not repeat twice. if the same character repeat twice then we need to throw the failure error message.
say for example,
0,0,C...
August 4, 2008 at 5:08 am
You can use a case statement like:
SELECT object_id
, CASE WHEN object_id = 4 THEN ( SELECT -1 )
...
August 4, 2008 at 3:46 am
Ratheesh.K.Nair (8/4/2008)
THANK YOU VERY MUCH FOR THE REPLY
Now my problem is that...
August 4, 2008 at 3:39 am
You could also use the ISDATE system function (and set before it the LANGUAGE or DATEFORMAT to specify the format you want to check)
Regards,
Andras
August 4, 2008 at 3:13 am
You can use patindex, like:
if patindex('[10C],[10C],[10C]', @ip) = 1
Regards,
Andras
August 4, 2008 at 2:58 am
Viewing 15 posts - 121 through 135 (of 1,109 total)