why do u want to create view.... you can do this conditional settings by making procedure......

first put condition that if that table have data or not ....

if there is data...

you can change filename with this way also

i think you should use bcp ....with use of xp_cmdshell to find the path of folder and it will take all the...

before this select * from RAJ_TEST WILL LOOK LIKE BEFORE I IMPLEMENT BELOW QUERY

NoNameSalary

11PRAVIN10000

12pravin9000

1Pravin15000

2Parag20000

3Herry10000

4Jeff2000

5Hardik4000

6Ramesh6000

7Mitesh8000

8Siddhi7000

9Karan9000

10Riddhi12000

SELECT NAME ,[salary] FROM

(

SELECT b.NAME AS NAME ,salary = REPLACE ((SELECT salary AS [data()] FROM RAJ_TEST...

as per all suggest you can check execution plan and also use Database Engine tuning advisor ... help you lot to create indexes .....

if you have created database mail account then in job you can set notification......... crete new operator and in that set your mail id ... now in job properties goto...

Happy Valentine Day to you also

hi, that happen's because you are using inner join .... use full outer join instead of that

here is your answer try my best to do this

SELECT OBJECT_NAME(a.OBJECT_ID) AS tablename ,a.NAME AS first_column_name,a.column_id,b.colid,b.indid,

CASE WHEN b.indid = 1 THEN 'PRIMARY KEY ' WHEN b.indid= 2 THEN 'NON...

man......... you realy put a thing that keep me in thinking ok you will get your answer

Hi,

I know why u feel fear do just one thing make one new table with same column and format of that table with identity(1,1)

now take all data from that table...

schema and user's calculation done in last two row

DECLARE @DBNAME VARCHAR(50)

SET @DBNAME = 'rtemp'

DECLARE @rsql VARCHAR(MAX)

SET @RSQL = '

SELECT (SELECT COUNT(*) FROM '+@DBNAME+'.sys.objects WHERE TYPE = ''U'' AND TYPE <>...

CHECK FOLLOWING AND JUST ENTER DATABASE NAME YOU WILL GET WHAT YOU WANT .....

in schema and user i have ommited default system schema or user

DECLARE @DBNAME VARCHAR(50)

SET @DBNAME = 'rtemp'

DECLARE...

hi,

i think in your above query you have do extra work and for function count may be you get wrong result

try below query as per your requirement only schema...

good query but did you try to entering in that another database name ?

hi, can u tell me exactly what you are trying to do .... from your execution plan it's show that you are trying to use select column name into and...