Hello, I am having problem with calling a stored procedure which is having a cursor inside storing a large amount of data. I am able to retreive the a part of data by returning the value in a variable through output parameters. But the problem is that with time the data will increase and the […]
2001-08-21
20 reads
I'm trying to use SQL-DMO to determine the size of the "northwind" database: Dim oSQLServer Dim oDatabase Set oSQLServer = CreateObject("SQLDMO.SQLServer") oSQLServer.Connect "tower2", "sa" Set oDatabase = oSQLServer.Databases("northwind") Msgbox oDatabase.Size but .Size always returns the results in MB (not fine enough for me). For example, on my computer it returns 5 (MB) while EM show […]
2001-08-20
3 reads
hello andy, what i mean by not displayed is that the value for that particular field is being shown as <"Long Text"> and nothing else will try convert ok will let u know if something clicks by using convert thanks keyur
2001-08-17
I am running a local copy of EM and trying to connect my SQL Servers from home.. I am able to ping the boxes when connect through our vpn but I cannot register the dataservers. "access denied" Any ideas?? TIA, Matt
2001-08-16
5 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/telemarketingrevenge.asp
2001-08-16
4 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/computerhaiku.asp
2001-08-16
4 reads
hello, i am having a table in which the value of one field is too long, and it isnot being displayed i tried nvarchar, ntext eveything but its not working any new ideas?? thanks in advance
2001-08-13
2 reads
Hi I have a login table with following fields and data Login LoginID varchar(8) Password varchar (8) The Data is table is Loginid Password Bill Gates Tick Tick123 Now if I am running the query : select * from login where loginid='Bill' and Password=ENCRYPT('GATES'), the query works. It should not work as the data in […]
2001-08-13
2 reads
Does anybody know how can I execute SQL instruction that stored in local variable. For example @var='SELECT AuthorName from Authors'. Variable stoging gives me ability to create dynamic queries.
2001-08-12
3 reads
Recently while working on the SQLServerCentral.com site, Leon Platt ran into an interesting ADO gotcha that he demonstrates in this quick tip.
2001-08-10
3,418 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers