how to connect sybase to sql server 2005?.
Explain the etl (extraction, transformation, and loading)?
What is the use of keyword with encryption.
Why should we go for stored procedures? Why not direct queries?
List the different index configurations possible for a table?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
How to copy the tables, schema and views from one sql server to another?
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 are the two virtual tables SQL Server maintains for triggers?
What is data file in computer?
What are the different editions available in sql server 2000?
How to find the version of sql server? : sql server database administration
Explain different backup plans?