|
i problem
in a database i do i find how many feilds name id in database
|
|
|
|
|
You have another problem. The inability to read posting guidelines.
You've already posted about this, so don't start a new thread. It's not polite.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Pete O'Hanlon wrote: another problem. The inability to read posting guidelines
|
|
|
|
|
I am using MS Access 2003 with VB.Net 2003. In one of my Table A field(ResignDate) is of type Text
I am writing following query to retrieve the name and other information of employee who resigned before a specific date which is to be given in the condition.....
my query is..
Dim sql16 As String = "SELECT Employee_AutoID,NameInitial,NameInitial+' '+Name " & _<br />
"AS Emp_Name,Designation FROM tblEmployeeMaster " & _<br />
"WHERE Resign_Flag='No' OR CDate(ResignDate)< #" & endDayOFFinancialYear & "# "
what is wrong in the query....
Tirtha
Miles to go before I sleep
|
|
|
|
|
remove Cdate function
resigndate='"+enddayofffinancialyear+"'
|
|
|
|
|
how do we count stored proc in database
how do we count system difined stored proc and userdifined stored proc
|
|
|
|
|
The stored procedures in sql are objects so whenever a stored procedure is created its information is stored in the system table sysobjects, and as it is a sp the type would be 'p'
Thus to know the number of stored procedures for a database the query would be
select count(*) from sysobjects where type='p'
Gautham
|
|
|
|
|
thanks but now i have another problem
in a database i do i find how many feilds name=id in database
|
|
|
|
|
I didnt get that???
Gautham
|
|
|
|
|
i mean that in a database there are three table
emp1
emp2
emp3
all table have a column name id
how to count number of table with column id
|
|
|
|
|
select * from sysobjects t1 join syscolumns t2 on t1.id=t2.id where t2.name="columnname"
i guess, not sure though!
Gautham
|
|
|
|
|
This will show all tables where there is a column named id
SELECT TABLE_NAME
FROM YourDataBase.INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'Id';
Here you are counting how many such cases are in your db.
SELECT COUNT(COLUMN_NAME)
FROM YourDataBase.INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'Id' ;
Note: This is correct for SQL 2005
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it!
|
|
|
|
|
Hi all,
I'm using interopt object to handle data in an excel file, like that:
Excel.Application ExcelObj = new Excel.Application();<br />
<br />
Excel.Workbook theWorkbook = ExcelObj.Workbooks.Open(FilePath, 0, true, 5,<br />
"", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, null, null);<br />
<br />
Excel.Sheets sheets = theWorkbook.Worksheets;<br />
Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(SheetIndex);<br />
<br />
Excel.Range range = worksheet.get_Range(BeginCol + BeginRow.ToString(), EndCol + BeginRow.ToString());<br />
System.Array myvalues = (System.Array)range.Cells.Value2;<br />
With cells formated as DateTime datatype, this method didn't get the correct format...Ex: 04/11/2007, it'll get as 39183.00...
How can I get the correct value? Please help me.
Thank you.
|
|
|
|
|
Hi i have doubt in roles using in vb.net...,
in my sqlserver for a paricular database,i created two application roles..and i given permission for those roles also..,
Now how to tell the roles in vb.net..,
(i.e) how to interact with those roles from vb.net codes...,
I dont know how to interact with those roles...,
so plz give me some idea..,if any sample codes will be there...,
it will be more usefull for me...,
Magi
|
|
|
|
|
i have one column datatype as datetime
i want to reaplce year of all date to 2030
can i use repalce and left functionbut its showing error plz help
|
|
|
|
|
REPLACE and LEFT functions take character expressions.
hope you might have used datetime data directly in the functions.
convert datatime to character and then use it in replace & left
Regards
KP
|
|
|
|
|
You could use:
Column = DateAdd(yy, 2030 - Year(Column), Column)
Wout Louwers
|
|
|
|
|
Can any let me know how to synchronize local server with remote server using SQL SERVER 2005.
SQL Server 2005 will be installed on two PC's. Now i need to synchronize these two PC's.
Which version of SQL Server 2005 should be used, as i use the SQL server 2005 Express edition!
Thanks!!
|
|
|
|
|
Hi,
i need to calculate no of sundays in a month,is there any function in sql server/crystal reports(crystal syntax) to calculate the same? very urgent requirement.
|
|
|
|
|
use datename(dw,date) and use for loop to increment the day value
and count where dw=sunday
i hope this will be help full for you
|
|
|
|
|
hope this is what you are looking for
declare @mth varchar(4), @yr varchar(4), @dt datetime
set @mth = '4'
set @yr = '2007'
set @dt = convert(datetime, '01-' + @mth + '-' + @yr, 103)
-- to get first sunday of the month
select cast(case when ((7 - datepart(dw, @dt)) + 2) = 8 then 1 else ((7 - datepart(dw, @dt)) + 2) end as varchar(5)) + '-' + @mth + '-' + @yr
-- to get number of sundays
select case when (21 + (case when ((7 - datepart(dw, @dt)) + 2) = 8 then 1 else ((7 - datepart(dw, @dt)) + 2) end)) between 24 and 28 then 4 else 5 end
Regards
KP
|
|
|
|
|
hi kp,
thanq u very much,exactly iam searching for the same.
once again thanquuuuu.
|
|
|
|
|
Hi,
I have installed VS 2005 express for C#,C++ and SQL 2005 express. I am having problem to connect to SQL express database from C# and C+
From IDE, data connect -> Add Connection -> choose Data Source -> Microsoft SQL Database File -> Browse -> Select say model.mdf(or any .mdf in the Data directoy)
I always get :
Unable to open "c:\program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\model.mdf". Operatiing System error 32:"32The process cannot access the file beacuse it is being used by another process.)"
An attempt to attach an auto-named database for file "c:\program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\model.mdf" failed. A database with the same name exists,or specified file can not be opened, or is is located on UNC share.
I can access the same database from Microsoft SQL Server Management studio Express. I have also SQL 2000 installed inb the same machine but I don't think that matter - they have different directory,
Can anyone help?
Thanks
-- modified at 22:58 Wednesday 11th April, 2007
|
|
|
|
|
"file:///c:/program%20Files/Microsoft%20SQL%20Server/MSSQL.2/MSSQL/Data/model.mdf"
“Some have an idea that the reason we in this country discard things so readily is because we have so much. The facts are exactly opposite - the reason we have so much is simply because we discard things so readily. We replace the old in return for something that will serve us better.”--Alfred P. Sloan
|
|
|
|
|
i want to encrypt the password fied in my database.
i use MySQL Server
is there anyway to do it by the database or i should make it in my code?
|
|
|
|