You can use the following snippet to quickly find out a column’s name. COL_NAME accepts two parameters: TableID and the ordinal position. SELECT COL_NAME(object_id(‘waybill’),2) AS col_name ? Visit the DevX
You can use the following snippet to quickly find out a column’s name. COL_NAME accepts two parameters: TableID and the ordinal position. SELECT COL_NAME(object_id(‘waybill’),2) AS col_name Related Posts Why AI
Writer w = new OutputStreamWriter(os, “UTF-8”);while (…){ w.write(“something”);} OutputStreamWriter uses memory for each call to its write() methods. This is why it is better to avoid this; if you do
Microsoft applications, such as Word, Excel, PowerPoint, etc., allow you to add frequently used toolbar items that are buried in various menu groups to a section called the Quick Access
Devart, a recognized vendor of professional database tools for developers and DBAs, has released a new version of SecureBridge. An update of SecureBridge components delivers such new features as: * Support for the HTTP and HTTPS protocols is added * The TScHttpWebRequest component to support the request/response model for accessing data using HTTP/HTTPS protocol is added * Performance of downloading and uploading a file using TScSFTPClient is improved * The TScSFTPClient.PipelineLength property to indicate the number of pending requests is added *The TScSSHClientOptions.SocketReceiveBufferSize and SocketSendBufferSize properties to increase socket performance are added SecureBridge protects any TCP traffic using SSH or SSL secure transport layer protocols that provide authentication for both client and server, strong data encryption, and data integrity verification. SecureBridge components can be used in conjunction with data access components to prevent data interception or modification in an untrusted network. Learn more about SecureBridge at https://www.devart.com/sbridge/ About DevartDevart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.Learn more about Devart at https://www.devart.com. Related Posts Learn How to Record Your ScreenEU charges Microsoft over Teams bundlingPDFgear: Edit, Manage, and Collaborate with AIIBM Launches Globalization
The String class facilitates finding the unicode of characters in a String using the codePointAt method. Listing 1. Finding Unicode Characters public class StringCodePoint{ public static void main(String args[]) {
Java provides a very easy mechanism to read jar files. It is the same process used for reading a zip file. The file myFiles.jar contains one or more files (as
The following code snippet shows a small example of how you can sum the result of a count aggregate function. select sum(studentcount) as TotalCountfrom( SELECT count(s.studentname) as studentcount, s.studentname as
You can convert videos in different formats to view them in your browser. An easier way to play video in HTML format is to use YouTube. YouTube generates an automated
Use the string class’s constructor to specify the character and the number of times you want it to be repeated. Listing 1. Repeat String Characters String repeatedCharacterString = new String(‘*’,50);
In nearly all applications, there is critical data that we would not want anyone to see. Java has an easy way of implementing this. All that is required is to
Oftentimes, you might want to understand and control all the threads in your runtime. Java provides an effective and easy mechanism to achieve this using Thread.activeCount() and Thread.enumerate() methods. public
You can handle errors in T-SQL almost the same way as in C# or Visual Basic. You can make use of a Try and catch block to trap errors and
if (name.compareTo(“Jerry”) == 0) …if (name == “Jerry”) …if (name.equals(“Jerry”)) …if (“”.equals(name)) … All the above comparisons are correct, but they are not great. The compareTo method is overkill and
Import the time module and call the time function. The units are in Seconds. See below for an easy example. import timestartTime= time.time()”time consuming stuff”time consuming stuff”time consuming stuffendTime =
We are well aware of validating a Palindrome string. The emphasize here is usage of StringBuffer/Builder and the reverse method to get the string reversed instead of using an interactive
.NET uses SSL3 as the default security protocol for communicating with vendor servers. You can override the default SecurityProtocol used in .NET by setting the TLS 1.2 version explicitly: ServicePointManager.SecurityProtocol
Just type “.” in your run menu, and press Enter. It will open the ???downloads??? folder in Windows folder. Related Posts Geopolitical conflicts threaten Pacific peace, Waqa warnsHow to Cache Query Results2016 Might Be the Last Year BlackBerry Makes PhonesT-SQL FORCEPLANIBM to Focus on Java, Node.js and Swift
Windows Explorer status bar offers rich information about the files being viewed. For any video file, Windows shows the length of the video in the status bar along with the size, date created and other attributes. Related Posts Quickest Way to Copy the Structure of a TableNetChoice sues Georgia over new online lawWhat Makes a Modern Catalog Stand Out?Try to avoid -XX:+UseGCLogFileRotationHow To Start A
Learn how to use FILEPROPERTY to check for free space in a database. SELECT DB_NAME() AS DBName, name AS FileName, size/128.0 AS MB, size/128.0 – CAST(FILEPROPERTY(name, ‘SpaceUsed’) AS INT)/128.0 AS
REPLACE is similar to INSERT command. The REPLACE command behaves as INSERT when there is no record matching the constraints. It still removes the existing records and again acts as
We can use the Sort Method of LINQ, and use the CompareTo delegate. If your List contains collection of objects, where each object has a date identifier, you could use
Most developers work with threads at one point or another. It can be important to know which threads are active to accomplish a given task. The following API activeCount on
You can use the following script to enable TLS 1.2 on a server using PowerShell. $regFile = @”Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINESYSTEMControlSet001ControlSecurityProvidersSCHANNELProtocolsTLS 1.2][HKEY_LOCAL_MACHINESYSTEMControlSet001ControlSecurityProvidersSCHANNELProtocolsTLS 1.2Client]”Enabled”=dword:ffffffff”DisabledByDefault”=dword:00000000[HKEY_LOCAL_MACHINESYSTEMControlSet001ControlSecurityProvidersSCHANNELProtocolsTLS 1.2Server]”Enabled”=dword:ffffffff”DisabledByDefault”=dword:00000000″@Invoke-Command -ScriptBlock {param($regFile) $regFile | out-file
The?following?code?enables?you?to?identify?all?of?your?foreign?keys?in?a?particular?database. DUMMY?TEXT:?This?is?some?dummy?text.?Hopefully?there?is?no?issues?in?submitting?this?tip?on?devx.com SELECT?PKTABLE_QUALIFIER?=?CONVERT(SYSNAME,DB_NAME()),? ???????PKTABLE_OWNER?=?CONVERT(SYSNAME,SCHEMA_NAME(O1.SCHEMA_ID)),? ???????PKTABLE_NAME?=?CONVERT(SYSNAME,O1.NAME),? ???????PKCOLUMN_NAME?=?CONVERT(SYSNAME,C1.NAME),? ???????FKTABLE_QUALIFIER?=?CONVERT(SYSNAME,DB_NAME()),? ???????FKTABLE_OWNER?=?CONVERT(SYSNAME,SCHEMA_NAME(O2.SCHEMA_ID)),? ???????FKTABLE_NAME?=?CONVERT(SYSNAME,O2.NAME),? ???????FKCOLUMN_NAME?=?CONVERT(SYSNAME,C2.NAME),? ???????–?Force?the?column?to?be?non-nullable?(see?SQL?BU?325751)? ???????–KEY_SEQ?????????????=?isnull(convert(smallint,k.constraint_column_id),?sysconv(smallint,0)),? ???????UPDATE_RULE?=?CONVERT(SMALLINT,CASE?OBJECTPROPERTY(F.OBJECT_ID,’CnstIsUpdateCascade’)?? ????????????????????????????????????????WHEN?1?THEN?0? ????????????????????????????????????????ELSE?1? ??????????????????????????????????????END),? ???????DELETE_RULE?=?CONVERT(SMALLINT,CASE?OBJECTPROPERTY(F.OBJECT_ID,’CnstIsDeleteCascade’)?? ????????????????????????????????????????WHEN?1?THEN?0? ????????????????????????????????????????ELSE?1? ??????????????????????????????????????END),? ???????FK_NAME?=?CONVERT(SYSNAME,OBJECT_NAME(F.OBJECT_ID)),? ???????PK_NAME?=?CONVERT(SYSNAME,I.NAME),? ???????DEFERRABILITY?=?CONVERT(SMALLINT,7)???? FROM???SYS.ALL_OBJECTS?O1,? ???????SYS.ALL_OBJECTS?O2,? ???????SYS.ALL_COLUMNS?C1,? ???????SYS.ALL_COLUMNS?C2,? ???????SYS.FOREIGN_KEYS?F? ???????INNER?JOIN?SYS.FOREIGN_KEY_COLUMNS?K? ?????????ON?(K.CONSTRAINT_OBJECT_ID?=?F.OBJECT_ID)?
Do you want to import data from a large SQL file into MySQL? Using the following mechanism, you will be able to import it with the file filename.sql. Just follow
Fiddler comes with a set of very useful tools that will help developers to quickly do some encoding and decoding functions. It is buried under the “Text Wizard.” You can
jQuery developers often use $().ready or $(document).ready to initialize jQuery functions after the HTML page has loaded. However, it is fired when the HTML objects are still being downloaded by the browser
The InternalsVisibleTo?attribute of System.Runtime.CompilerServices?class allows you to expose internal methods of one assembly to another. All you have to do is to specify this in the assemblyinfo.cs?file of the assembly
The following query will produce a list of tables that are referenced by one or more Views: SELECT [table] = s.name + N’.’ + t.name FROM sys.tables AS t INNER