Reputation
691
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 13
Newest
 Yearling
Impact
~144k people reached

  • 0 posts edited
  • 0 helpful flags
  • 47 votes cast
Aug
18
comment How to extract pipe-delimited data using BCP?
@Craig, Is there any way around except changing the login you're using under security for the server\instance. Since its client machine. I almost get the required data, only facing challenge with Datetime field Quotename converts the format of datetime field.
Aug
18
comment How to extract pipe-delimited data using BCP?
I appreciate Andriy.
Aug
18
comment How to extract pipe-delimited data using BCP?
Does it work for double quotes text qualifier?
Aug
18
comment How to extract pipe-delimited data using BCP?
I appreciate Craig. I just edit my question for dataset and requied result . I think Double quotes text qualifier not available in the SQL Server.
Aug
18
revised How to extract pipe-delimited data using BCP?
added 310 characters in body
Aug
18
asked How to extract pipe-delimited data using BCP?
Jul
16
awarded  Yearling
Sep
26
answered MongoDB: how to get the all the embedded data?
Jul
16
awarded  Yearling
Jul
2
awarded  Curious
May
27
awarded  Notable Question
Apr
3
comment How to solve the error Msg 547, Level 16, State 0, Line 1
Make sure first, you have no any such records in your child table and take care of that record otherwise it will conflict the constraint.
Apr
3
answered How to solve the error Msg 547, Level 16, State 0, Line 1
Mar
25
answered How can I change the names of all tables to uppercase?
Mar
12
answered DMV queries for capturing most frequently used queries and worst performing queries
Feb
24
answered Agent Xps getting disabled automatically
Feb
20
answered SQL Server Table Backup
Feb
20
comment SQL Server Table Backup
DDL is not possible to rollback until you use BEGIN TRANSACTION. You have to recover these tables from old backups.
Jan
8
awarded  Popular Question
Nov
6
comment Alternative of a query
My problem has been resolved. Actually there was mismatch of datatypes of join column, one is varchar and second one is nvarchar. As I make both column of same datatype query returns result in quick. Thanks!