For some queries/utility we can avoid dependency of this type of util procedure by writing query directly.

e.g.

for ctrl + 7 write : select count(*) from

now for any database connected in...

You can use,

ctrl + 6 for : select * from tablename

ctrl + 7 for : select count(*) from tablename

Thanks

Its very usefull query

I had create stored procedure for it with inputdate parameter

Thanks again

Oh dear,

Its very tricky & helfull

Thanks

Its very helpful script, Thanks

I think this error is because of number type column of oracle table.

if u give specific size in oracle then its not problematic like: number(5),number(5,2) etc...

I was getting error in...

Your syntax is right,

can u describe table of oracle?

Its right, cengland0

and This forum should want to define minimum version to use in question.

Thanks to clarify

I am using SQL Server 2005.

Where is the DATE datatype in sql server??????????

CREATE TABLE mytesttable

(

MyID INT IDENTITY

, mychar VARCHAR(20)

, mydate DATE DEFAULT GETDATE()

)

DECLARE @mytable TABLE ( i INT, d DATE);

INSERT dbo.mytesttable (mychar)

...