select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal.
- 8 Answers
- 10474 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sandeep saxena
CREATE procedure Proc_Loaddata_Text (@File_path nvarchar
(255),@Table_Name varchar(100)) AS
DECLARE @SQLString NVARCHAR(4000)
/* Build Command*/
SET @SQLString =N'Bulk Insert ['+@Table_Name+'] from ' +
N'N''' + @File_path + N''' with (FIELDTERMINATOR=''|'',
ROWTERMINATOR = ''\n'')'
--print @SQLString
/* Execute */
EXEC (@SQLString)
GO
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Does an index slow down updates on indexed columns?
Can sql servers linked to other servers like oracle?
List the advantages of using stored procedures?
What is tablix?
What is Lock table in SQL?
How to drop an existing table with "drop table" statements in ms sql server?
Explain about system database?
What are the joins in sql server? : sql server database administration
How to create function without parameter in sql server?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is statement level trigger?
What is a hint?
what is the difference between delete table and truncate table commands? : Sql server database administration
How to find the version of sql server? : sql server database administration
List types of tables in SQL Azure?
