THE RESPONSIBILITY OF DBA IS LARGE.

YOU CAN BUY SOME GOOD BOOKS TO START YOUR Journey.

Care fully read all the aspects?

then,

what will i do?

what is your exactly problem,you can tell me?

if you want to create a temporary table,

then you have to use the following Query:--

select col1,col2,col3 into #temptable

from table

other wise you have to create a temptable first.

If you want to get the only time part, then

use the following Query :-

select convert(varchar,getdate(),108)

Your Inner Query :

produces more than 1 record.

You should check it.

Create a table with one column

and then use this query :-

insert into tbl

select replace(name,'<br>',char(13))

ok bye!!!!!

You can use:--

select @name=var_name,

         @add=Address

from table_name

My dear friend ,

if you want to create a temp table by using a variable name,

then in each time, you should have to use a Dynamic Query..

like

set @str='create table '...

Hi,

Don't worry!!! Main Hoo Na

use this Query to replace your data:-

select replace('amit' + char(13) +'gupta' +char(13),char(13),'')

bye!!

To find out the duplicates names you should use this query:-

select CX.FST_NAME+CX.LAST_NAME,count(*) num

from table_name

group by CX.FST_NAME+CX.LAST_NAME

having count(*) > 1

use your Query like this :-

select 'name_col' Col_name,

 case when count(name_col) > 0 then name_col else null end value

from table_a

group by name_col

union all

select 'Rev_No' Col_Name,

 convert(varchar(2),case when isnull(count(Rev_No),0) > 0 then isnull(Rev_No,0) else...

The Table alise name can't be a variable name.

Simple ,

Create an identity on such column.

It will autometically increment the value.

You should create a table

without creating indexes, because a primary key itself creates an index

You should use the folowing Query :----

Select * from TableA WHERE VERSION >=1.0