How to check number of objects present in the database?
(In sql ,we use sys.objects)
Similar to this in MySql.
bipinskulkarni
Last Activity: Sep 11 '08, 11:39 AM
Joined: Dec 13 '07
Location:
-
How to count objects in Database?
-
-
Is there a MySQL alternative for the MSSQL XML datatype?
Is there any datatype in MYSQL which replaces XML Datatype?
XML datatype i used in stored procedure for bulk input. -
I want to create aspnet_useers,a spnet_membershi p,aspnet_roles etc in MYSQL to store the login users information.... -
Membership Tables in Mysql
How to create Membership table in MYSQL(Like aspnet_ in Sql Server)? -
Password format
hi all,
what is the password format=1 or passwordformat= 2 in aspnet.membersh ip table?
Also tell what is passwordsalt? -
bipinskulkarni started a topic Conversion failed when converting from a character string to uniqueidentifierin SQL ServerConversion failed when converting from a character string to uniqueidentifier
Hi,
i have a field createdby with datatype GUID.
In following query ,i encountered with the error
"Conversion failed when converting from a character string to uniqueidentifie r"
select
ISNULL(VW_tbl_C hildProducts.cr eatedBy,' ' ) as createdBy
from table.
it is running with sql server 2005, but not supporting by sql 2000.
what is the synax in 2000? -
-
Yes,where dropped tables/Dbs stores?...Leave a comment:
-
Where deleted DB/Tables stores?
When i delete a table or database,
where it sotres?
Like recycle bin is there any sys db to store deleted tables/DBS? -
How to use Print() in cursor?
Hw to use print() in cursor?
plz tel the example. -
Reveres of TOP function?
Is there any function to select records of bottam from table.
Reveres of TOP function? -
Merge two tables in one
I have two tables with same field structure.(5 fields in each).
Table A containing 10 records, and B containing 15.
Both table having first field(id-Pri.Key).
I want to merge two tables in thirdone. -
bipinskulkarni started a topic How to count max(users) created in a particular year using group function.in MySQLHow to count max(users) created in a particular year using group function.
How to count number of users created in a perticular year.
ex.i want to count total number of users created in 2007using query. -
Replace Query
I have 4 records in my table having a field with bit datatype.
I want to change the values of that in one replace statment
without giving where condition.(valu e 0 by 1 and 1 by 0)
Recd 1) 0
2) 0
3) 1
4) 1
No activity results to display
Leave a comment: