00:00 - 19:0019:00 - 00:00
I got stuck on the first question.
http://en.wikipedia.org/wiki/List_of_Asian_countries_by_GDP
http://www.nationsonline.org/oneworld/asia.htm
No "New Zealand" to be seen. Australia is both a country and continent, but New Zealand is not part of it.
I guess you didn't want responses from New...
Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Web Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
I have an ASPState database online, and its log file ASPState_log is growing tremendously. The current size is 536gb.
How can I maintain this log file?
I take a daily backup...
I've got a question. I've programmed a function but im having some problems when i divide 2 numbers using convert. Here is an example:
Declare @A Numeric(18,6)
Declare @B Numeric(18,6)
Set @A = 1
Set @B = 130
If i do the following query the result is : 0.007692307692307692
Select Convert(De...
A quark ( or ) is an elementary particle and a fundamental constituent of matter. Quarks combine to form composite particles called hadrons, the most stable of which are protons and neutrons, the components of atomic nuclei.
Due to a phenomenon known as color confinement, quarks are never directly observed or found in isolation; they can be found only within baryons or mesons.
For this reason, much of what is known about quarks has been drawn from observations of the hadrons themselves.
There are six types of quarks, known as flavors: up, down, strange, charm, bottom, and top.
Up an...
I start with an object ID and a database ID. Inside a user defined function, I want to get the full name and ID of the database, schema, and object. How can I get the schema ID without using dynamic SQL, which is prohibited inside UDFS?
Note:
I can get the database name with DB_NAME
I can get...
Example:
USE AnotherDB
-- This works - same ID as from other DB
SELECT OBJECT_ID('AnotherDB.ASchema.ATable')
-- This works
SELECT OBJECT_NAME(OBJECT_ID('AnotherDB.ASchema.ATable'))
USE ThisDB
-- This works - same ID as from other DB
SELECT OBJECT_ID('AnotherDB.ASchema.ATable')
-- Gives NULL
SEL...
Without more specifics:
CREATE PROCEDURE dbo.UpdateA
AS
BEGIN
SET NOCOUNT ON;
UPDATE A
SET col1 = B.col1 /* , ... */
FROM Adb.dbo.commonTable AS A
INNER JOIN Bdb.dbo.commonTable AS B
ON A.key_col = B.key_col;
INSERT Adb.dbo.commonTable(key_col, col1 /* , ... */)
SELE...00:00 - 19:0019:00 - 00:00
