Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12849 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
What are the new security features added in sql server 2012? : sql server security
Can two tables have the same primary key?
What is efficiency data?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
How do you delete a data source?
What are basics of policy management?
Mention the differences between sql server and mysql.
Explain concepts of analysis services?
What is transact-sql language?
how you can get the list of largest tables in a database? : Sql server administration
Describe and explain about SQL native client?
What is an execution plan? When would you use it?
What is an sql server agent?
How to create a new login name in ms sql server?
why would you call update statistics? : Sql server database administration
