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
- 12569 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 different ways to return the rowcount of a table?
What is the difference between a local and a global temporary table?
What are the tools available in market as an alternative to sql server reporting services?
How to enter unicode character string literals in ms sql server?
How to assign null values to variables or columns?
What is resultset concur_updatable?
How many cores do I need for sql server 2016?
What is CTE in SQL
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What happens if null values are involved in datetime operations?
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is encryption key?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How can you tell if a database object is invalid?
What do you mean by an execution plan? Why is it used?
