Viewing 15 posts - 1,981 through 1,995 (of 2,463 total)
i needed to play with data.
Declare @tbl table ( main_text nvarchar(200), Without_Roman_values nvarchar(100),Roman_values nvarchar(50) )
insert into @tbl (main_text)
select 'BHUVH III'
union
SELECT 'DEXY V'
UNION
SELECT 'JACK TONY VIII'
update @tbl
set Without_Roman_values = reverse(substring(reverse(main_text),charindex('...
March 30, 2010 at 4:59 am
Try this SELECT [Transaction Id], [Begin Time], [UID], [SPID]
FROM ::fn_dblog (NULL, NULL)
WHERE [Transaction Name] = 'DROPOBJ'GO
above code can give you spid of user who dropped that
and then use...
March 30, 2010 at 4:12 am
sudhakara (3/30/2010)
Thanks for your reply.
Did it get resolve ?
March 30, 2010 at 3:12 am
NO idea about that message
This link might help you http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.utility/html/utility/utility73.htm
March 30, 2010 at 1:53 am
Ashwin M N (3/29/2010)
But I have another problem in another table The column is of bit datatype not null default(0) how should I handle this.
Instead of using -n (native) datatype...
March 30, 2010 at 1:22 am
Always try to post exact error to get faster response :-).also post BCP query
March 30, 2010 at 1:17 am
yes it happened because of SP1 i think MS has fixed this bug iin SP2.
refer these links
http://www.windows-tech.info/15/4b5bdaab8e755fbe.php
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic15824.aspx
http://dbaspot.com/forums/sqlserver-programming/350238-sql2005-sql-agent-error.html
March 30, 2010 at 12:41 am
March 29, 2010 at 8:54 am
Are you using Physical box only for sql server ? then you can go for MAX option but if not then i think it might not be a good idea...
March 29, 2010 at 8:12 am
Paul White NZ (3/29/2010)
Bhuvnesh (3/29/2010)
first of all we cant have two columns with the same name.Really? You sure? 😉
Sorry i forgot to considered alias 😀 or something...
March 29, 2010 at 7:54 am
derrysql (3/29/2010)
StaffNo Name StartDate EndDate Salary StartDate EndDate Salary
first of all we...
March 29, 2010 at 7:34 am
Anamika (3/29/2010)
When i query on id 1 i should get
LEVEL1 2,3
LEVEL2 4,5
LEVEL3 ...
March 29, 2010 at 5:57 am
Can you post required columns for staffno for 1234 so that i can get rough idea/hint ?
March 29, 2010 at 5:52 am
Viewing 15 posts - 1,981 through 1,995 (of 2,463 total)