I tried to create a function to generate bigint UID based on the timestamp from this solution. While accuracy should be sufficient to avoid collisions, the server obviously does not measure the …

Self-taught beginner here. I want to sort out (old) clients that have last transactions in 2014 but nothing else till date. I tried this: select distinct transact_clntab.chn, transact_clntab….

need to convert this column to row select okeydata from [elo].[dbo].[objkeys] where parentid in ( select parentid from [elo].[dbo].[objekte] inner join [elo].[dbo].[objkeys] on objid = …

I am doing an online course , and I am trying to design a website with a user database . I have built a ” Contact Us” page with a form/table . I cannot make the timestamps show in the rails console $…

I am trying to create a procedure which check whether the number entered (as a nvarchar type) already exists or not. If it exists then the updation takes place, else an error is thrown out to the user….

I have a table that contains a column for images which stores the link of images. The example looks like this: \Images/image1.jpg Now assume my database has more than 1000 records for 1000 images …

In Sql i am having following data on based on Ite and Rev it calculate row num Folder FileName VersionId DocumentID DocumentVersion Rev Ite Duplicate \abc\ abc.sldprt V1 D00001 1 A 1 …

i have this table Row Title Code RegDate Amount ———————————————————- 1 typea 203170 1396/12/29 150760000000 –Eur 1 typea 203251 1396/12/…

2 Stores, each with its sales data per day. Both get equipped with promotion material but not at the same day. After the pr_day the promotion material will stay there. Meaning, there should be a sales …