Ok.Thanks....

In hurry I make a mistake.

I have completed oracle 9i DBA.

Now there are so many track in ms sql server DBA.like developer,Administrator.

I want to go with administrator which specific exams are required.

I fill microsoft site...

only last to lines of my post is work for you.

first for line is general information..

'also left side box is for source and right side check box for destination '

sheet...

begin tran

create table Forms(ID int,Name1 varchar(30))

insert into forms values(1,'Form1')

insert into forms values(2,'Form2')

create table variables(FormID int,Name varchar(30),Value varchar(30))

insert into variables values(1,'Var1','A')

insert into variables values(2,'Var2','B')

insert into variables values(2,'Var1','C')

create table Mods(ObjName varchar(30),Type varchar(30),FormName...

may be there are so many oracle DBA's on this site.

may they guide us to create same site for Oracle.

generally whenever you create a excel file it gives three files.

same whenever you try to import excel file it gives option to import all three files.

in your case there are...

IF I have defined right datatypes then

declare @a varchar(100)

declare @b-2 float

declare @c varchar(max)

select @a ='hyderabad'

select @b-2= 10.145

select @c=@a + cast(@b as varchar(max))

print @c

Thanks All,

It works

I am new to sql server .....but from this topic I understand/decide that ,

you are beginner or expert , first do best try to get answer from BOL and google(to...

ok thanks .

I have also one more requirement.

I also want to search white spaces excluding a single space

like TAB,line brake,new line character.

' I added a logging instruction in every sproc'

how can i add logging instruction in every objects like when it is used or executed then i know that.

The question is too boring to read or you simply don't know the answer ?

You are right I dont know answer.actually i cant understand your question.

sorry for this and...

boring to read your question.

Simply float takes 5-17 bytes for single value storage

when int takes 1 or 2 bytes to store a value. when you skip these columns in query

it is commonly...

--First create a user in Database.

GRANT ALTER ON TABLE_NAME TO USER