explain the
difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
No Answer is Posted For this Question
Be the First to Post Answer
WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?
what is denormalization? : Sql server database administration
Explain multiserver query
What is Index Segmentation ?
How to generate random numbers with the rand() function in ms sql server?
Do you know what are the properties of the relational tables?
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
Ms sql server index?
How to drop existing views from a database in ms sql server?
What is the use of placing primary key and foreign key constrains on columns.
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?
What is the synonym of join?