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
- 12622 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
Can primary key be a foreign key?
Do you know what is xpath?
What is the partitioning method?
What is parameterized reports in ssrs ?
What do you mean by cardinality?
What are extended events in sql server?
Define master database?
What are the lambda triggers?
What is the full form of dql?
How to download and install microsoft sql server management studio express?
Explain the microsoft sql server delete command? : SQL Server Architecture
Does an index slow down updates on indexed columns?
What are xml indexes?
Can select statements be used on views in ms sql server?
What is the default schema of your login session in ms sql server?
