Define full outer join?
No Answer is Posted For this Question
Be the First to Post Answer
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.
What do you mean by the term 'normalization'?
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
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is a join in sql?
Determine how to use the inserted and deleted pseudo tables?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
application server is slow what may be the problem
How will you make an attribute not process? : sql server analysis services, ssas
List out a number of the wants to setup a SQL Server failover cluster?
How do you read transaction logs
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)