|
Insert trigger executing on update
|
|
9
|
905
|
October 30, 2017
|
|
Fiscal year get forward from current month
|
|
5
|
726
|
October 29, 2017
|
|
Replacing data
|
|
1
|
428
|
October 29, 2017
|
|
Check duplicate records during insert
|
|
0
|
505
|
October 29, 2017
|
|
Roll over values if NULL
|
|
3
|
1482
|
October 27, 2017
|
|
How to take backup databaseobjects(tables scripts,storeprocedure and functions etc) in sqlserver using sql scripts
|
|
2
|
619
|
October 27, 2017
|
|
For linked server returned message "ROW-00014: 젠⣫update) 饸䠮멥寠餰ꥰ魠᮱㠤ລ੭ ...". Msg 7343, Level 16, State 4, Line 1 The OLE DB provider "ORAOLEDB.Oracle" for linked server "Myoracle" could not UPDATE table "[Myoracle]..[CS1].[ITF_MATERIAL]"
|
|
1
|
1567
|
October 27, 2017
|
|
Convert Varchar round value to 2 decimals
|
|
4
|
3336
|
October 25, 2017
|
|
Formulated Closing Balance Column
|
|
1
|
599
|
October 25, 2017
|
|
How to Store More then 30000 characters in sql server 2012
|
|
4
|
2566
|
October 25, 2017
|
|
String Manipulation
|
|
2
|
552
|
October 25, 2017
|
|
ForEach Loop Connection Fails Due to Slash in Server Name
|
|
3
|
1263
|
October 24, 2017
|
|
Select only duplicates entry with join
|
|
3
|
555
|
October 24, 2017
|
|
Removing Duplicates
|
|
7
|
799
|
October 22, 2017
|
|
Trying to detect incorrect capitalisation in names
|
|
5
|
847
|
October 19, 2017
|
|
Converting rows to columns
|
|
1
|
476
|
October 19, 2017
|
|
Display data from vertical to horizontal
|
|
1
|
488
|
October 19, 2017
|
|
SP is inserting only ONE row of records. Any ideas?
|
|
6
|
835
|
October 18, 2017
|
|
Deployment State Compliance Question
|
|
5
|
588
|
October 18, 2017
|
|
Format Function doesnt work
|
|
6
|
890
|
October 18, 2017
|
|
Problem in Decimal
|
|
7
|
756
|
October 17, 2017
|
|
Trigger is not working
|
|
2
|
657
|
October 17, 2017
|
|
Cached result from stored procedure?
|
|
4
|
1034
|
October 17, 2017
|
|
SQL Query Help
|
|
2
|
475
|
October 17, 2017
|
|
Conversion of hours to minutes using Stored Procedures
|
|
1
|
772
|
October 17, 2017
|
|
Pivot.unpivot
|
|
4
|
535
|
October 16, 2017
|
|
Need matching comma separated value from 1 table column to update in another table column using like
|
|
4
|
630
|
October 16, 2017
|
|
Add row and last found value if row is missing
|
|
4
|
991
|
October 15, 2017
|
|
Get Date From From Calendar As Per Work Day
|
|
2
|
624
|
October 15, 2017
|
|
Calculate LEN with embedded TABs
|
|
5
|
745
|
October 15, 2017
|