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
- 11419 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
How to loop through returning rows?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
Is sql server a database?
What is index in an assignment?
What is instead of dml trigger?
What is filtered index?
What are the default system databases in sql server 2000?
What is difference between views and tables?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Does partitioning help performance?
What is temporary table in sql server? Why we use temp table?
How does clustered and non clustered index work?
How adventureworkslt tables are related?
What are the different authentication modes in sql server? How can it be changed?
What is stored in the mssqlsystemresource database? : sql server database administration
