7:53 AM
Deep Dey
The following query will list of the Functions that are part of the Database
SELECT * FROM
sys.objects
where type in ('FN', 'IF', 'TF')
SELECT * FROM
sys.objects
where type in ('FN', 'IF', 'TF')
Daily Visits
Date And Time
Updates
-
A common problem you run across in SQL programming is the need to group a series of records that contain bit fields and you need to determi...
-
Here is a short function that is designed to add/subtract business days to a date. The parameters to be passed are the number of business d...
-
********************Youngest & Oldest Employee******************** To get the youngest / olderst employee, two different methods are s...
-
I have an Oracle 10g XE database running on Windows Vista and I want to connect "as sysdba" from Oracle SQL Developer. When I test...
-
From Jamuna, Hyderbad - With Oracle pl/sql if an explicit cursor is opened and we do not close the cursor what will happen? Will the program...
-
No row was updated. The data in row 1 was not committed. Error Source: .Net SqlClient Data Provider. Error Message: Cannot insert the val... -
In a recent project, we had to deal with SQL Server transactions that involved multiple timezones and required us to calculate the time emp...
-
Can I use an Oracle exception like dup val on index to detect if the record exists within the table?Can I use an Oracle exception like dup val on index to detect if the record exists within the table? I'm loading a fact table in a dat...
-
This error occurs when a variable name is preceded by # instead of @. # is used to declare temporary table declare #myi int Should be rep...
-
Get the HOST NAME / COMPUTER NAME Get the Computer Name using SQL Query Select Host_Name() as Computer_Name Get Computer Name, Get HOs...
0 comments:
Post a Comment