Wish list
If you like this blog and want to say thanks in some way, here is my wish-list on Amazon. It'll be very cool to get a gift from my subscribers. Just don't forget to put your name on it -)Tags
Tag Archives: sql
Find workflows triggered on particular fields
This blog is not dead! It’s been a while since my last post here, but I’m back with some fresh ideas and scripts. Thanks to my new assignment with HR.Net. If you would like to find all the workflow triggers … Continue reading
Find start and end of week and day in SQL Server
Yet another attempt to build up a library of SQL Server functions. As I found out, not all my previous functions did work properly in all environments. — finds start of current week for the provided date CREATE FUNCTION [dbo].[fnStartOfWeek] … Continue reading
Find screens that edit particular field in a table
As a follow-up from yesterday post about finding workflows that change field in a table, today I needed to find all the screens that contain particular field from a table. Here is the SQL query: select pppf.folder_name as [Folder], ppf.folder_name … Continue reading
Find workflows that change particular table field
Today my task was to find out what workflows are changing particular field within particular table. I could go through all the workflows and all the data-writers and check. But I have hundreds to choose from, I’ll spend all day … Continue reading
Subscribe community to a user
I’ve been asked today by one of the reader “How to subscribe a user to a community though a back-end”. And here is the answer to the question: There is a stored procedure that will do that for you. The … Continue reading
Execute Stored Procedures From Screens
We discovered a way to execute SQL Stored procedures from HRNET screens, via JavaScript custom script. Nothing new for the world of JS, but new for us. I did not know you can run sql queries from JavaScript… Here is … Continue reading
Change column collation
This is how you can change text column collation to something else ALTER TABLE tableName ALTER COLUMN columnName nvarchar(1000) COLLATE Latin1_General_CI_AS
Import into SQL Server from CSV
This is how to import data from CSV into SQL Server BULK INSERT TableName FROM ‘c:\data.csv’ WITH ( FIELDTERMINATOR = ‘,’, ROWTERMINATOR = ‘\n’ ) GO
Join Update
Update table with entries from other table, with join update table set field1 = other_table.field1, field2 = other_table.field2 from table inner join other_table on other_table.field3=table.field3
Export data as XML
This is how you export XML from SQL Server select * from table for xml auto, elements