One more thing some date is like '25-01-2010 09:51:59' that is the valid date but can not be converted into date.

what should I do.

Arjun Sivadasan (4/1/2010)

---

vaibhav.tiwari (4/1/2010)

---

Yes, with reference to reply of BigM that if schemaname is concatenate with the table name then sql server identify that it is the table name then...

Thanks a lot, My problem is solved, I never...

Sasidhar Pulivarthi (4/1/2010)

---

hi Vaibhav,

U are right...

I tried the following two Queries

SELECT COUNT(*) tbl_object

tbl_object

1

SELECT COUNT(*) dbo.tbl_object

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near...

To avoid the cursor you can use this query as below

SET QUOTED_IDENTIFIER OFF

DECLARE @TABLE AS TABLE (Seq int identity(1,1), NAME VARCHAR(150))

INSERT INTO @TABLE(NAME) SELECT '['+NAME+']' FROM SYSOBJECTS WHERE XTYPE ='U'

--SELECT...

vijay.s (3/31/2010)

---

For finding the all list of parameter used in SP you can use below mention query.

SELECT sp.name, parm.name AS Parameter, typ.name AS [Type]

FROM sys.procedures sp

JOIN sys.parameters parm

ON sp.object_id...

srinivas-356817 (3/31/2010)

---

Hi Vaibhav, thanks for the reply.

The approach suggested by you will be very good if we have a small SP which doesnt have any complexity code involved.

But, if the...

COUNT(*) is nothing but count(1) or count(2) or any thing.

So whatever you are writing just after Count(*) is alias for the value.

even if you are using tablename it is not...

Dohsan (3/31/2010)

---

SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS DT

If you do a quick search you should be able to find a few sites with lists of the different date formats using CONVERT.

Have...

That is not only question its about to work out to achive the aim to do it.

Try to do it...

Something like this -

CREATE TABLE #tempA (val...

As per required output -

select REPLACE( convert(varchar,getdate(),111), '/', '-')

Thanks for the suggestion and got the hint i can do it by row_number function.

Thanks again

Can you go by below -

IF EXISTS ( SELECT 1 FROM sys.objects WHERE Object_ID = OBJECT_ID('tempdb..#tablename') )

BEGIN

DROP table #tablename

END

CREATE table #tablename (name varchar(100))

GO

INSERT INTO #tablename

SELECT 'table1'

UNION ALL

SELECT...

You can create a temporary table and insert all the table names in that and use dynamic query for that.