What is the best way to move n number of DTS package from
one SQLServer to another SQLServer?
Answer / pratik
transfer data from sysdtspackages of msdb database to
another SQL Server
Is This Answer Correct ? | 1 Yes | 2 No |
What are the 3 types of schema?
What happens if you add a new index to large table?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?
what is a stored procedure and trigger?
How to drop an existing table?
Diff. b/w Full Outer Join And Cross Join?
hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end
What is the use of RDBMS?
What are secondary xml indexes?
What are the requirements to use odbc connections in php scripts?
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that