Question about Computers & Internet

Open Question

SQL query to change t/f to y/n

I have several tables in a db in SQL Server Mgmt. I have several input forms & reports I created in Visual Studio 2010. Working with the hard code is new to me. (In the past I have used other apps that were wysiwyg). I have 3 checkboxes in 1 of the input forms. I want to write a quick query in SQL to change the t/f & null to y/n & null, before it pulls the data into the .net report. I know it's basically Select * From dbo.xxx WHERE ....?? Can someone give me the example of this please??

Posted by on

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

SQL 2008 R2 - MASTER.LDF corrupted without backup


Try this one solution...

1. First Shutdown SQL Server
2. Then move the current database file/rename (do not touch the .ldf)
3. After rename/move db, restart SQL Server
4. Create a new database with same name and log file and location also same
5. Stop SQL Server

Make use of some interesting links which might help you....
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1465-table-in-sql-server-2008-is-corrupted - a lot of guides and tips for corrupted sql server databases
https://repairsql.recoverytoolbox.com/ Recovery Toolbox for SQL Server - free demo version of this tool, if any variant doesn't seem effective

Apr 26, 2015 | Microsoft SQL Server 2008 Enterprise Full...

1 Answer

I am trying to connect to a SQL Server 2005 DB from Visual Studio


You must create an ODBC connection to your SQL database in the Windows Control Panel. Than you can call your ODBC connection via Visual Studio 2005. You can also create a DSN in Visual Studio 2005 and reference in that way. You will not be able to connect to an MDF but instead you have to connect to the SQL Server Service. Of course the username you use to connect must have access that will be created on the SQL server.

Apr 13, 2009 | Microsoft SQL Server 2005 Standard Edition

1 Answer

How do copy a table from an access database in one folder to another access database in another folder through visual basic code


Simple method Open both tables (or create second) and copy each record from source to target through 'do while not eof' or 'for each' syntax.

Second solution create link in target DB for first table, and use SELECT INTO statment in SQL.

Mar 02, 2009 | Microsoft Visual Basic 6.0 for PC

4 Answers

How get sql data backup


there is facility in enterprise manager to take back of database!

Feb 04, 2009 | Keystone Active Server Pages (ASP)/Visual...

1 Answer

Storage of MS-Access 2007


(please refer for www.office.microsoft.com for further information)
Database specifications Attribute Maximum Access database (.accdb) file size 2 gigabytes, minus the space needed for system objects Note NOTE: Although the maximum size for a single database file is 2GB, you can work around this limitation by using a split database. A front-end database file can point to thousands of back-end database files, each of which could be as large as 2GB. For more information, see the topic, Split a database.
Number of objects in a database 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of characters in a password 20 Number of characters in a user name or group name 20 Number of concurrent users 255 Table Attribute Maximum Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048; the actual number might be smaller because of tables opened internally by Access Table size 2 gigabyte minus the space needed for the system objects Number of characters in a Text field 255 Number of characters in a Memo field 65,535 when entering data through the user interface;
2 gigabytes of character storage when entering data programmatically Size of an OLE Object field 1 gigabyte Number of indexes in a table 32 Number of fields in an index 10 Number of characters in a validation message 255 Number of characters in a validation rule 2,048 Number of characters in a table or field description 255 Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes 4,000 Number of characters in a field property setting 255 Query Attribute Maximum Number of enforced relationships 32 per table, minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships* Number of tables in a query 32* Number of joins in a query 16* Number of fields in a recordset 255 Recordset size 1 gigabyte Sort limit 255 characters in one or more fields Number of levels of nested queries 50* Number of characters in a cell in the query design grid 1,024 Number of characters for a parameter in a parameter query 255 Number of AND operators in a WHERE or HAVING clause 99* Number of characters in an SQL statement Approximately 64,000* *Maximum values might be lower if the query includes multivalued lookup fields.
Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections that you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255 default.aspx?assetid=za100776681033 Top of Page
Project specifications The following list of tables is specific to Office Access 2007 projects:
General Attribute Maximum Number of objects in an Access project (.adp) 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of columns in a table 250 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0, 2000 and 2005)
Microsoft SQL Server database Microsoft SQL Server maximum capacity specifications are described in the SQL Server documentation. Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255
Zulfikar Ali

Jan 16, 2009 | Microsoft Computers & Internet

1 Answer

After installing DB2 query is not executing


could you check whether you are connected to the database, where you are trying to create table,

check the database list, then connect to the database you want then execute the table creation ddl,
if no db found then create a database then proceed.

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

Help me....


You have to creat a table in the SQL server db then you can

 

a) use some windows host script or vb to read your data and insert into the db..

 

b)you can also use the acess:

0695665.jpg

Oct 13, 2007 | Microsoft SQL Server Standard Edition for...

1 Answer

SQL server won't work on my laptop


Two ways to access your server. First, make sure the SQL Server Service is running. Start | Run | Services.msc | Enter. Look for Microsoft SQL Server Service and that it's running. Or Look for the SQL Service Broker icon by the clock and see that it's running. The default instance of SQL Server uses the Hostname. Start | Run | Cmd | Enter. The type hostname. This will be the name to access to server. Then type IPCONFIG, this is then the IP address that you could also use to access it.

SQL Server runs on port 1433, so any firewall has to have it open.

Open Query Analyzer, type in the hostname or ip of the local box, type in "sa" and the password for sa (if setup in mixed mode) or Windows Authentication.

Once you login in, you should now see the databases in the Tree on the left side under the Server | Databases node.

Your description though states "SQL Server won't work on my laptop". TO answer this, the only two SQL Editions that work on anything other than "SERVER" software is SQL Professional and SQL Developer. All others have to be on a "SERVER" platform.

Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...

4 Answers

Running SQL queries on Excel


Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
hth

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

42 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...