|
|
-
|
|
Hello
I am facing a problem with one of my SQL database. The problem is database recovery pending.
My database size is around 8.5 GB, it’s a document attachments saving database, I have only 1 table in this database,
I am saving pictures, documents(...
|
|
-
|
|
How do you select Unique values and number of unique in a table ?...
|
|
-
|
|
I have 2 tables,(1st table emp,2nd table city)
1.I want to find employees who is living in more than one city
2.find all employees living in the same city.
empid empname salary mgrid
1 rachel 500 5
2 anna 450...
|
|
-
|
|
Hi Madhivanan,
Why the float datatype is converting into exponentials when we convert to nvarchar
Declare @ContractAmount float
Set @ContractAmount=123456789
Select @ContractAmount,CAST(@ContractAmount as nvarchar(100)) as test
Please help me....
|
|
-
|
|
Hi,
I would like to write CTE Query to get expected results.
Here are the table and expected results.
1)
declare @t table(zid int,dok varchar(100),stawka int)
insert into @t values
(1,'333',10),
(2,'333',10),
(3,'333',20),
(4,'3...
|
|
-
|
|
Select Sum(2) where 1=2
result: NULL
Select 2 where 1=2
result: blank
Regards
gogul...
|
|
-
|
|
Hi..
While connecting with sql server i am getting this message that
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is ...
|
|