Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Cursors

  Cursors are bad in SQL Server and should be avoided unless there's absolutely no other way to achie…

  Sioban Krzywicki

  20 replies

  11 years, 10 months ago

  By: Eirikur Eiriksson

• How to add time zone to Date time field

  I have passed createdDate from UI to Stored procedure.createdDate field declared with DateTime.it i…

  pilla.sree85

  6 replies

  11 years, 10 months ago

  By: pilla.sree85

• RDP into server - queries run slow

  Hello, Environment: I have a remote server with SQL server 2014 instance on it. There is nothing el…

  asiaindian

  10 replies

  11 years, 10 months ago

  By: Grant Fritchey

• How to encrypt and check a login password.

  Hi, I am trying to learn how to store a web form password and than check it when the user log in. …

  skw05

  8 replies

  11 years, 10 months ago

  By: Ross McMicken

• loop and query CSV files in a folder using union all query to form resultant table on server

  Hi, I am trying to run a UNION ALL query in SQL SERVER 2014 on multiple large CSV files - the resul…

  sifar786

  11 replies

  11 years, 10 months ago

  By: J Livingston SQL

• cursor problem. not working properly

  I am having problem with my script. at first time, it runs fine, but when second time, when their i…

  navie22

  4 replies

  11 years, 10 months ago

  By: Sarvesh Kumar Gupta

• Why don't bulk imports TABLOCK by default?

  I've been reading about the "table lock on bulk load" option and TABLOCK hint. So my understanding …

  codykonior

  1 replies

  11 years, 10 months ago

  By: Grant Fritchey

• suggestions on one to may relationship in the data processing

  Hi all, I need your suggestion on below program development I have a scenario where one partner can…

  Gangadhara MS

  15 replies

  11 years, 10 months ago

  By: Greg Edwards-268690

• Recursive family, but how?

  Hi, I have a family table and would like to group all related members under the same familyID. Thi…

  SeeknFind

  3 replies

  11 years, 10 months ago

  By: SeeknFind

• DBCC FreeProcCache

  Hello, My knowledge of SQL is very limited. One of our old co-workers ran DBCC FreeProcCache on ou…

  sumeetahluwalia

  4 replies

  11 years, 10 months ago

  By: sumeetahluwalia

• How to: Bulk import xml to table

  Anyone has any suggestions? ^^ I found loads of things but nothing seems to work... I'm trying to g…

  pk2dpvp

  9 replies

  11 years, 10 months ago

  By: pk2dpvp

• view to physical table options

  Hi, I have a view which select some few columns from multiple tables with where clause and have 5 …

  Gangadhara MS

  2 replies

  11 years, 10 months ago

  By: Grant Fritchey

• Transaction rollback when multiple threads are inserting records into table because of trigger

  Hi All , I have two tables called ECASE and PROJECT In the ECASE table there is trigger to get the …

  ravi.teja 62048

  3 replies

  11 years, 10 months ago

  By: Gail Shaw

• xp_cmdshell in stored procedure not the same result as cmd prompt

  I have a stored procedure that uses xp_cmdshell to execute an executable. I made code changes to t…

  dirk.dromgoole

  6 replies

  11 years, 10 months ago

  By: Eirikur Eiriksson

• CASE condition not affecting CAST output

  Hi, I've a variable in my SP that I'd like to use to change the format of my output. Try this! sele…

  greg.bull

  8 replies

  11 years, 10 months ago

  By: mister.magoo