Viewing 15 posts - 31 through 45 (of 444 total)
You can check on create_Date and modif_Date in sys.objects.
But it will be better to go for DDL triggers to get the exact information.
June 28, 2010 at 5:39 am
malleswarareddy_m (6/27/2010)
sheik (6/27/2010)
The table should be created with the identity (-1,-1). Then only we can get this result. Must be a typo error???.It's correct.
Right.
Create Table MyTable1( mainkey int not...
June 28, 2010 at 12:14 am
Here is the script of dbo.fnSplit function;
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE function [dbo].[fnSplit]
(@pString nvarchar(max),@pSplitChar char(1))
returns @tblTemp table (tid int,value varchar(1000))
as
begin
declare @vStartPositionint
declare @vSplitPositionint
declare @vSplitValuevarchar(1000)
declare @vCounterint
set @vCounter=1
select @vStartPosition = 1,@vSplitPosition=0
set @vSplitPosition =...
June 22, 2010 at 7:00 am
Check this...
http://msdn.microsoft.com/en-us/library/ms174123(SQL.90).aspx
And you can use if condition in your application code. Generate data set from the query to check the column using Information_Schema and take decission at application level code.
Stored...
June 14, 2010 at 4:46 am
Check this...
http://msdn.microsoft.com/en-us/library/ms174123(SQL.90).aspx
And you can use if condition in your application code. Generate data set from the query to check the column using Information_Schema and take decission at application level code.
Stored...
June 14, 2010 at 4:34 am
Just to try,
-- To get the list of Tags removed....
Declare @vTagNameTable Table(Tag varchar(max))
-- My HTML
Declare @v-2 varchar(max)
Set @v-2 = '<html DIR="LTR" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:MSHelp="http://msdn.microsoft.com/mshelp"><A>Atif Sheikh < Atif
<Bold>Sheikh</Bold> </HTML>...
June 9, 2010 at 2:01 am
Just give it a try...
-- To get the list of Tags removed....
Declare @vTagNameTable Table(Tag varchar(max))
-- My HTML
Declare @v-2 varchar(max)
Set @v-2 = '<html DIR="LTR" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:MSHelp="http://msdn.microsoft.com/mshelp"><A>Atif Sheikh < Atif...
June 8, 2010 at 6:25 am
shameej_thbs (6/1/2010)
Thanks..Can you give me some more details in it
Like what?
June 1, 2010 at 7:00 am
It would be much better if you keep the logic of 1 week, 1 Month, 6 Months, etc on the front end.
All you receive should be from date and to...
June 1, 2010 at 6:06 am
OK. You must be using SQL Server compact edition on PDA device.
You would need to design a complete solution for that.
Try this link...
http://msdn.microsoft.com/en-us/library/ms171850(SQL.100).aspx
And
http://www.devbuzz.com/Articles/zinc_sql_merge_replication_pg1.aspx
The tip fro your question...
June 1, 2010 at 5:31 am
Try using RowNumber(). Something Like;
Select * from (
Select *, RowNumber() over(order by [Issue] partition by xidxrecid) Rno
From (
SELECT cdi.xidxrecid,CFA.ORGID,
...
June 1, 2010 at 5:04 am
Viewing 15 posts - 31 through 45 (of 444 total)