I have to insert multiple insert in sql server. Currently I am using bulk insert statement but for that I have to FTP these data from my web server...
Friends: I know I van do it like this way. But I need optimum and best solution
CREATE TABLE tmpPipeSepVals (name nVARCHAR(4000))
I want to insert multiple insert in a table like MySQL
So that I can make a array of values and insert directly in a table.I have to insert minimum...
thanks! your your help.
Thnaks for your info.Could you pls tell me how to write a function .or where
where should I start writing function in sql server?
Could you please let me know what is the substitute function of (substring_index of MySQL) in SQL Server?
Note : I know it I can do using CharIndex....
Separate names with a comma.