Tuesday, March 27, 2012
Biometrics (finger printing scanning devices)
Simon Worth
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e3sZk7dJFHA.3500@.TK2MSFTNGP14.phx.gbl...
> Please fix your clock.
>|||oh never mind. Gotcha!
Simon Worth
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e3sZk7dJFHA.3500@.TK2MSFTNGP14.phx.gbl...
> Please fix your clock.
>sql
BinToBit function
Anyone happen to have a function that does the following:
I have an integer for example 57.
This translates to binary: 111001
I'm looking for a function like this:
Code Snippet
CREATE FUNCTION [dbo].[BinToBit] (@.ValueCol int, @.Number TinyInt)
RETURNS bit AS
If I would call the function:
select dbo.BinToBit(57, 0) it should return 1
select dbo.BinToBit(57, 1) it should return 0
select dbo.BinToBit(57, 2) it should return 0
select dbo.BinToBit(57, 3) it should return 1
select dbo.BinToBit(57, 4) it should return 1
select dbo.BinToBit(57, 5) it should return 1
I've been looking on the net, because I'm convinced someone must have this kind of function, unfortunately haven't been able to find it.
CREATE FUNCTION [dbo].[BinToBit] (@.ValueCol int, @.Number TinyInt)
RETURNS bit AS
BEGIN
RETURN (@.ValueCol & POWER(2,@.Number))
END
|||Ha! Perfect thanks!binnacles
transactions) in SQL Server 2000
Hi,
Did you meant reading the transaction log file;
There is an undocumented command (DBCC LOG) that lets you see the records in
transaction log.
Here is an sample:
DBCC LOG('DBNAME',2)
or there is good tool from Lumigent called Log explorer
www.lumigent.com
Thanks
Hari
MCDBA
"Juan" <anonymous@.discussions.microsoft.com> wrote in message
news:177e901c418ea$f19f4f60$a501280a@.phx.gbl...
> Is there a way to view binnacles (or details of
> transactions) in SQL Server 2000
Binding WebService as Datasource
I've painstakingly managed to get a XmlDocument from a webservice and run this to retrieve data.
However, i cannot bind any of the returned elements to anything. Any help appreciated.
Are you using the XML data processing extension? What is the Query that you are using? More specifically, what is the Element Path for the query?
For more information, take a look at the following article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/RepServXMLDS.asp
Ian
binding textbox with SqlDataSource
Hi,
I wants to bind textbox with sqldatasource in c#.net so I am using following code and has following error...
Source Error:
Line 22:
Line 23: System.Data.DataView dv = (DataView) SqlDataSource1.Select(System.Web.UI.DataSourceSelectArguments.Empty);
Line 24: TextBox1.Text = dv[0]["Proid"].ToString();
Line 25:
Line 26: }
Please, anybody knows solution tell me
Show all your code here, please. Do you have the column "Proid" in your datasource and a TextBox1 in your ASPX page?
binding textbox text to a database field
hello
is it possible to to bind a single field from a database table to a textbox.
I am trying to open a web form with five textboxes on it. When it loads is it possible to have the textboxes filled with a different field from a row in a database, selected with a sql statment.
Thanks in advance NubNub
Wrong Forum.|||Yes, that is quite possible.
But you will get better assistance if you post your question in one of the .NET ASP related forums.
sqlBinding SQL to an IP
I've got SQL 2k5 on a Win2k3 box. I'm trying to find information or a how to on how to set up SQL to only respond to requests on a particular IP
Can anybody point me in the right direction or explain how?
v
HI,
AFAIK you cannot bin SQL Server to respond to particular IP address but you can trick with firewall settings.
HTH
Hemantgiri S. Goswami