Viewing 15 posts - 1 through 15 (of 108 total)
May 20, 2018 at 11:56 pm
one other way is you can also specify the case statement including IsDat check.
CASE WHEN IsDate(value) then CAST/Convert( value ) else "you can specify the default date " END
September 5, 2008 at 12:25 am
1 question does column position matters to you / database ?
you can add the column at specific order either by the way mention by Jack Corbett. there is not other...
September 5, 2008 at 12:22 am
I appreciate your view but the problem arise for permissions when i execute the SP either i have to user EXECUTE AS Clause or I have set the permissions for...
September 4, 2008 at 12:18 am
it's always good to keep your object objects isolated. this will help you to keep track. This may possible that in future there will be a change in your Business...
September 2, 2008 at 3:22 am
Yes you can do it by using MERGE JOIN task after fetching the data from different sources.
August 22, 2008 at 5:13 am
you can also use this query ....
select CAST(CAST(sum(size) * 8192 / 1048576 AS DECIMAL(10, 2) ) AS VARCHAR(20)) + 'MB' from sys.master_files where database_id = DB_ID('Global_DB')
August 22, 2008 at 5:12 am
yes we can implement column level encryption using the ASYMMETRIC KEY and SYMMETRIC KEY to encrypt & decrypt the column data.
check msdn for brief help on ASYMMETRIC KEY and SYMMETRIC...
August 22, 2008 at 3:15 am
Why do you want to implement recursion as you are searching only for only 1 level
As you mention :
all the position that reports to "Product Development"
e.g "Project Lead;QA...
August 22, 2008 at 1:08 am
There must be the problem of locking your table is getting locked
Have you created any index which is greater in size ?
August 21, 2008 at 5:24 am
When you restore the sql 2000 database on sql 2005, you have to fix the mapping of users & database manually.
August 18, 2008 at 2:57 am
You can not detect that which table is used by Application, for that you have to do manual work there is no such tool.
About database you can check that whether...
August 8, 2008 at 12:47 am
just a suggestion to check,
When you created the linked server have to given the permission to NT\WindowsUser ?
August 8, 2008 at 12:45 am
This could be simpler as mention below.
SELECT sm_type, count(sm_type) FROM sm group by sm_type
August 7, 2008 at 4:17 am
i think it should be like this...
IF @LineFilter in ( '1,2,3' )
August 7, 2008 at 3:53 am